A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

# of subreports in 1 main report?



 
 
Thread Tools Display Modes
  #1  
Old January 15th, 2010, 07:11 PM posted to microsoft.public.access.reports
Gabe
external usenet poster
 
Posts: 83
Default # of subreports in 1 main report?

Is there a limit to the amount of subreports you can put in 1 main report?
I'm using Access 2003. I have like 92 subreports I need in 1 report...or
maybe I'm doing it wrong.

Each subreport is tied to query that filters for division sections based on
a 3 digit code assigned to the section (RDC). So we have like 92 division
sections, for example RDC code 100 - 199 is all Admin, while RDC 200 - 299 is
all Operations, etc...So it comes out to like 92 different sections, I would
like to be able to print them all out at once from 1 main report with each
section on a seperate sheet, but I'm not sure if I can get 92 subreports in 1
main report.

Thanks,
Gabe
  #2  
Old January 15th, 2010, 08:52 PM posted to microsoft.public.access.reports
Clifford Bass via AccessMonster.com
external usenet poster
 
Posts: 150
Default # of subreports in 1 main report?

Hi Gabe,

You should not need any subreports. In your report's query include all
of the fields you need in the main part of the report and in the subreports.
Include the division field. In the report group the data on the division and
set the division group footer's Force New Page property to Yes.

If that does not help, please provide more information about how your
report is to look and the data that goes into it.

Clifford Bass

Gabe wrote:
Is there a limit to the amount of subreports you can put in 1 main report?
I'm using Access 2003. I have like 92 subreports I need in 1 report...or
maybe I'm doing it wrong.

Each subreport is tied to query that filters for division sections based on
a 3 digit code assigned to the section (RDC). So we have like 92 division
sections, for example RDC code 100 - 199 is all Admin, while RDC 200 - 299 is
all Operations, etc...So it comes out to like 92 different sections, I would
like to be able to print them all out at once from 1 main report with each
section on a seperate sheet, but I'm not sure if I can get 92 subreports in 1
main report.

Thanks,
Gabe


--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.