If field value null Then "N/A" in crystal report

crystal-reports crystal-reports-2008
justaguy picture justaguy · Sep 4, 2015 · Viewed 13.8k times · Source

I have created multiple reports in crystal reports 2008 but can not figure out how to use a conditional statement in the report. The conditional statement is If a field in the report is null, THEN "NA"

Would something like the below in the Format Editor... common tab... suppress section formula work

If isNull({str1.strmname}) THEN
  "N/A"
else
str1.strmname

Thank you :).

Answer

CoSpringsGuy picture CoSpringsGuy · Sep 5, 2015

Create a new formula... Use that code but make sure and place {} around your field in the else portion and place it in the details section or where ever you want the output of {str1.strmname} to be seen on the report.

If isNull({str1.strmname}) THEN
  "N/A"
else
{str1.strmname}

Related questions

How do I point Crystal Reports at a new database

I have a Crystal Reports 2008 user that has over 100 custom developed reports. The reports all query Sql Server databases (SQL 2005). This database server is getting replaced with a new system (running SQL 2008 R2) and the existing databases will be moved …

Read More
Crystal Reports Custom IsNull Function

I am trying to create a custom IsNull Function in Crystal Reports; the function must act the same way as the IsNull Function in MS SQL Server. I want to specify a field, and if the field is null, then …

Read More
extract raw SQL query from a Crystal Report .rpt file

I've got an .rpt file that I did not write and can find no documentation about. I want to be able to review the SQL that is generated from this report so that I can figure out, well, what data …

Read More