1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

Question Posted / cheruvula

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

using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  

What is metric studio?what is score cards and how to implement score cards what is the use of score card?

1 Answers   IBM,

What is the difference btw reportnet - Report studio and cognos 8 - Report studio

3 Answers   Dominion,

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

2 Answers   iFlex,

Difference between Express authoring mode and Professional authoring mode?

2 Answers   Wipro,




What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?

3 Answers  

How many fact tables and dimension tables in your project?

3 Answers   IBM,

Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos

2 Answers   IBM,

What is Report item

1 Answers   TCS,

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  

What is meant by Tabular SQL in Cognos Report net

3 Answers   Infosys,

write a query to display to 10 max record from the employee table?

8 Answers   HCL,

For more Cognos Interview Questions Click Here
Categories