suppress page if condition met

[ldejesuspr]

I have a report with two groups:
1. employee Num
2. product id

The report prints a page per employee.

I need to print only if the employee had sales between a range. The range is entered in two paramenter variables. The employee sales total is a running total in the footer of employee num group.

In other words, I would like to suppress all sections if the contidion is met. How can this be accomplished? I already tried the following formula in the suppress blank section of one of the sections:

{#GrandTot} < {?@salesFrom} OR {#GrandTot} > {?@salesTo}

but it does not work, I did no see any difference.

Maybe there is a better way to do this

Help will be appreciated

ldj

 

[lbass]

You won't be able to use a running total for suppression, since it won't be finalized until the end of the group. If you right click on the sales amount field and insert a summary (sum), do you get the correct amount? If so, use the summary in your suppression formula for the detail section and the employee group header and footer sections.

-LB