Dr Watson error/Formula error 1

[Kallen]

I am designing a report in 8.5. I have a formula that is dividing one value from another to show a percentage. The first value at times can be 0. I used this report as a sub report. Whenever I try and refresh the report I get a Dr. Watson error and then get booted out. Does anyone think this may have something to do with the fact that I am trying to divide by 0. I got that error message saying that once. If so, does anyone know what I can put into my formula to prevent the report from getting messed up.

Something like
If {valueOne}=0 then ???
Else ??

Thanks to all of you. This place has proven to be a haven for me whenever I am having problems I can't figure out on my own.

 

[Naith]

If {valueOne}=0 then 0
Else <Your Formula Here>

This error may be forcing your Dr Watson, though it really shouldn't. You should be presented with a Crystal 'Divide by 0' error. Make a backup of your report before you progress, as Dr Watson errors usually highlight more fundamental issues with your application. Try to glean some information from the Watson log next time you get it.

Naith

 

[Kallen]

I am getting
&quot;crw32.exe&quot;
Exception: Access Violation

I am going to tweak my formulas and see it this helps.

Thanks

 

[Naith]

Slow down a sec; let me catch up here...

You're saying that after you put in the Divide By Zero fix, you're still getting a Dr Watson?

At what point did you start getting this Dr Watson? Did you use a function that you hadn't called before? Do you get the Dr Watson error if you run from another machine?

I suspect that you may be getting this because you are doing something which is causing a call to a dll which isn't very healthy. If we can identify the dll, we can blow it away and replace it with a clean version. Otherwise, you could download some of the Weekly Hot Fixes from Crystal support, which may address the issue.

Naith

 

[Kallen]

The Dr. Watson error is only happening w/ this one report. I can't access it from another machine because the only machine that has Crystal besides mine is my laptop which is getting upgraded so I don't have it here.

I did the process of elimination where I deleted each formula to see if it was one of them. Even after I deleted all of the formulas I got the Dr Watson error. I am starting to think the report is a disaster and I am better off creating the whole thing from scratch.

Maybe I should try one of the hot fixes before I do that.

 

[Naith]

Actually what you did was pretty smart; if you're still getting the error after deleting each of the formulas suggests that the report itself might be corrupt.

I don't suppose you made a backup before I suggested it, did you? If not, create a new report, and go into Window/Tile, so that it shares the screen with your original report. Then drag all the formulae into the new report.

Try running the new report after this, and see what you get. If it works, your old file is corrupt. Ditch it.

Naith

 

[Kallen]

I remade the report and now all is working fine. Thanks for the formula for the &quot;0 Values&quot; and for the info about Crystal and hot fixes. I may need some of those for future reference the way things have been going lately. )