Multiple Sub Reports on main report

MarionD

Registered User.
Local time
Today, 04:16
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.
 
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 have created a calendar report based on a query with unique Sunday values only. I added seven text boxes across the width of the detail section and added 1, 2, 3, ..6 to the Sunday in the control source like:
=DateAdd("d",1,txtSunday)
I named them Date0, Date1, ...
I added the same "day" subreport to the main report 7 times linking master to the Date0, Date1,...
This created a nice calendar report. You could easily add more text boxes to use in the Link Master/Child properties.
 
TBH I would have thought the reports remained the same, just the criteria changed?
 

Users who are viewing this thread

Back
Top Bottom