Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Preserving Blanks in fields with a format
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Preserving Blanks in fields with a format
 Login/Join
 
Platinum Member
posted
I have a table that contains fields where zero is a valid number but the fields can also contain blank (null) values which are also valid.

When I add a format to the field in my fex (for example "/D10CBM") the resulting report produces "$0" in place of the null when what I actually want is the null.

Is there a way to preserve the null value and only display $0 when the field contains an actual zero rather than a null?


Thanks in advance for your help!

This message has been edited. Last edited by: manglum,


WebFOCUS 8
Windows, All Outputs
 
Posts: 108 | Registered: July 23, 2015Reply With QuoteReport This Post
Master
posted Hide Post
Manglum,

you want to add missing on to your define field. try this:

MY_FIELD/D10CBM MISSING ON  


also the default value for null is "." if you want to display blank or something else, you need to set that with
  SET NODATA  = '' 


There is also a set command for Null as well. Does the same thing as missing = on, but it turns it on for all fields, not just the one you set it on


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
THATS A WINNER!!!


WebFOCUS 8
Windows, All Outputs
 
Posts: 108 | Registered: July 23, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
You're a Winner Matt Smiler

You too eric, for knowing that and passing it on.

Share the wealth (of information)...




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Preserving Blanks in fields with a format

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.