Banded report by group?

[Matt]

I have a report that I put together that has a cross tab table grouped on TitleUnitEmail address, and TitleNumber.  I'm trying to get a conditional format applied that will alternate the cell color by theTitleNumber group but I can't get it it work right.  For a regular table I know I can add = RowNumber()%2 and set the value to =1 and it works great but I can't figure out how to achieve the same result when I want the band to occur based on the TitleNumber group and not the Row Number.  Help?

[Todor]

Hello Tyler,

The scope that is specified in the RowNumber(scope) data function should be in quotation marks or apostrophes. For example, the Expression should look like this:

=RowNumber('titleNumber')%2

Note that the titleNumber above is the name of the corresponding crosstab2 row group as seen from the screenshots.

However, the above may not display all the rows of a group in the same color, alternating among groups. The reason is that the row numbers will be counted within the group, hence will increase within the group.

I suggest the following expression instead:

=RunningValue("crosstab1", CountDistinct(Fields.group))%2

The CountDistinct aggregate function counts the distinct group values that would remain 1 for the first group, 2 for the second, and so on. The RunningValue data function assures that only the values up to the current one get respected.

I have attached a sample report for reference.

Regards,
Todor
Progress Telerik