Crystal Reports Combining 2 If IsNull

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Combining 2 If IsNull

Author	Message
belfane Newbie Joined: 18 Apr 2013 Online Status: Offline Posts: 21	Topic: Combining 2 If IsNull Posted: 05 Jun 2014 at 8:17am
	Is it possible to combine 2 If IsNull statements to project one outcome? Am I even close? Please see below: if IsNull ({Wonderful.Smile}) then "No Data" else {Wonderful.Smile} or if IsNull ({Wonderful.Eyes}) then "No Data" else {Wonderful.Eyes} Thank you.
	IP Logged


kostya1122 Senior Member Joined: 13 Jun 2011 Online Status: Offline Posts: 475	Posted: 05 Jun 2014 at 8:36am
	try something like this if IsNull ({Wonderful.Smile}) and not(IsNull ({Wonderful.Eyes}) ) then {Wonderful.Eyes} else if not(IsNull ({Wonderful.Smile})) and IsNull ({Wonderful.Eyes}) then {Wonderful.Smile} else if IsNull ({Wonderful.Smile}) and IsNull ({Wonderful.Eyes}) then "no data" else "both fields have data"
	IP Logged

belfane Newbie Joined: 18 Apr 2013 Online Status: Offline Posts: 21	Posted: 05 Jun 2014 at 9:49am
	Thank you kostya1122, it works very well. I'd like to take this one step further. When the result is "no data", I'd like that text color to be red. Where in the formula would I do this? Thanks again!
	IP Logged

belfane Newbie Joined: 18 Apr 2013 Online Status: Offline Posts: 21	Posted: 05 Jun 2014 at 10:04am
	I added this to the text formatting,no errors, but it doesn't work either. If {Wonderful.Smile} = "No Data" Then crRed else If {Wonderful.Eyes} = "No Data" Then crRed Else crBlack
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 05 Jun 2014 at 12:31pm
	Assuming that the formula above that has the "IsNull" in it is called "{@Face}", try this If {@Face} = "No Data" then crRed else crBlack -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

belfane Newbie Joined: 18 Apr 2013 Online Status: Offline Posts: 21	Posted: 06 Jun 2014 at 3:24am
	Thank you hilfy, it worked perfectly!
	IP Logged

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