By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,576 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Two Detail Sections in a Report?

P: n/a
I have an Access 2000 DB for a financial company. I have the table
structure completed, but I am having trouble with the report.
Basically, I have a Client tbl, a StockShares tbl, and a StockOptions
tbl. One client can have many types of StockShares and StockOptions.
I need to detail the StockShares and StockOptions on one page. The
hierarchy should look like this:

CLIENT NAME [header section]

StockShares [StockShares header]
ABC Company [begin detail section]
DEF Company
GHI Company
JKL Company
Totals [StockShares footer]

StockOptions [StockOptions header]
MNO Company [begin detail section]
PQR Company
STU Company
VWX Company
Totals [StockOptions footer]

So, I can easily get one detail section for the StockShares, but I
cannot figure out how to get two detail sections and footers for each
on the same report. Reports seem to give me only one detail section.

What is the proper way to handle this? Should I be using Subreports in
this instance? If so, do I use one main report and one subreport, or
one main report and two subreports (one for StockShares and one for
StockOptions)?

Many thanks to anyone that can help me on this!

Oct 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dear FixedPower?,

I have had the same situation in a cost report and solve this with sub
reports in the detailed section. But there is a limitation on the number of
sub reports you can handle, as I understand you need 8 sub reports. I do not
know exact the number of limitation but maybe 10.

An other point of attention is the totals of the sub reports. You need a
separate query in which you makeup the correct totals for the combinations
of sub reports and place the report of this total query in the total line of
de detail section.

Kind regards,

Simon
<fi********@yahoo.comschreef in bericht
news:11**********************@m7g2000cwm.googlegro ups.com...
I have an Access 2000 DB for a financial company. I have the table
structure completed, but I am having trouble with the report.
Basically, I have a Client tbl, a StockShares tbl, and a StockOptions
tbl. One client can have many types of StockShares and StockOptions.
I need to detail the StockShares and StockOptions on one page. The
hierarchy should look like this:

CLIENT NAME [header section]

StockShares [StockShares header]
ABC Company [begin detail section]
DEF Company
GHI Company
JKL Company
Totals [StockShares footer]

StockOptions [StockOptions header]
MNO Company [begin detail section]
PQR Company
STU Company
VWX Company
Totals [StockOptions footer]

So, I can easily get one detail section for the StockShares, but I
cannot figure out how to get two detail sections and footers for each
on the same report. Reports seem to give me only one detail section.

What is the proper way to handle this? Should I be using Subreports in
this instance? If so, do I use one main report and one subreport, or
one main report and two subreports (one for StockShares and one for
StockOptions)?

Many thanks to anyone that can help me on this!

Oct 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.