Two Detail Sections in a Report? - Microsoft Access / VBA

fixedpower

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

Subscribe Reply

4495

Simon

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********@yah oo.comschreef in bericht
news:11******** **************@ m7g2000cwm.goog legroups.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

Similar topics

2169

Reports - Line Spacing in Detail Section

by: Mark Lees | last post by:

I have 3 subreports in my main report. My goal is to get as many rows (lines) in 1 page of a report. How can you maximize the number of lines (rows) on 1 page of the report? I've adjusted all of the sections so they are tight.

Microsoft Access / VBA

5752

Format Detail Section Of A Form

by: Tom | last post by:

In the Developers Handbook, Getz provides a way to create a survey report that displays either a line, Yes/No or multiple choice for each question. It's done by placing three controls (one for each type of answer) in the report's detail section and then making the control appropriate for each question visible in the Format event of the detail...

Microsoft Access / VBA

1595

I didn't know this could be done (rename the Detail section of aForm)

by: Lyle Fairfield | last post by:

I had a Sproc which returned a field called Details. I had the Form Wizard create a continuous form with the Sproc as the RecordSource (as a shell for me to modify). I renamed the Details textbox to txtDetails. Except I didn't. I grabbed DETAIL from the pulldown and renamed it to TxtDetail.

Microsoft Access / VBA

1693

Is this possible in a report?--insert graphics in page header and overlay detail

by: Arnold | last post by:

Hi Everyone; In a report, I've essentially recreated a paper sheet by adding various labels--name, date, problem, year, Progress Notes, etc.--and horizontal lines (people have traditionally written notes). I made all of these in the Page Header section. By the way, this is a report form to track the daily progress of students. --Report...

Microsoft Access / VBA

3147

Problem - HUNDREDS of pages blank detail section

by: Mal Reeve | last post by:

Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates hundreds (perhaps even an infinite loop...I have to break the system to stop the report generating) of pages. While I'm not 100% I think this may...

Microsoft Access / VBA

1711

Two detail section in a report?

by: xian2 | last post by:

Hi All, I have two lists I would like to include in a report as seperate areas of the invoice. One list will be a list of tour days selected The other will be a list of additional costs. So I would like to have two detail sections if possible:

Microsoft Access / VBA

3844

Sub-Report Header Won't Stay With Report Detail

by: Wayne | last post by:

I have several sub-reports in the footer of a main report. In certain situations when one of the sub-reports is pushed down to near the bottom of the page by the sub-reports above it, the sub-report report header will display at the bottom of the page, but the detail displays on the next page. How can I force the sub-report header to...

Microsoft Access / VBA

11738

Hide report (detail) section via Code at Run time

by: sara | last post by:

Hi - Is it possible to hide the detail section of a report at run time? I have a report that prints all details, with summary lines. The user would like the report ALSO with just summary lines. It seems the simplest thing is to run the code (see below) once with the detail section showing, and a second time hiding the detail section. I...

Microsoft Access / VBA

1149

About Sections in DataReports

by: creative1 | last post by:

Hi everyone I have a report that displays a number of fields to display a summary report. One of the fields I want to display on my report isn't part of the main query (For some condition it can be part of that query so I calculate it in a different query) I have to display fields from both queries on one report. For main query I have...

Visual Basic 4 / 5 / 6

7618

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7926

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7679

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

7983

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5514

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3657

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3647

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1228

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

946

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General