Problem adding field lengths together. 1

[Stoffel24]

I have the following in a formula:
Local NumberVar H := Len({#ContractTemp}) + Len({#DDPM}) + Len({#DilatTemp}) + Len({#Hard}) + Len({#Contract});

This returns a value of null/blank. However, if I change the formula to read:
Local NumberVar H := Len({#ContractTemp})
I get an answer of 3. Why does the top one not work? Any ideas?

All I really want is a way to find out whether there is anything returned in the above fields. If nothing is returned, then I want to suppress the details section in which this formula appears.

Thanks

 

[Naith]

Why don't you suppress on 'isnull({field})'?

Naith

 

[Stoffel24]

I needed to ensure that the result of every one of the fields was blank which is why I was using a variable. However, your suggestion was useful in that I put the following formula in the suppress section area:

If IsNull({#Ash}) and IsNull({#Contract}) and IsNull({#ContractTemp}) and IsNull({#DDPM}) and IsNull({#DilatTemp})and IsNull({#Hard}) and IsNull({#Max}) and IsNull({#Moisture}) and IsNull({#Roga}) and IsNull({#Soft}) and IsNull({#SoftTemp})and IsNull({#Sulphur}) and IsNull({#Volatiles}) and IsNull({#Dilat}) then true

This did the trick. Thanks a lot Naith.

 

[synapsevampire]

Selecting Suppress Blank Section might handle this for you, dpending upon what you have in the details - no code required.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com