Subreport with shared variables in group footers

[LinPro]

CR8.5 and Oracle 8i

I have two subreport that are displaying and passing shared variables into the main report. These variables are calculated then displayed in the group footer.

ex
grp footer a: subreport1 - shared var1
subreport2 - shared var2

grp footer b: shared var1 + shared var2 (total of both vars)

The issue:
My client wants the two subreport to be displayed after grp footer b. In other words, the two grp footers (a + b) should be switch.
I am assuming, that the subreports need to be processed first, before it get displayed on the main report, it is impossible to do the total of both variables first then displayed the subreports.

If I am wrong, can someone please give me an alternative.

Thanks, Linny

 

[Ngolem]

You are correct....the subreport(s) must be processed first in a previous section.

there are 2 possibliities I can think of:

1. Make all of the sections of Subreports 1 & 2 suppressed so as to make them invisible. Make the subreports as thin as possible in the main report and make the section in which they are contained very thin (essentially making them disappear)

Then regenerate the same subreports again but no shared variable transfer in a later section

This is ok if the Subreports are fast and not repeated very often in making the report (ie...the report does this less than 100 times)

2. Do the same as in the first paragraph of option 1...except have more shared variables...essentially re-creating the subreports from the shared variables. You could then do this in a single section.

Would only be feasible if the subreports were simple. But this would speed up your report especially if the subreports were referenced often in the report.

Not much choices.

Another possiblity (though I have NEVER tried it) could be to make the Section with the subreports underlay the rest of the report. Don't have much experience doing that but would be cool if that was possible.

you would leave space at the top of the section with the subreports so that the values would appear to have been placed there first. Maybe that would work...not sure.

Jim Broadbent

 

[LinPro]

Thanks Ngolem

I actually figured out the result after I posted the question in Tek-Tips.

Linny