Background color

[micro2005]

I am creating a Crystal Report in CR 10 and SQL Server 2000. I need to have the background color for the rows to be changed.

Here is what it should look like.

Row 1 - color 1
Row 2 - color 2
Row 3 - color 3
Row 4 - color 1
Row 5 - color 2
Row 6 - color 3

Can someone please help me with this?

Thanks in advance.

 

[kskid]

Since you did not provide any details, I am assuming the detail section.

From the Report Design tab, right click on the detail section of the left and click on Format Section....

Click on the Color Tab
click on X+2 and enter the following

if remainder(recordnumber,3) = 0 then
color 3
else if
remainder(recordnumber,2) = 0 and
remainder(recordnumber,3) <> 0 then
color 2
else
color 1

Cheers,
-LW

 

[KKond]

select section expert - details - color tab
and write this formula near near x+2

if Remainder (RecordNumber,3) = 0 then
crred
else if Remainder (RecordNumber,3) = 1 then
crwhite
else
crblue

 

[micro2005]

Thanks KKond, your formula worked perfect.