Unrelated Subreports on One Report

[echorley]

I am trying to put three reports together on one page as one report. I opened a blank report that has no record source. I then added the three reports as subreports. None of them show up.

The three reports are calcuated queries and are not related to each other in any way. I tried to put all of the information into one query, but kept getting the "query too complex" error, so I broke it up into three different queries. The three reports are then related to the three queries.

Any ideas how to get them on one page as three sub reports?

 

[suepowell]

I think you need to have a field which relates a subreport to a main report.
If these reports do not relate to each other in any way, could you add a control to each of the subreports eg link and set its value to 1 using default value (this would need to be invisible so as not to confuse the readers!)
You could then put this control onto the main form. then link the main form to the subforms using link as the join.

I haven't tried it but I think it might work, let me know how you get on and I will try to help if this doesn't work

Sue