Hi,
I have a report that has many many subreports. The subreport is using grouping in the query to create the subreport with detail. I was asked to exclude subreports where the total for that subreport is below a threshold. Let's say $100. The information for the total is in a footer text box. Instead of using the query that I have that creates a subreport even when the total is under $100, I have created a query that calculates the total of the groupings without including the extra information I would need in the detail and I have used that as a join to the data query that I need in the detail and then used that query in my subreport. This does seem to work but I would have to create an additional query for each subreport. I would think there should be an easier way to do this. In the end I would like to know what the total is before formatting the footer on the report so I can determine if I even want to print that report. (Maybe I can cancel the whole report when I do get to the footer, I haven't done that person). Any assistance would be appreciated.