Error: "The summary/running total field could not be created"

[kedrew]

I am trying to implement Crystal KB Article ID #c2008983, Example 2.

Unlike the example, I have multiple details sections (a,b) and the same for the the group footer.

I formerly had a running total field and several calculated values, which have all been removed (and deleted) from the report.

While I try to add the last formula into the conditional formatting on the details section, I get the error: "The summary/running total field could not be created".

The formula is:

WhilePrintingRecords;
NumberVar Counter;
Counter := Counter +1;

Can anyone tell me why I'm getting the error and/or how to resolve the problem.

Thanks

 

[Ngolem]

change the name of the variable from "counter" to somethingelse...."counter" is a reserved summary word.

"a_counter" for example would work

Jim

 

[kedrew]

I don't think 'counter' is a keyword, as Crystal does not highlight it for either "Crystal Syntax" or "Basic Syntax". However, I did try the suggestion (at this point, I'll try anything) and it didn't help.

I also switched the syntax type from Crystal to Basic, and rewrote the code accordingly - same error message.

Also, I did create a very simple report and followed the KB instructions, using 'counter', and the report worked fine.

The actual report I'm trying to do this with has 2 two group footer sections (GF1a, GF1b) before I add on the section per Crystal's KB, the same with the details section. Details B and GF1a have conditional formatting in them for surpression.

 

[BurningMan]

try removing "WhilePrintingRecords" clause from the formula

 

[chelseatech]

I suspect that removing the "WhilePrintingRecords" will get rid of the error, but will result in the formula not behaving properly.

Are you sure you have had an older version of this formula, and created a summary of it? A formula that has whileprintingrecords cannot be part of a sum, count, average, formula, either directly or indirectly. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm