Interested to Buy Any Domain ? << Click Here >> for more details...
How to add 2 different colors for alternative rows?
i.e in a report all rows colors in alternative colors(2
colors)
- 4 Answers
- 11903 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / v m v k reddy
Suppose you are creating a report with two data items
Customer_Name and Total-sales respectively.
Create two new data items.
1.Dataitem1: Running-count([CUSTOMER_NAME])
2.Dataitem2: Mod([Data Item1],2)
Create a variable :
Boolean [Query1].[Data Item2]=1 or 0
Come to conditional explorer bar, select YES, under
properties select the background color.
Come to conditional explorer bar, select NO, under
properties select the background color.
Save report and run.
IT WILL WORK.
Regards VMVK REDDY
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / pradeep nagireddy
i have three columns like order year ,month,quantity. i
need to display quantity colun each row saparately
for that create one string variable on quantity then select
metadata of quantity.select yes in conditinal explorer.in
propertys select box type = none
save the report and run it
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / viswa
i'm thinking that the answer given by uma is wrong . the ans is
Mod(rownumber(),2)=0 then (1) else (2)
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / uma
We can create a boolean conditional variable. In the
expression defenition pane of it, give mod(rowcount
(dataitem),2)<>0.
| Is This Answer Correct ? | 0 Yes | 6 No |
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
Is it possible to join multiple Databases in a Catalog?
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
What's the differance between each studio in cognos 8?
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
what is exact catalog size?
How to create Events?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
---------------How to identify First Record and Last Record?
Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
Can you define cognos decision stream?
Teradata 
