What is a SUBREPORT?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to get some information on sub-reports. The definition, how does one
employ them, what "mission" is performed by them, and how to "link objects"
(and why)? Do I need a separate query for one? Can I reuse the same query as
for my "main" report? My reason for asking is that I have multiple
"categories" of data that I want to summarize on the page. What I really need
is the detail data, but all "gathered" by a site (physical building
location), and printed under the category headings. Example:

Site: Site1

Admissions:

John Doe 12/15/2004
Jane wilson 12/22/2004
Frank Burns 12/28/2004

Discharges:

John Q. Public 12/05/2004
Lazarus Long 12/12/2004
Bill Clinton 12/18/2004

Grievances:

My potatoes were too cold (12/05/2004)
Sally got more chicken than me (12/10/2004)

Purchases:

Franks and beans $10 12/02/2004

Computer problems:

None

Meetings:

None
---------------------------------

Like that. It's a summary, but a DETAIL as well, all grouped by site. So I
need the ability to "fill in" the data under each category, as many lines as
are in the data for that month. When I put the data in the DETAIL, I get one
entry per page (I group by Site). When I put the data in the group footer, I
get nothing. I am at a loss as to how to proceed.
 
Dennis,

You do not need a subreport for this issue. Simply create a group header for
both Site and Category, putting thier fields in the group headers for each
with no group footers. After adding your detail fields, this will result in
exactly the format you have outlined.

-Jack
 
A problem exists because ALL the "detail information" in the various
categories can change for each record. The category name itself is just text
to identify which set of detail lines the reader is looking at.
 
Yeah, I read that. Unfortunately, I didn't design the tables, and would not
be allowed to change them. I did figure out how to make it work though. I
embedded multiple "simple" reports into the main. That solved all my issues.
But it was a steep learning curve there for a couple days.

Thanks for your assistance!

Dennis
 
Back
Top