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 Rhinorhino 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
Joined
Feb 7, 2003
Messages
5
Location
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 Question
Text field formula help
Replies
1
Views
712
hilfy
hilfy
SarahSCPDAdmin
  • Locked
  • Question Question
Crystal Reports - Group question
Replies
2
Views
757
SarahSCPDAdmin
SarahSCPDAdmin
Cpreston
  • Locked
  • Question Question
Printing Slower with added text box
Replies
5
Views
726
kray4660
kray4660
dellguy
  • Locked
  • Question Question
Possible to show multiple text values in crosstab as summarized fields
Replies
2
Views
399
dellguy
dellguy
mart10
  • Locked
  • Question Question
format text part in colour
Replies
5
Views
380
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top