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.
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