If a WHERE clause fails I get NULLS for the value of the field I'm trying to display. I would like to display 0.00 instead of NULLS. I have tried to use the MISSING command with no success. Can anyone make a suggestion?This message has been edited. Last edited by: Ted Michalski,
7.7.02 Windows EXCEL, PDF, CSV, TEXT
May 10, 2013, 12:19 PM
Did you try using SET NODATA = 0.00 ?
WebFOCUS - ver8201 [ReportingServers: Windows 64bit; Client: tomcat and IIS on windows 2012 AppStudio