Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Checking 2 fields for if not isnull Post Reply Post New Topic
Author Message
fulfilment
Newbie
Newbie


Joined: 28 Jan 2013
Location: United Kingdom
Online Status: Offline
Posts: 5
Quote fulfilment Replybullet Topic: Checking 2 fields for if not isnull
    Posted: 20 Aug 2013 at 10:10pm
Hi,

Having some trouble writing a formula where i want 2 fields checked within the 1 formula for if not isnull.

It works fine if i just want the one checked but i need it to check both of them.
Thsi is the formula i have to check one field....

if not isnull ({FIELDNAME}) then true

How would i add an additional field in but still keeping it as one formula?
Anyone have any ideas?

Thanks.
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 21 Aug 2013 at 1:11am
Hi

Try below one :

if not (isnull ({FIELDNAME} and isnull({FIELDNAME2})) then true



Thanks,
Sastry
IP IP Logged
fulfilment
Newbie
Newbie


Joined: 28 Jan 2013
Location: United Kingdom
Online Status: Offline
Posts: 5
Quote fulfilment Replybullet Posted: 21 Aug 2013 at 2:49am
if not (isnull ({FIELD1}) and isnull ({FIELD2}))then true

Perfect, just had to add an additional ) in after the first field, would this still be ok?
It said 'The ) is missing' otherwise.
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 21 Aug 2013 at 3:29am
Yes, that is absolutely fine.

It works..
Thanks,
Sastry
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.