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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text Question

Status
Not open for further replies.
yngwie

yngwie

Technical User
Feb 7, 2003
5
DE
I want to display "No comment" if a data field is null on the report, instead of just nothing. Can this be done.
 
Sort by date Sort by votes
In a formula field add the following...

If IsNull({YourDataField}) then
'No Comment'
else
{YourDataField}

If yourdatafield is not a string type then you will have convert it to a string like

If IsNull({YourDataField}) then
'No Comment'
else
ToText({YourDataField})




 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smmt2207
  • Locked
  • Question
Text field formula help
Replies
1
Views
502
hilfy
hilfy
SarahSCPDAdmin
  • Locked
  • Question
Crystal Reports - Group question 1
Replies
2
Views
574
SarahSCPDAdmin
SarahSCPDAdmin
Cpreston
  • Locked
  • Question
Printing Slower with added text box 1
Replies
5
Views
489
kray4660
kray4660
dellguy
  • Locked
  • Question
Possible to show multiple text values in crosstab as summarized fields
Replies
2
Views
258
dellguy
dellguy
mart10
  • Locked
  • Question
format text part in colour
Replies
5
Views
223
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top