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

tell me two or three issues from client side and how to solve those issues?

0 Answers   TCS,


tell me the creation of Snapshots?

2 Answers  


1. Differences between Merge and Union In Cognos?

0 Answers   Wipro,


what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly

2 Answers   TCS,


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

0 Answers  


What are the components used in web tier?

0 Answers  


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?

0 Answers   IBM,


What is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,


cognos is holap or molap or rolap

7 Answers   Cognizant,


Can you explain model durability?

0 Answers  


------------------What is Focalpoint?

1 Answers  


What are the different ways of adding data in Transformer?

3 Answers   Cognos, IBM,


Categories