Focal Point
[CLOSED] Null/MISSING values getting padded with a space

This topic can be found at:

July 30, 2014, 01:15 PM
[CLOSED] Null/MISSING values getting padded with a space
Hi All,

I have a report that is retrieving records from on Oracle database. The report is driven by a dropdown that is populated with data from the same oracle database. Some of the records have null values. When the null values are getting retrieved it appears they are getting padded with a space. So what should be null or '' is now ' '. Since I am using that value to query the database, I am getting no records returned because no records have a value of ' '.

Is there a way to get the padding to stop?

I am using WF 7.6.11 and Oracle 11g.


This message has been edited. Last edited by: <Kathryn Henning>,

WebFOCUS 7.6.8
July 30, 2014, 02:36 PM
Have a look at this about MISSING :
How to manage MISSING

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007