Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?

8 Answers   HSBC,


---------- Purpose of Factless Facttable?

2 Answers   Bank Of America,


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

0 Answers  


what is meaning by Master detailed relationship ? please explain one example

4 Answers  


What is a dimension?

0 Answers  


How to pass parameter value into html design page?

1 Answers  


set scope level in transformer

2 Answers  


i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,


diff b/w layout calculation and query calculation

2 Answers   Cap Gemini,


What are user classes?

1 Answers   HCL,


My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333

1 Answers  


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

8 Answers   HCL,


Categories