Print Page | Close Window

If IsNull - Error A String is required here

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19371
Printed Date: 29 Nov 2022 at 7:50pm


Topic: If IsNull - Error A String is required here
Posted By: slreyna
Subject: If IsNull - Error A String is required here
Date Posted: 05 Apr 2013 at 9:41am
I get A String is Required here with this formula - can anyone help me identify my problem??
 
//This formula checks to see if DRG expected reimbursement is empty, possibly indicating a Medicaid patient
if IsNull ({HSP_ACCOUNT.DRG_EXPECTED_REIMB}) then "Medicaid"

//If the DRG expected reimbursement is provided, display the value stored in the DRG Expected Reimbursement field

else {HSP_ACCOUNT.DRG_EXPECTED_REIMB}

Thanks!!

-------------
Sheri



Replies:
Posted By: kevlray
Date Posted: 05 Apr 2013 at 11:26am
I am assuming that {HSP_ACCOUNT.DRG_EXPECTED_REIMB} is not a string.  The results from a if statement have to be the same data type.  So the only solution is to convert {HSP_ACCOUNT.DRG_EXPECTED_REIMB} to a string (i.e., totext({HSP_ACCOUNT.DRG_EXPECTED_REIMB}) )


Posted By: slreyna
Date Posted: 05 Apr 2013 at 11:28am
Thank you Big%20smile

-------------
Sheri



Print Page | Close Window