Suppressing detail section containing subreports taht do calculations

[rsmitley]

I have two subreports in my detail section that do lookups in conversion tables and pass converted values back for each record.

I then summarize (subtotaling and averaging) the original and converted values in my groupings.

The problem is that one of my reports requires only summary info and if I suppress the detail section, my subreport formulas do not execute and all of my converted summarized data is zero.

Any suggestions?

 

[RobertKaiserIII]

I don't think there's a way to do this. You can make subreports as small as possible, then select the "overlay next section" property, but if your group contains hundreds of records, you'll still get a block of empty space.

If no one can come up with a workaround is there any chance you can move the subreports to your group footers instead? For instance, instead of passing the detail section's record ID to the subreport and having it execute once per record, pass the group ID and have the subreport execute once per group.