APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
Answers were Sorted based on User's Feedback
Answer / vmvk 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 ? | 16 Yes | 0 No |
Answer / mallika
Create a One Boolean Variable in that write the expression
as mod(RowNumber(),2)=0.
Go 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.
thank you
mallika
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / p. uday bhasker reddy
Develope the list report
then
Create a One Boolean Variable in that write the expression
as mod(RowNumber(),2)=0.
then
And go to the report page select the required colume and go to the properties assign the boolean variable
then
Go 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.
go to the report page
Save report and run.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gopal
create one boolean variable and write a condition
Mod(rownum(),2)=0
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / cognos
Here is a very useful link for Cognos
http://www.cognosasksumeet.blogspot.in
Cheers !
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference b/w mdx and sql?
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!
---------------How to identify First Record and Last Record?
What is Cardinality
im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?
What is content store?
What is called cognos reporting tool?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
what is view? types of views?
How do add dynamic titles in PP?
how to create cubes in transformer ?
what is physical layer and presentation layer?