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



How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative..

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

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative..

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

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative..

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

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative..

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

Post New Answer

More Cognos Interview Questions

What are products of cognos?

0 Answers  


can any one say the which is the best performance in framework manager

1 Answers  


How to create a Left Outer Join in FM? Please explain.

2 Answers   Cisco,


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  


What is stitched Query?

5 Answers  


Can you define query studio?

0 Answers  


how to Explain a complex report at the time of interview ? please post the answer very urgent?

3 Answers   HSBC, IBM, TCS,


How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...

2 Answers   HCL, IBM,


If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  


Diff b/w Crossproduct and Outerjoin?

0 Answers   IBM, Mind Tree,


Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers   DELL,


how u provide security to reports??how u provide security to packages ?

5 Answers   Wipro,


Categories