Home
Crystal Reports Training
Crystal Reports XI
Crystal Reports .NET
Crystal Reports Forum
News
Tech Support
Active Topics
Memberlist
Search
Help
Register
Login
Report Design
Crystal Reports Forum
:
Crystal Reports 9 through 2020
:
Report Design
Topic: Checking 2 fields for if not isnull
Oldest Post First
Newest Post First
Author
Message
fulfilment
Newbie
Joined: 28 Jan 2013
Location: United Kingdom
Online Status: Offline
Posts: 5
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 Logged
Sastry
Moderator
Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Posted: 21 Aug 2013 at 1:11am
Hi
Try below one :
if not (isnull ({FIELDNAME} and isnull({FIELDNAME2})) then true
Thanks,
Sastry
IP Logged
fulfilment
Newbie
Joined: 28 Jan 2013
Location: United Kingdom
Online Status: Offline
Posts: 5
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 Logged
Sastry
Moderator
Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Posted: 21 Aug 2013 at 3:29am
Yes, that is absolutely fine.
It works..
Thanks,
Sastry
IP Logged
Printable version
Forum Jump
-- Select Forum --
Announcements
Talk with the Author
Self-Publishing
Job Postings
New feature request
Report Design
Data Connectivity
Technical Questions
Tips and Tricks
Crystal Xcelsius
Report Design
Data Connectivity
Writing Code
Tips and Tricks
Report Design
Data Connectivity
Writing Code
Tips and Tricks
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.
HOME
|
FREE EBOOK
|
PROGRAMMING GUIDE
|
PURCHASE
|
REVIEWS
|
CONTACT ME
|
FAQ
|
LINKS
|
CLICK PLAYS
|
COACH FORUMS
|
TROPICAL FISH
© 2004-2024 Brian Bischof. All Rights Reserved.