Crystal Reports IX This field cannot be summarised

[CEG]

There are two groups in a report

Group 1: Region (ie, HomeCounties,Midlands,Scotland)

Group 2: Costcentre (ie, Bracknell,Maidstone,Birmingham,Edinburgh)

One column (shows the cost centre summary) has a summarised field with values

6059
-3643
-288
-11710
60
11164

This should give me a summary value of 1643 in Group 1 footer, but I keep getting the message 'This field cannot be summarised'.

Any help will be greatly appreciated.

Kind regards
CEG

 

[DataDog]

Is the "Number" a number or a varchar?
What's the Crystal Version?
What's the data source?

DataDog
'Failure Is Not An Option'

 

[DataDog]

Is the "IX" in the basic question mean Crystal 9 or did you mean "XI" for 11?

DataDog
'Failure Is Not An Option'

 

[CEG]

Hi,

Crystal Reports Version 9

The number is a number (Insert summary in Group 2 footer)

The data source, ODBC Sql 2000.

Kind regards
CEG

 

[lbass]

Try inserting a summary on the same detail field that you used for your Group #2 summary and this time change the group to Group #1. Let us know if that does not give you the correct value--if it doesn't, you can use a variable to add the summaries in Group #2.

-LB

 

[CEG]

Unfortunately this does not work.

The result of the Summary is

Group 2 Total Sales - Group 2 Budget Sales.

Thanks for your help

CEG

 

[DataDog]

How about a sample of the raw data table, and the expected results?

If multiple tables, please indicate how they are linked.

DataDog
'Failure Is Not An Option'

 

[lbass]

You need to provide more information. Are you saying that the summary in the Group#2 Footer is the following?

sum({table.sales},{table.group2field}) -
sum({table.budgetsales},{table.group2field})

You should then try the following for Group #1:

sum({table.sales},{table.group1field}) -
sum({table.budgetsales},{table.group1field})

Please let us know if that provides the correct figure. If this is not your group #2 summary, please provide the formula you are using.

-LB

 

[CEG]

ColumnG
=Group2
Summary of
({@ActualIncomeCostsDiff}-{@BudgetMargin£})

Column H
Group 2 (this formula in Group 2 footer
(Sum ({@BudgetIncomeVar£}, {@CostCentreSort})
*{@BudgetMargin%CC}
/100)

Column I
Group 2 (This formula in Group 2 footer)
Sum ({@MarginVarianceTotal}, {@CostCentreSort})
-{@MarginVarianceVolumeCC}



Col G Col H Col I
8,358.31 2,299 6,059
-11,891.25 -8,248 -3,643
-1,886.74 -1,601 -286
-25,577.04 -13,867 -11,710
-5,895.39 -5,955 60
5,887.41 -5,277 11,164
-31,004.70 -34,823


Trust this makes some sense.

Kind regards
CEG

 

[lbass]

When posting, you should always provide the contents of nested formulas. Without knowing that, I still cannot tell whether you can simply use formulas that reference a different group level. I also don't know whether you want to add the formulas or do some other kind of summary at the Group #1 level, so for the example below, I'll assume you want to sum them. Anyway, the more complex way would be to use variables. Create these formulas:

//{@reset} to be placed in GH#1:
whileprintingrecords;
numbervar sumG ;
numbervar sumH ;
numbervar sumI ;
if not inrepeatedgroupheader then(
sumG := 0;
sumH := 0;
sumI := 0
);

//{@accum} to be placed in the GF#2:
whileprintingrecords;
numbervar sumG := sumG + {@yourGsummaryformula};
numbervar sumH := sumH + {@yourHsummaryformula};
numbervar sumI := sumI + {@yourIsummaryformula};

//{@displsumG} to be placed in GF#1;
whileprintingrecords;
numbervar sumG;

//{@displsumH}to be placed in GF#1;
whileprintingrecords;
numbervar sumH;

//{@displsumI} to be placed in GF#1;
whileprintingrecords;
numbervar sumI;

-LB