Display Subreport's Sum in GH above subreport point

[mulema]

Does anyone have a magic solution to this?
Here is the scenario.
I have a shared variable in a subreport that I am passing to my main report and summing up with data from my main report. I can display summaries of my main Report in GH3,GH2 and GH1.
My subreport's summaries (formula) are in GF3, but I want to display them in GH3, GH2, GH1.

I tried moving my subreport up, inside GH3,GH2 and GH1 but doing so gives me inaccurate summaries.
Please help.

Mulema.

---------------------------------------
GH1
GH2
GH3 (Subreport) is inserted here.
D
GF3 (SubRpt Shared var Data is computed/displayed here)
GF2
GF1

 

[synapsevampire]

You can't really do this.

Besides, if you had 20 GF3 groupings, how would you display them in the GF1/2, as a total of all of them, or?

Perhaps if you supply sample data and expected output there may be another way to approach it.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

I could show you how to print thg GF3 value above the subreport in GH3, but you can't carry this value back to GH2 or GH1.

Could you run another subreport at the GH1 level that reads all of the subreport data for that group? Same with Group 2? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[Madawc]

As kenhamady says, you could only get the result using a duplicate subreport that does the same as the main report.

The thing to remember is that Crystal processes sections in order, so that the subreport results do not exist until after that section has been run. Madawc Williams
East Anglia
Great Britain

 

[mulema]

Thanks.
I will implemet Kenhamady's guidelines to see how it prints out. Will post if successful.

 

[kenhamady]

The trick will be to put the subreport in header A, but put it below some empty space, then underlay the A section. That will allow the formula in B to print above the subreport in A, even though it occurs later. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com