How to add 2 different colors for alternative rows?
i.e in a report all rows colors in alternative colors(2
colors)
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 |
what is cube size?
How to Create users in cognos Access Manager from 1) front end 2) back end
What is difference between drill through and drill down?
What is difference between informatica power mart and power center?
What is a Datastore in Cognos?
------Diff B/W DrillThrough and master and Detailed Report?
How do we run stored procedure?
what is filter?give me one example that you created a report in your project?
How will u execute a stored procedute from a reportstudio
what is catalog and types of catalogs in cagnos and which is better?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is architectue of Cognos 8