Warning: The reset/evaluate condition fomula has side effects

[giswzrd]

What does the warning mean:

Warning: The reset/evaluate condition formula you just created has side effects. Do you still want it?

I can find it nowhere in the documentation or the FAQ or the Seagate Knowledge Base.

Thanks

 

[kenhamady]

I have never seen that one.
What version/edition of CR are you using?
What settings did you use? Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[giswzrd]

Sorry. I'm using version 8.01.

This is a Running Total Condition Formula:

GLOBAL numberVar DUCT_TOTAL01 := 0;

IF InStr ({new_combine.F_S}, ".&quot=0 THEN

IF Mid ({new_combine.F_S}, 7, 1)="01" THEN
DUCT_TOTAL01=DUCT_TOTAL01 + {new_combine.F_Q}

I want to look for a period in the F_S field and if does not exist look for a string of "01". If "01" exists I want to increment the total DUCT_TOTAL01 by the quantity F_Q. I receive the warning when I attempt to save and close.

Thank you so much.

Pat Rains

 

[kenhamady]

I will admit that this message is not very helpful, but you are getting this message because you are mixing apples and oranges. You are trying to do running totals both the easy way and the hard way at the same time.

The evaluate condition in a running total field tells it WHEN to increment, not WHAT to increment. You simply want to have the following evaluate formula:

InStr ({new_combine.F_S}, ".&quot=0 and
Mid ({new_combine.F_S}, 7, 1)="01"

You tell it WHAT to summarize in the FIELD TO SUMMARIZE setting, and then pick the operation SUM if you want to accumulate them.


The formula that you are using would be a good running total as a stand-alone formula. This is how we did it before there were running total fields. The only type was the last = should have been := which is the CR asssignment operator.

For more info see the FAQ on running Totals.

Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[giswzrd]

Thank you so much! I knew it had to be me. Your "apples to oranges" comment cleared up a lot. Thank you again.

Pat Rains