Skip to Content
0
Former Member
Apr 24, 2014 at 12:37 PM

Evaluation times?

21 Views

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