Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Reports - Null values - formula for checking if several values are null

Hi there

Can anyone help me?

I need to write a formula to check if some of my fields are null, but I'm not sure how to do this.

There are 4 items contained within one field which I need to check to see if they are null / blank and then mark these as 'None'

I've tried the formula below, but now I'm finding that everything is showing as 'None' as it's only checking if they are all filled in.

if {VR_ACCESS_Broker.ACCID} <> 17 and {VR_ACCESS_CHB2B.ACCID} <> 11 and {VR_ACCESS_Fleet.ACCID} <> 9

and {VR_ACCESS_Prefs.ACCID} <> 10 then 'None'

What I really need is to individually check if one or more of the 4 ACCID's are filled in and if not then mark the field as "None".  Obviously there are loads of other ACCID's which are not filled in, so it's not a matter of stating if it doesn't = 9,10,11,17 then mark as 'None'.

I need to find a way to write an 'and / or' command but I don't know how to.

I would be grateful if you could please help.

Many thanks

Louise

Former Member
Not what you were looking for? View more on this topic or Ask a question