Nedd help with alternating colored lines with record supression 1

[boardburner]

In CR9
I am having a problem getting my lines (records) to show alternating colored lines. I know on a straight up report with no detail supression formulas running it is just...

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

but I have a detail supression formula of...

if {ipart.iptype}=2
//check for part type
then
{ipart.ippart}=previous({ipart.ippart})
//this eliminates duplicates

How do I get an alternating sequence on the report with this type of supression running??

Thanks
G

 

[dgillz]

Instead of suppressing the records, just exclude them from your report entirely with a record selection formula. If you do that, then this problem goes away.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[vidru]

If dgillz suggestion isn't an option for some reason, try this formula for the color:

WhilePrintingRecords;
NumberVar LineNum;

IF {ipart.ippart} = previous({ipart.ippart})
THEN LineNum
ELSE LineNum := LineNum + 1;

IF Remainder (LineNum, 2) <> 0 
THEN Silver 
ELSE NoColor

-dave

 

[boardburner]

Thanks
I need the other supression formula and this formula for the color works like a champ...!!!

Thanks again
G