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 |
How can we create a dynamic column name in cognos?
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
what is a join? what are the types of joins?
what is the role of cognos comsultant?what actually it means?pls reply
What is main difference mapplets and mapping?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
---------------What is Dimension?
Can you define drill down and drill up?
How to hide value prompt box and list when run report?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?