Highlight Rules: Groups in Table and Cross Tab

Hi,

I would like to set up some highlight rules for the Group row of a Table and in a Cross Tab.
Basically, I would like to perform an operation like the following:
if row.__rownum % 2 Equal to 0 then color=blue.
This should leave one line in the default setting (white) and color the next one blue.

With the Group-Header line in the Table this command doesn't work like desired. I assume it is because there are some hidden detail rows, which he counts and hence the highlighting is not having the desired effect.
I also tried to insert a column which is counting the rows and then try to make up a rule, to color the rows dependent on the value of this column but couldn't find a proper expression.

The problem with the CrossTab is that there is no such thing, like rownum (or at least I cant find one). Is it possible to still have an alternating highlighting from line to line, independent of the value of the row.

I attach the sample file I created.

Thank you for your help!

Evgeny

Find more posts tagged with

Comments

mwilliams

Hi Evgeny,

See the modifications I made to your report. I deleted your highlight rules on the table and made a custom highlight in script. The same logic used on the table works mostly for the crosstab too, as you can see. The only issue there is that the column headers are highlighted left to right before the row headers and measures are highlighted top to bottom. This should get you started though. If you have any issues perfecting it, let me know.

evgeny

Thanks a lot, I need to get used use more scripts in my reports.

Evgeny

mwilliams

No problem.