Using a calculated control in a footer as part of a filter

J

Joelk

The report I'm creating is grouped by customers, then orders, and the
detail is individual order items. There is a footer for each order.

That footer contains a control that calculates the total gross margin
of the items in the detail section of the report.

I want to filter the report so that only the groups with a total gross
margin of less than a specified amount appear.

What I can't get to work is the reference to the value of the
calculated control for gross margin.

Suggestions?

Thanks -

Joel

[email protected] delete the bogus!
 
D

Duane Hookom

I doubt you can use a calculated control as a filter. You could try place
the calculated value in the group header and make it invisible. You can then
try cancel the printing of a section based on the value of this control.
 
Top