subtotal on amount from subreport

[suburbanites]

Hi All,

I am using CRXI SP2. I have the following formulas in my main report:

// on GH4a
WhilePrintingRecords;
Shared NumberVar totamtprev:= 0;

//on GH4b
WhilePrintingRecords;
shared NumberVar totamtprev;
Global numbervar tot_prev:= tot_prev + totamtprev;
totamtprev

//on GF3
WhilePrintingRecords;
Global numbervar tot_prev;
tot_prev

These are my groupings:

sub_hdr
table.object_id
table.summ_acct_id
table.accounts
@accounts


This is all working out well other than I need to be able to do a subtotal on totamtprev for change in @accounts.

Any help will be greatly appreciated.

Thanks

 

[vega83]

Why dont you do subtotals in subreport it self and add those subtotals to main report subtotals

 

[VKZIMM]

In your main report, create a second Numbervar and when you add your totamtprev in GH4b add to this field also. Then clear this Numbervar after you print the subtotal.