I have a report with 2 groups and a detail section, it only finally shows the group footers which hold assorted summaries and totals.
It is based on (among others) two tables with dates covering various periods, I only want to include the data in the summaries if the date parameters chosen are within criteria in both tables. The subreport uses a running count as a trigger for acceptance of a record in one table which is then compared with the other.
The problem is that this subreport has to be placed in the group header of the inner group, to make the calculations work. So it then appears about 100 times in the report. Even if I hide the rows within the subreport, and make it as small as possible, I still end up with 2 or 3 blank pages in the whole report.
I can't hide or suppress the subreport, if I do, I get zeros back.
Any ideas or explanations?