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

  • Thread starter Thread starter Joelk
  • Start date Start date
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

(e-mail address removed) delete the bogus!
 
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.
 
Back
Top