Print Page | Close Window

Checking 2 fields for if not isnull Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19922 Printed Date: 28 Apr 2024 at 4:23pm Topic: Checking 2 fields for if not isnull Posted By: fulfilment Subject: Checking 2 fields for if not isnull Date 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. Replies: Posted By: Sastry Date Posted: 21 Aug 2013 at 1:11am Hi Try below one : if not (isnull ({FIELDNAME} and isnull({FIELDNAME2})) then true ------------- Thanks, Sastry Posted By: fulfilment Date 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. Posted By: Sastry Date Posted: 21 Aug 2013 at 3:29am Yes, that is absolutely fine. It works.. ------------- Thanks, Sastry

Print Page | Close Window