Skip to Content
0
Former Member
May 27, 2009 at 08:40 AM

Summarize Shared variabels from subreport

35 Views

HI!

I'm trying to summarqaize a formula field placed after the sub-report. The formula give the right value, but when trying to summarize it, the formula is not an option. Trying manually I get the error message "this field cannot be summaraized". As I understand, this means that fields already included is summarized, but I cant see how????

I have the main report grouped into 2 groups.

The subreport is placed in the details section, and the main formulas are placed after. The formulas are as follows:

Sub-report:

//@avholdt

WhilePrintingRecords;

shared numberVar avholdt := 0;

if {ac_activity.ac_as_recno} = 25 then

(avholdt := 1 ) else

(avholdt := 0);

avholdt

In the main report in the detail section 2b I have:

//@avholdt

WhilePrintingRecords;

Shared numberVar avholdt;

avholdt

In the main report in the detail section 2c I have:

//@sum_avholdt

Whileprintingrecords;

numberVar sum_avholdt;

(sum_avholdt:={@avholdt}/1);

sum_avholdt

My question is:

Why can i not summarize the field @sum_avholdt? I have tried manually in a formula, but this is not working groupwise. I need to summarize this in group 1 and 2, and grand total for the report.