report-subreport

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

Hi,

I asked a question about getting data from 2 different querries onto one
page and got following suggestion:

half page pulls the data from one query, and the rest
of the page pulls data from another query. If so, place
two subreports on your report, each based on its own
query.

But how do create these two subreports??

Thanks for your help
JP
 
Jean-Paul De Winter said:
I asked a question about getting data from 2 different querries onto one
page and got following suggestion:

half page pulls the data from one query, and the rest
of the page pulls data from another query. If so, place
two subreports on your report, each based on its own
query.

But how do create these two subreports??
Click to expand...


Just like you create any report. After you,ve created the
tow new reports and saved them, just drag and drop them
from the db window to the main report in design view.

The subreport control that displays the report being used as
a subreport has propertiesm Link Master and Link Child that
is used to filter the subreport to the data related to
current record in the main report.

Check Help: Contents - Reports - Advanced Reports -
Subreports
 
Marshall Barton said:
Just like you create any report. After you,ve created the
tow new reports and saved them, just drag and drop them
from the db window to the main report in design view.

The subreport control that displays the report being used as
a subreport has propertiesm Link Master and Link Child that
is used to filter the subreport to the data related to
current record in the main report.

Check Help: Contents - Reports - Advanced Reports -
Subreports
Click to expand...

Ok, this seems to work but,
when I past the reports onto the new report all I see are the details, not
the footer.
On the initial reports, the footers contain a calculation based upon the
numbers shown in the reports detail.
What should I do to get the footers of both reports too?
Thanks
JP
 
Jean-Paul De WInter said:
Ok, this seems to work but,
when I past the reports onto the new report all I see are the details, not
the footer.
On the initial reports, the footers contain a calculation based upon the
numbers shown in the reports detail.
What should I do to get the footers of both reports too?
Click to expand...


Which footers are you talking about? Group Footers, the
Report Foote or the Page Footer??

Note that subreports ignore most everything to do with page
related features.

Group footers and the report footer should display normally
unless you have turned CanGrow off so there isn't space to
display all of the subreport.
 
Back
Top