Error! Summary has been specified on a non-recurring field

[PatrickIRL]

First let me start by saying that as much as I would like to I absolutely CANNOT post any formulae details.

I get this error when I run a report. There's a formula that contains 2 formulae, which in turn contain more formulae. This goes on for about 7 steps before table names are specified.

What I need to know is what is the usual cause of this error? A colleague hinted that it might be a NULL value somewhere in one of the formulae, is this possible?

The formula is in a group footer, nine groups in total.

If you need any more info, please ask. I know the responses will be limited because I can't post the details but I'm hopeful that I'll be pointed in the right direction.

Thanks in advance

 

[dgillz]

Why on Gods green earth can you not post the formula???

If nulls are the issue, test for nulls first:

if Isnull({YourField}) then A else B

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz