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 / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

Reports with SubReports and Parameters

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chip - 28 May 2008 20:47 GMT
Hey everyone...

I have queries set up to get the data that I need.  They are Parameter
queries and I have a form set up to collect the Parameters (in this
case StartDate and EndDate).

I also set up Reports for each query.  I can get each Report to Run
Individually.  What I'm not grasping is, how do I get a Master Report
to Run, ask for the Parameters once, Pass these parameters to each
query/report.  Ultimately, I want all the Reports to be on one master
report.

Check my logic for me.

I click on Report.  The Report OnOpen Event is set to open the Date
Parameters form.  I enter the dates I want, click Ok.  The Ok Click
Event, passes these dates to the underlying query, which returns the
data it gets to the Report.  I can do that without issue.

Where I'm getting messed up is, if I put all these items on one master
report, I have to answer the Date Parameters over and over again for
each queriy/subreport.  How do I get it so the Master Report asks for
the dates once, and then it passes the same dates over and over to
each of the subreports.

And while I have you, does my Master Report have to include anythign
at all?  I've read you have to have some link between the Main Report
and all the sub reports.  What defines a link?  I would like my Master
to include basically nothing (aside from maybe the date the report was
produced) and all the meat of the report located in the SubReports...

chip
Fred - 29 May 2008 15:41 GMT
I noticed that nobody answered.   I only have an answer to 1/4 of your
question.  

"Master" is, of course your terminology.

It sounds to me like you are reallly trying to run a batch of independent
reports, and not somethign that would use subreports.  

Sub reports basically mini-lists under "headings" which are data they are
related to.    

> Hey everyone...
>
[quoted text clipped - 28 lines]
>
> chip
 
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.