Re: shared variables between subreports

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I had a report with about 10 subreports... each was a separate graph or
list which together made a "one page" summary... i found that any data
you wanted "shared" from a subreport had to be in a prior section (like
header 2a before header 2b) before the value(s) could be shared with
the main report.

I'm not sure how you have yours set up... But if you really needed the
summary page first, i think the only way to do it would be to have 2
versions of each subreport... one set are suppressed in a group header
somewhere... but where the values could be shared... and the original
ones are in the report... as you have them now... I have no idea what
that would do for processing speed of the report... or how you load the
recordsets for each report...

luckily i was able to contain my subreports in about 4 footers and my
summary data could be at the end.

Good luck


rameshmeena@xxxxxxxxx wrote:
The report I'm working on has some 15+ subreports. Each subreport with
a different Stored proc as a data source. I have to create a summary
page at the beginning of the main report which summarizes data from all
of these subreports that are to follow.

For this, if I create a shared variable in the very first subreport
(which will be the summary) and have all the other subreports populate
this variable, will it work? Is there a way to set the very first
subreport to draw at the end even though it is present at the
beginning?

thanks

.



Relevant Pages

  • Re: Column Lines
    ... I have been putting the line in the header and the code on the On Format ... > your report. ... > Private Sub Report_Page ... The lines need to go thru all detail and subreports to the ...
    (microsoft.public.access.reports)
  • Re: Report Header and Subreports
    ... Display the Group Header for this section and set its Repeat Section ... The main Master Tracking Report header isn't a concern, ... main report and 10 subreports all with headers. ...
    (microsoft.public.access.reports)
  • RE: Print several reports as one
    ... Each of the subreports can have their own Report Header section. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • RE: Building report consisting of multiple subreports
    ... Like you the main table is the Clients and ... Open report design. ... Do your subreports all have different column headings? ... Inside each header you will put a subtitle and a subreport. ...
    (microsoft.public.access.gettingstarted)
  • Re: combining page numbers for two reports
    ... Access ignores the Page Header and Page Footer of subreports. ... The usual workaround is to create a Group Header in the subreport. ... A blank report with the two sets of report data ...
    (microsoft.public.access.reports)