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 |
tell me two or three issues from client side and how to solve those issues?
tell me the creation of Snapshots?
1. Differences between Merge and Union In Cognos?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What are the components used in web tier?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What is the use of 'individual data source' option while using filter in query studio?
cognos is holap or molap or rolap
Can you explain model durability?
------------------What is Focalpoint?
What are the different ways of adding data in Transformer?