I have a fairly simple report table grouped by Customer with a single row rule defined to format font and background when the value of "Status" equals "Total O/S" which would result in the last row of each table being formatted. I have done this many, many time before, but for some reason the rule is not being applied correctly. Sometimes it misses rows that meet the criteria (see customer #123 & #76) and sometimes it applies the formatting to rows that do not meet the criteria (see Customer #75).
Has anyone ever encountered this before?
