Alternate line colours in the detail section with suppressed rows

[Ange62]

If anyone can help I'm using Crystal Reports XI

I have a report that does alternate line colors in the detail section. I have suppressed rows with a sales count less than 5: Now I can not get the line shading to work: the report has a different name on every row.

Formula I'm currently using is located in background color it doesn't work with suppressed rows though


If Remainder (RecordNumber,2)<>0 Then
formula = RGB(214, 214, 198)
else
formula = crWhite
end if

 

[abhi900]

just curious to know that do we actually need to write ENDIF in the last - does it ever make any difference if have not mentioned ENDIF in the last.

I never did that and never faced any issues? but does it resolve the issue if we dnt mention it? try it?

 

[lbass]

Ange62,

You need to build your suppression formula into a running total and then use that in your color formula. Set up a running total that counts some recurring field, evaluates using a formula (enter the opposite of your suppression formula), reset never. Then change your color formula to (Crystal syntax, not Basic ,shown here):

If Remainder ({#yourrunningtotal},2)<>0 Then
RGB(214, 214, 198) else
crWhite

-LB