Building report consisting of multiple subreports

[Mishanya]

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.

 

[JBrown]

Hi Mishanya,

I'm not one of the experts on this forum but I did just build a report
consisting of 4 subreports. I can't really anser your questions specifically
but I explain how mine works.

I have 5 tables. 4 of those tables are related to one of those tables. My
database is a 1 to many database. Like you the main table is the Clients and
the other tables are different bits of information that related to the client.

Open report design. Put your title at the top. That was the easy part.

Do your subreports all have different column headings? I am going to assume
that they do. The bad news is that Subreports don't use headers. So by
default your subreports will appear with all this information, but the user
will have no idea what it relates to.

This is why you need to create the groups (Report - Design View - Group &
Sort - Create on Expression (=1 or Fake Header).

Inside each header you will put a subtitle and a subreport.

In the subreport you will COPY (NOT CUT) your page header into your report
header. Just delete whatever text/graphics you had in your subreport report
header.

Once you get used to this workaround it only take a few seconds.

Good luck!

You will end up with:

PRINCIPLE REPORT

Section 1
info
info
info

Section 2
info
info
info

Section 3
info
info
info

 

[JBrown]

Sorry your report would look like this:

PRINCIPLE REPORT

Section 1 Title
HEADER
info
info
info

Section 2 Title
HEADER
info
info
info

Section 3 Title
HEADER
info
info
info