crystal format alternate rows

[mart1000]

I want to format alternate rows in different background colour in Crystal 8.5

I cant remember how to do this - I think it was on remainder being 1 on record count in format display. can somebody remind me please

 

[lbass]

Go to the section expert->details->color tab->background->x+2 and enter:

if remainder(recordnumber,2) = 0 then
crYellow else
crNoColor

-LB

 

[mart1000]

Thanks, new it was something like that, a while since did this

Just a small point. How can the start of the next group of data start with the same colour ie Need to reset to start at same colour each time. Now this is more tricky

 

[lbass]

Then you should use a running total that resets on change of group. The formula would then be:

if remainder({#yourrt},2) = 0 then
crYellow else
crNoColor

-LB