Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Nulls in UDF's

Status
Not open for further replies.
Charliy

Charliy

Programmer
Aug 12, 2008
601
US
I'm currently using Crsytal XI which does not allow the use of ISNULL within a custom function. Do later versions allow this?

My rather awkward workaround is the following ungainly formula to call the function:
artest({I10TST.CODE},(if isnull({I10TST.DX2}) then ' ' else {I10TST.DX2}), (if isnull({I10TST.DX3}) then ' ' else {I10TST.DX3}), (if isnull({I10TST.DX4}) then ' ' else {I10TST.DX4}),(if isnull({I10TST.DX5}) then ' ' else {I10TST.DX5}) )
 
Status
Not open for further replies.

Similar threads

milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
563
hilfy
hilfy
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
322
john432
john432
LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
400
LauraW
LauraW
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
280
SarahSCPDAdmin
SarahSCPDAdmin
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
256
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top