I’ve been playing with adding a report as a subform. As far as I know, that means the report is displayed in report view. That means no format event, and there are several other events that don’t fire either.
The worst part is for complicated reports, if you are using a sup-report you can’t shrink it, if there are no related records. If the subreport is really simple 1-line kinda thing, you can manually shrink all the controls to be 1 pixel high, and set its can grow to true. This sorta hides the supreport, but its tedious.
However, the good thing about the supreport, is that it CAN grow, unlike a subform. AND it can have buttons. With a bit of coding as well, you can get some sweet results. Try to take a look at this demo I made:
It starts by showing a subform, then switches to showing a supreport, and then even expands and contracts groups LIVE. Note how the scrollbar stays in place, and doesn’t scroll to the top, as it refreshes.
Its not a complete project yet (You can probably tell ), but I figured I would share it, just for inspiration, and potential feedback.