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
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.
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 ;)