Shading Every Other Line

[TEM3]

Crystal Reports 11:

Suggestions please for shading every other line (row) in the detail section listing of a report......

 

[lupins46]

Conditional format of the background colour in the details section.

if recordnumber mod 2 = 0 then
crgreen
else
crblue

 

[kskid]

From the report Canvas, right click on the detail secvtion on the left side of the canvas and click on Format Section.
Click on the Color tab and then click on the X+2 next to the background color and enter the following formula

if remainder(RecordNumber,2) = 0 then
//Pale Green like the old greenbar reports
    color(231,255,210)
else
    nocolor

 

[TEM3]

The light green looks great on the screen, but hardly shows on a b&w printout. I take it the three numbers are red/yellow/green?? crgray is a little too dark. What would be a lighter gray (which numbers should I play with)?

 

[kskid]

No, the numbers are for red/green/blue. Anyway try color(230,230,230) for a pale gray

 

[synapsevampire]

You can also just select a lighter color, such as:

if recordnumber mod 2 = 0 then
cryellow

To use the standard RGB model KSKID describes, you can test custom colors by selecting the color for any object and select custom. As you move around, note that the RGB numbers are on the right side.

-k