Two Detail Areas

[shank]

Is it possible to have 2 detail areas in one report? I'd like to list song
titles on the top half of the report and details pertaining to the above
titles on the second half. Obviously, this requires 2 repeat regions. How is
this done?

thanks!

 

[Duane Hookom]

It seems that you could use a subreports. We have no idea what your table
structures are or desired output.

 

[Marshall Barton]

Is it possible to have 2 detail areas in one report? I'd like to list song
titles on the top half of the report and details pertaining to the above
titles on the second half. Obviously, this requires 2 repeat regions. How is
this done?

Normally, this is done by creating a Group header section
(View menu - Sorting and Grouping) for the title and placing
the detailed data in the Detail section.

If that's not the kind of thing you want to do, then try
using one subreport for the titles and another for the
detailed data. You probably want to put them into an
otherwise unbound main report.

 

[shank]

How can I generate a script that illustrates the table designs? In SQL, it's
easy.

I've been experimenting with the subreports and that's not the solution
either. I put 2 subreports in the detail section. 1 line completes in the
top subform, the 1 line completes in the 2nd subreport. I need all the
lines in the top subreport to finish before the 2nd subreport begins. In my
mind, 2 detail sections would fix this. However, I don't see where that's
possible.

Imagine song titles on a CD. I want to list the titles on the top half of
the page. Then list any trivia about each song on the bottom half of the
page.

thanks

 

[Immanuel Sibero]

Shank,

Just as described by Duane and Marshall, you can do this with subreports.

See if this would work:
For simplicity, assume two tables - tblSong and tblSongDetail. There is a
One-to-Many relationship between tblSong and tblSongDetail.
Create two subreports (i.e. Subreport1 and Subreport2). The recordsource of
Subreport1 would be a query containing tblSong only, and the recordsource of
the Subreport2 would be a query containing both tblSong and tblSongDetail
related in a one-to-many fashion.
Create a third report. This report should just be blank (do not bind this to
any recordsource). Insert Subreport1 and Subreport2 in the detail section
(or footer section). Doesnt matter.


HTH,
Immanuel Sibero