Crystal error: A summary has been specified on a non-recurring field.

[Former Member]

Hi,

Im encountering the following error while trying to aggregate a formula field in one of my reports:

"A summary has been specified on a non-recurring field"

The report calls a subreport in the details section which returns a shared currency variable for every record generated. Im capturing this varaiable using a formula field say Temp1 as below,

Temp1

====================

WhilePrintingRecords;

Shared CurrencyVar ExRate;

ExRate

Im using Temp1 in another formula field Temp2 to perform calculation using another formula field as below,

Temp2

=====================

@Temp1 * @Actual

I have to aggregate Temp2 for each group of records the report generates.

But the report isnt letting me do so via the insert menu. On manually adding the sum function in a formula, it says "cannot summarize field". If i add sum(temp2) to an existing formula field on the report, it gives the error 'A summary has been specified on a non-recurring field' while running it.

Have been stuck on this for a while.

Any Pointers will be appreciated.

Thanks

Dhiraj

[Former Member · Accepted solution]

A summary cannot be done on a shared variable or on a formula that has an evaluation time of whileprintingrecords;

A summary can only be done on formuals that are evaluated Whilereadingrecords.or on a database field

[Former Member]

Hi Tushar,

I'm having the same problem with the summarization for a shared varibale between the sub-report and main report.

Did you solve the problem ? If so, how??

TKS!

[Former Member]

I"m not 100% sure about the reason behind this but I think it has something to do with the data not being part of the records on the main report. I've come across it many times myself and the only solution I have ever been able to get work it to create my own calculation for the subtotal, insert it in the same section as @Temp2 and indicate to EvalutateAfter(@Temp2).

Hope this helps, rasinc