COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: chinnucognos on 13 Feb 2014 05:26:30 AM

Title: how to create list report with rows in alternate colour
Post by: chinnucognos on 13 Feb 2014 05:26:30 AM
HI everyone,

Can anyone suggest step by step process for to give output in alternate colour.

Eg: report has four coloumns,
output background colour should come white and blue alternatively...
Title: Re: how to create list report with rows in alternate colour
Post by: MFGF on 13 Feb 2014 05:59:16 AM
http://www.cognoise.com/index.php/topic,2973.0.html

Wow! I posted this seven years ago! How time flies!!

MF.
Title: Re: how to create list report with rows in alternate colour
Post by: chinnucognos on 13 Feb 2014 06:26:14 AM
wow...really thanks MFGF.. it worked.
Title: Re: how to create list report with rows in alternate colour
Post by: chinnucognos on 13 Feb 2014 06:45:10 AM
Hi MFGF,
Can you explain why step 6 has to do for the above logic...
Here is ur step 6
6. If your calculations exist in the query but are not shown in the list, select the list using the Select Ancestor button, go to the Properties property, and enable the calculations as properties of the list.

Thanks

Title: Re: how to create list report with rows in alternate colour
Post by: MFGF on 13 Feb 2014 06:55:40 AM
Yep...

If a data item or calculation is in the query but not used in the display, the query minimization rules in Cognos mean that it gets ignored when the report runs because it's not deemed necessary to anything that displays on the page. You can force it to be used / evaluated by making it a property of the list.

MF.
Title: Re: how to create list report with rows in alternate colour
Post by: chinnucognos on 13 Feb 2014 07:27:52 AM
thanks MFGF... above info. added much knowledge to me
Title: Re: how to create list report with rows in alternate colour
Post by: Joker on 03 Mar 2014 05:55:16 AM
http://www.ironsidegroup.com/2012/12/04/highlighting-every-other-row-in-a-report-using-ibm-cognos-workspace-advanced-with-a-twist/

http://www-01.ibm.com/support/docview.wss?uid=swg21370531