Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2005

Tip: Looking for answers? Try searching our database.

What is a SUBREPORT?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dennis - 05 Jan 2005 14:03 GMT
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.
Jack - 05 Jan 2005 15:13 GMT
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

> 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"
[quoted text clipped - 41 lines]
> 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 - 05 Jan 2005 18:05 GMT
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.
PC Datasheet - 05 Jan 2005 19:20 GMT
Go back and look at my response in your post titled "Unusual Report - Help".

--
                                       PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                             resource@pcdatasheet.com
                                www.pcdatasheet.com

> 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.
Dennis - 07 Jan 2005 15:29 GMT
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

> Go back and look at my response in your post titled "Unusual Report - Help".
>
[quoted text clipped - 8 lines]
> text
> > to identify which set of detail lines the reader is looking at.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.