How to add 2 different colors for alternative rows?
i.e in a report all rows colors in alternative colors(2
colors)
Answer Posted / 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 |
Post New Answer View All Answers
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is called Cognos powerplay?
What are all the components of Report Studio?
What are all the types of gateway used in Cognos?
What is the difference between a data mart and a data warehouse?
What is the complex report you faced in real time?
whats the difference between previous version of cognos and cognos 8 BI?
what is the role of cognos comsultant?what actually it means?pls reply
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What is the advantage of using shortcuts?
How to Reset Pagenumbers in one report.
Give me any example of semi and non additive measures?
How to test a cube?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
what is the difference between querystudio in reportnet and cognos8