If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Highlight every second row

Started by b737, 26 May 2014 12:24:17 PM

Previous topic - Next topic

b737

I have crosstab report, where in the rows are current month of the current year and current month of previous year (may 2014/may 2013). I am getting current month from filter using sysdate () so I do not have may 2014 physically on report just Hierarchy Month. I want to highlight data for current month of the current year (in this example may 2014, next month jun 2014), or, every second row.

I have found some tutorials but all of are for list reports, not for crosstab.

Thanks

MFGF

Quote from: b737 on 26 May 2014 12:24:17 PM
I have crosstab report, where in the rows are current month of the current year and current month of previous year (may 2014/may 2013). I am getting current month from filter using sysdate () so I do not have may 2014 physically on report just Hierarchy Month. I want to highlight data for current month of the current year (in this example may 2014, next month jun 2014), or, every second row.

I have found some tutorials but all of are for list reports, not for crosstab.

Thanks

Does this technique from CognosPaul help?

http://www.cognoise.com/index.php/topic,24895.0.html

MF.
Meep!

b737

Quote from: CognosPaul on 22 May 2014 12:05:58 AM

If it's only on alternating on the region, then it's a simple matter of setting a style variable on the region fact cells. Right click on the region node, select member fact cells, and apply the style using the expression:
mod(RowNumber(),2)=1

This is solving all my problems. Thank you for help  ;)