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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report consisting of multiple subreports



 
 
Thread Tools Display Modes
  #1  
Old December 1st, 2008, 04:41 PM posted to microsoft.public.access.gettingstarted
Mishanya
external usenet poster
 
Posts: 197
Default Report consisting of multiple subreports

I 've build a dosen of reports (in shape of tables and charts) summing the
data from different angles. Every report shows gross numbers for all the
clients combined.
Now I want to nest all the reports in one principal report, wich is destined
to be opened from form by selecting cboClientName (ClientID value) and
pressing control button. The report, thus, will be filtered (as all of its
subreports will be linked by child ClientID value) and show the data only for
the chosen client. I plan to have Report Header (1st page with heading and
client' name), the main part (all the subreports), Page Footer with date (on
every page)

Please help me with designing such a principal report (PR):

1) What PR section should I put ClientID control in(wich will serve as a
master link)?
2) What PR section should I nest all the subreports in one by one? This
provided with the fact that the overall length of the subreports combined may
reach 8-9 pages (every subreport fills 1/3 to 1.5 pages length).
3) I also need to insert pagebreaks after every 1 to 3 subreports in order
to start different "subblock" of data from new page.

Thank You in advance.


 




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 07:47 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.