Personalization, Customization and Productivity Tools

[mblocker1]

Is there any way to use a total from a subreport in calculation on main report?

[BShockley]

Yes, you can do this using a shared variable.

[robertcwood]

What you have to do is create a formula in the subreport something like this:

WhilePrintingRecords;
Shared CurrencyVar myTotal := Sum ({Orders.Order Amount})

 And in the main report create a formula something like this:

WhilePrintingRecords;
Shared CurrencyVar myTotal;
myTotal