I have a text field on my report that will not always have data. When this field is blank (NULL) the report will not generate. I want to specify that if the field in the database is NULL that it should report as "N/A", thus allowing the report to generate. The field in question is "dbo.actionplan.actionplanid" and is being called from a joined table in the database per the following query: SELECT dbo.incident.incidentid, dbo.incident.incidentdesc, dbo.incident.incidenttype, dbo.incident.incidentstatus, dbo.incident.incidentdt, dbo.incident.reportedby, dbo.incident.rootcause, dbo.incident.triage, dbo.incident.departmentid, dbo.incidentfind.incidentfinddesc, dbo.incidentfind.investigationlog, dbo.incidentfind.u_response, dbo.incidentfind.u_findinggroup, (select refdisplayvalue from refvalue where reftypeid= 'Findinggroup' and refvalueid=incidentfind.u_findinggroup) reftypedisplay, dbo.incident.explanation, dbo.incident.standardreference, dbo.incident.riskdone, dbo.incident.risknotdone, dbo.incident.locationid, dbo.LV_Query_GetLocPathLabel(incident.locationid,' / ',null) as LocPathLabel, dbo.incident.expirationdt, dbo.incident.u_timepoint, dbo.incident.incidentauditby, dbo.incident.incidentauditdt, dbo.incident.incidentauditreference, dbo.incident.severity, dbo.incident.notes, dbo.actionplan.actionplanid FROM dbo.incidentfind INNER JOIN dbo.incident ON dbo.incident.incidentid = dbo.incidentfind.incidentid INNER JOIN dbo.actionplan ON dbo.actionplan.incidentid = dbo.incident.incidentid WHERE dbo.incident.incidentid = $P{incidentid}
