Choose only needed subreports

[hilian]

I have a main report and several subreports. The main report will be part of every report produced, but not all subreports will be included each time because some of the time there won’t be any data for a particular report. The subreports also don't need to be in any particular order.



I can imbed all of the subreports in the main report, but when there isn’t any data there will be a blank area on the report. I’m trying to avoid that.

Is there a way that the user could pick only the reports needed, say from a command button on a form, and they would appear one after the other, appearing as a single report, without any empty spaces? Alternately, could I imbed all of the subreports in the main report and automatically exclude a report where there isn't any data, without leaving an empty area?

Many thanks,

Henry

[June7]

To include/not include a subreport would be a design modification of the main report. This means opening in design view and deleting the subreport control and moving other controls to occupy the space and reducing the size of the section then saving the report with the changes. This can be done programmatically but is complicated.

I faced this issue and ended with solution that displays a label control when there is no data.

Another option is to size the subreport control with 0 height and position all the reports just barely one below the other and let them grow as needed. They will still occupy space but maybe not so noticeably.

[hilian]

I tried it. It works. It's exactly the solution I need!! Thank you.