Skip to Content
0
Former Member
Jan 16, 2008 at 03:58 PM

Problems using conditional formatting when using multiple columns

68 Views

Post Author: Peanut

CA Forum: Crystal Reports

I have a Crystal Report where the data are displayed in multiple columns. I want to conditionally format the rows so that they alternate in color. I can use a formula like:

if (RecordNumber mod 2 = 0) then crGreen else crNoColor

This works great for data in a single column. However, it doesn't always work so well with multi-column data. When a new column begins, this formula will still change the color of that piece of data independently of the piece of data to its left. Let me elaborate: if you have 10 records, the data will be colored as follows

1 NoColor 6 Green

2 Green 7 No Color

3 NoColor 8 Green

etc.

Is there a way to prevent this from happening? The easiest way to be to only apply the formula if the record is in the first column. Is there a way to identify which column a record is in? Is there any other easy way to do this? Any help would be appreciated.