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.