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 a scope? can you tell me one example for scope?
is cognos 7 is better than cognos 8
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
Explain what is the difference between microstrategy and cognos reporting tool?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
How do you call a store procedure within a transformation?
What is called Cognos powerplay?
difference between boxtype and visiable
how can you set the image in the report
What are the considerations regarding performance kept in mind while setting up cognos?
..Architectural difference between cognos reportnet and cognos8?
What is the difference between Open Connection command ang Open Session Command?