Combining reports

[MattCollins]

Does anyone know if theres a way to append two access reports (each based on different queries) one on to the end of the other to make one report.

For instance would:

DoCmd.OpenReport Report1name & Report2name, acPreview, , Filterifany

If tweaked be the right way to go?

Cheers,
Matt

 

[KenHigg]

Could you do this as two unrelated sub-reports on a master report?

 

[MattCollins]

Hmmm i'll look into it but i think i may have tried that before, and as the first report creates alot of data and the format of this report is quite important i'm not sure if this works. I'll have a crack at it now and let you know.

Is there no way just to simple add the second report onto the first one....*sigh* lol

Thanks,
Matt

 

[KenHigg]

I'm pretty sure the report/sub-report is the only option... Sorry.

 

[MattCollins]

Didn't work lol, oh well i'll just stick with my five seperate reports lol

Thanks for the advice KenHigg!!

Matt

 

[KenHigg]

Just curious, what didn't work about it?

 

[MattCollins]

Well i added the subreport to the end of the first report and unfortunately it didn't return any data even though i've set the link properties etc.

 

[KenHigg]

You should have had to remove all the master/child link properites completely.

 

[MattCollins]

Ahhhh...hang on, i may have been a muppet (more than likely) thought i had to set the links for the data to filter through....let me try with it being blank lol

 

[MattCollins]

No even worse.....and feel free to laugh...there was no data in the report anyway (slaps himself) works like a treat now thank you so much KenHiggs!!!

 

[MattCollins]

Sorry just a quick question now this seems to work is there anyway to turn off the page header of the main form for when i have my subform appearing...or am i being too ambitious now

 

[KenHigg]

Hum...

Maybe in the main report on open event set the sub forms report header visible property to false?