A string is required here Error in Formula

[cyreports]

I am using this unexpecting value on my Details band to suppress if my paient has work comp. I am getting a string is required here error when it executes in my database. When I check the formula it say no errors but wont work in my db. Can I cast or change this somehow?

{rpPatProfile.WorkersComp} = 0

 

[IanWaterman]

Are you switching dbs

If Crystal sees it as a number in design then it must be a number in database.

From field explorer browse the field {rpPatProfile.WorkersComp} and make sure its a number.

What version of Crystal are you using?

Ian

 

[cyreports]

{rpPatProfile.WorkersComp} is a number. I am using crystal 9. It must be coming from somewhere else then. If I have that as my detail suppress statement, shouldn't other formulas in that section matter since I am suppressing it overall?

For example - in that one detail section i have close to 20 formulas pulling in values. Since the patient met the criteria to not pull this section, shouldnt the formulas within that section not matter? I think it may be a formula or (formulas in that section) thats causing this, but since it shouldnt pull this section back anyways i dont know why that should matter. Maybe it does.

 

[IanWaterman]

Are you sure its the suppression formula failing?

Remove it and place field on table and see what values are returned.

Ian