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 2007

Tip: Looking for answers? Try searching our database.

Subreports and reports

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeff - 14 Jan 2007 14:29 GMT
I have several subreports printing in my report. When I pull up the
subreport, it shows a value of 20 for the total; however, when I pull
up the report, it's showing a value of blank.

Can someone explain what I'm doing wrong?

Thanks

Jeff
Larry Linson - 14 Jan 2007 19:41 GMT
> I have several subreports printing in my report. When I pull up the
> subreport, it shows a value of 20 for the total; however, when I pull
> up the report, it's showing a value of blank.
>
> Can someone explain what I'm doing wrong?

First, just for the record, there is no Access object called a
"Subreport"... there is a Control called a Subreport Control, into which you
can embed a Form or another Report.

And, since you cannot "pull up" a Subreport Control without opening the
Report in which it resides, I am guessing you mean you are independently
opening the same Report that is embedded in a Subreport Control in another
Report. But still...

As you haven't explained what data you have, what the RecordSources of the
two Reports are, how you are determining the totals, whether you are relying
on the total calculated in the Report imbedded in the Subreport Control to
set the total in the main Report, or calculating it separately -- e.g., you
told us little about what you are doing. Thus it is not very likely that
anyone can tell you what is wrong about it.

You have the Database and all this information at hand... but unless you
convey it to us, we don't have much to go on. Provide some specific
information and perhaps someone can suggest a solution.

I'll even guess that one solution might be to set the ControlSource of the
Total in the main Report to a DSum domain aggregate function -- if you were
counting on the calculation in the Report in the Subreport Control being
transferred in some way to the main Report.  The DSum might be a good deal
simpler.

 Larry Linson
 Microsoft Access MVP
 
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.