Alert formula error

[campu5]

I'm a little rusty at Crystal so I am probably missing the obvious. I am trying to create a simple alert based on the sum of total sales by area. The report is grouped by client area with a subtotal of sales for each. I receive an error when I try to save the Alert Condition formula. The formula is:

Sum ({sale.sale_total},{client.client_area}) > 300000.00

The error is:

"One of the previous fields is not constant over group level of this field"

I created a regular formula that is identical, placed it at the group level it works fine...

 

[lbass]

Not sure, but you might have a null sales amount. Go to file->report options->check "convert null to default values" to see if that makes a difference.

-LB

 

[campu5]

Your suggestion made perfect sense. Unfortunately, it didn't work. Like I said, I've never seen this error message...

 

[poujor]

Hi Campu5

Edition?

I assume you have grouping on the field {client.client_area}. If not there is your explanation.

I have had some minor issues (a minor bug) in the Alert Condition formula in CR XI R2 newest SP.

It seems to be like your error. It normally happens when the Alert Condition formula was initially with an error.

Try:
1) delete your existing Alert.
2) save and exit the report
3) reopen the report
4) create a new Alert, ensuring your formula is initially correct

I have succeeded in getting through using this approach - not nice though.

poujor

 

[campu5]

Developer Edition

I followed what poujor suggested and sure enough, I no longer get the error. It also made me remember how I got to that place. I started fiddling with the condition formula because the Alert would not activate.

That is the case now. There are sales by client_area that exceed 500,000.00. However, the Alert does not pop up upon refreshing or re-opening the report.

Any ideas on this problem?

I have not applied any service packs to this installation.

Thanks!