I have a subreport with the formula Adjustedtotal

 

(If IsNUll({PAYMENT.AMOUNT}) Then 0
Else {PAYMENT.AMOUNT})+Sum ({@Adjustedment_Amount})

 

which is in the report footer in the sub report

it then display in the details section of the main report

 

it is grouped by location in the Main.

I want to sum the Adjustedtotal in the group footer in the main report..

 

Im thinking I have to use whileprintingrecords?

But not sure how to setuo.

 

Any ideas, or samples?

 

Thanks

 

 

Can you give me an example of how I do that.. ??

 

Thx

 

 

 

WhileprintingRecords;
shared CurrencyVar totals;

(If IsNUll({PAYMENT.AMOUNT}) Then totals := 0
Else totals :={PAYMENT.AMOUNT})+Sum ({@Adjustedment_Amount})

 

Is this right?

 

then how do total by loaction and grandtotal on the main report??

 

 

0ne to set it to 0 (group header)

One to sum it (per row)

One to display it (group footer)

 

 

in the subreport (SR) you need to sum in order to pass one final value for that instance of the SR to the main report (MR).

In the MR you then also need to sum each row (passed summed sr value).

 

All this being said, i hate subreports (especially on the detail section) and avoid them whenever possible. Sometimes you can't and this might be that time but they tend to kill performance. I try to get everyting into the main report. Then suppress items/rows/groups I do not need. I then use conditionaly running totals (others prefer variable formulas) to get summarized values.