Skip to Content
0
Jun 28, 2020 at 09:31 AM

Crystal colour record results

55 Views

crystal.pngI have a fairly simple report that is giving me the data I want. Problem is I am trying to have every second record highlighted in colour. I have added the colour in my Section Expert, Details and it is almost working. Problem is I have a filter to ignore Open records, ie I only want the closed ones

Not (isnull({CCM_MASTER_2_ACT.CLOSED})) this is working, I have a counter that displays the 'resulting record number'

Shared NumberVar counter;
counter:=counter+1 this is working as well.

I have used the following formula in my Section Expert, details

if {@Counter} mod 2 = 0 then crSilver else CrNoColor

I have also used similar formula using WhilePrintingRecords and get the same problem. Problem is when record 4 is filtered (because it is open) then records 3 and 5 both print in color (or nocolor). I think I need to have the 'Counter' count records after I have filtered out the 'Open" items rather than in the first selection process. Or is there a better way to do this? I have included a .png that shows the issue with items 21 and 25 in the right hand column.

Thanks

Attachments

crystal.png (9.9 kB)