Specifying custom colors for alternating color 1

[kskid]

Crystal 8.5
Oracle DB

I want to use alternating background color on each line in a section similar to the greenbar?

CrGreen and the other colors were too dark and rich for my needs so I developed a lighter shade in Format Section and Color tab and added the following formula, the alternating line came out Black

if remainder(recordnumber,2) <> 0 then crwhite

What am I doing wrong?

 

[kchaudhry]

Try using this:

if Remainder (RecordNumber, 2) <> 0 then Silver else NoColor

Kchaudhry

 

[kskid]

Sorry. Didn't look far enough.

if remainder(recordnumber,2) <> 0 then CrWhite else color(231,249,210)

The numbers inclosed in the parenthesis represent the various shades of Red, Green and Blue, respectively.

 

[kchaudhry]

I am not sure what you are trying to do. I sent you the formula that I have previously used. Maybe someone else can help you with this.

Sorry :-(

Kchaudhry

 

[kskid]

I did not want silver or gray as I am using it in my page header section. color(231,249,210) is a very light shade of green and on a monitor it looks like a greenbar.

 

[kchaudhry]

I tried your formula:

if remainder(recordnumber,2) &lt;&gt; 0 then CrWhite else color(231,249,210)

and it works fine for me.

Kchaudhry