A string is required

[sammybee77]

Hi All,

I have written a formula that reads

if not isnull (field1) then field1 else @formula1

The result of @formula1 is a number however I am getting the error that a string is required, where do I put the string and which do I use?

Many thanks


Sam

 

[kenhamady]

If field1 is a string than you need to say ToText(@formula1) for it to work. THEN and ELSE have to match.

If this doesn't work, please copy and paste the exact formulas into your next post. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com