Hi,
I'll start with the basics...
I have a report pulling in data via a query.
I have formulas such as:
@Type1
formula: {PRODUCT} >= 9600 and {PRODUCT} <= 9610
@Type2
formula: {GROUP} like '1H*'
@Type3
formula: {PRODUCT} = 1000020 or {PRODUCT} = 1155020 or ( {PRODUCT} >= 4904030 and {PRODUCT} <= 4999025 )
( Seven more..)
In order to see what doesn't fall into any of the formulas, I have a suppress formula on the Detail line:
@Type1 or @Type2 or @Type3 ...
Well, that's not working, it filters out maybe 95+%, but many items that meet the suppress are still displaying, and I can see no apparent pattern.
I've tried adding WhilePrintingRecords to the suppress formula, but that it flags it as and error when I try to save.
Halp!
Thanks!
Matt