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: 01 May 2025 at 6:35am
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} ------------- 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  ------------- Sheri |