Add data from subreports and display in main report 2

[nb4884]

Hi All,

Is there a way to get data from 2 subreports and add them as a column in main report ?

Here is what my data looks like:

Subreport 1 Formula 1, Formula 2
Subreport 2 Formula 3, Formula 4

I have these 2 subreports in main report where Subreport 1 displays Formula 1 in a column in main report

And, Subreport 2 displays Formula 3 in a column in main report


Now is there a way where I can display below criteria in a column in main report?
Subreport1Formula2 + Subreport2Formula4


Thanks!

 

[lbass]

In what report section(s) are the subreports located and in what report section do you want to show the results?

-LB

 

[nb4884]

Subreports are located in Group Footer.

Want to display the sum from supreports in group footer as well.

Thanks

 

[crystalkiwibruce]

Save the values in a shared variable using a formula in the subreport, e.g.

Shared Numbervar SubReportTotal1 := ....

retrieve the values in a formula in the main report. Must be in a section after the subreport.
Shared Numbervar SubReportTotal1;
Shared Numbervar SubReportTotal2;

SubreportTotal1 + SubReportTotal2




Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm

 

[nb4884]

Bruce,

What does it mean "Must be in a section after the subreport."

I cant place subreports and the subtotal from subreports in same section , which is group footer?

I have placed 2 sub reports in main report in main report's grp footer. I want to place the sum from these 2 reprots next to subreports so that the 2 subreports and a sum represent 3 columns in a main report.

Thanks

 

[lbass]

Put the subs in GF_a, and the sum in GF_b and then format GF_a to "underlay following sections" in the section expert.

-LB

 

[nb4884]

Thanks