Multiple Sub Reports on main report

MarionD

Registered User.
Local time
Today, 18:51
Joined
Oct 10, 2000
Messages
426
Hi All, Is it possible to use the same sub report on a main report... with a different name.? Scenarion: I have 3 different shifts to be worked at a street festival, Chips stand, Drinks Stand, Cleaning. The same Data, eg. Start time end time is in each shift. I would like to print all three locations on one main report, sort of in different coloumns. I can do it , by creating 3 different sub reports and putting them on the main report, but I have to recreate the report each time, when it is basically the same report, just with different filtered data. After trying all morning I don't think it's possible....
 
Seems possible?
If not, easy enough to copy the report object to a new name and use that.

To get the picture below, I copied the report twice and used the copies in the later two.
Then I amended the source to be the same and the filter and filter on load to yes.
1760791588252.png
 
Last edited:
Belay that. It appears Access put the original values back in and I never noticed. :(

I would go with copying the object to two new reports and use those in the addtional subreport controls.
 
Hi All, Is it possible to use the same sub report on a main report... with a different name.? Scenarion: I have 3 different shifts to be worked at a street festival, Chips stand, Drinks Stand, Cleaning. The same Data, eg. Start time end time is in each shift. I would like to print all three locations on one main report, sort of in different coloumns. I can do it , by creating 3 different sub reports and putting them on the main report, but I have to recreate the report each time, when it is basically the same report, just with different filtered data. After trying all morning I don't think it's possible....
Put the 2 subreports into the main with different links.
 
Hi All, Is it possible to use the same sub report on a main report... with a different name.? Scenarion: I have 3 different shifts to be worked at a street festival, Chips stand, Drinks Stand, Cleaning. The same Data, eg. Start time end time is in each shift. I would like to print all three locations on one main report, sort of in different coloumns. I can do it , by creating 3 different sub reports and putting them on the main report, but I have to recreate the report each time, when it is basically the same report, just with different filtered data. After trying all morning I don't think it's possible....
I think you might be able to accomplish this by binding the main form to a query that has 3 fields for the shifts. You can hide the fields, but use them as the "Link Master Fields" values. That should filter the subreports accordingly.

Not tried, but seems to be possible.
 
you can on forms- I use it for different filters on the same table
 

Users who are viewing this thread

Back
Top Bottom