Cannot get Grand Total in a SubReport

[clydejones]

Hi all,

I have a subReport where I am trying to get the total count for all the groups . I am using the running total wizard and am asking it to count for each record and never change. I then placed this field in the report footer of the subReport. The value I get is the count of the last group not the count of all the groups. Can anyone explain this or tell me how to get a total count of records for all groups in a subReport? Any suggestions would be appreciated.

Thanks,
Clyde

 

[Ngolem]

I don't use running totals so I am not much help there but a manual 3 summ total is easy enough

@Initialization (suppressed in Subreport header)
WhilePrintingRecords;
NumberVar Total := 0;


@CalcSum (suppressed in details)
WhilePrintingRecords;
NumberVar Total ;

Total := Total + {Table.numberfield};


@DisplayTotal (Placed in Report footer)
WhilePrintingRecords;
NumberVar Total ;

"This is the total:" + Totext(Total,2);


This is the simplest form which can of course be dressed up as you wish but it will certainly give a total for all groups





Jim Broadbent