General information
Category:
Reports & Report designer
>In my reports null values appear as .NULL.
>
>I would like to have them appear as something like --- or another N/A-style indicator.
>
>Some of these fields also have expressions already defined such as the one below:
>
>IIF(PartNumber = "V","---",ItemType)
>
>So the solution would have to be incorporated or work around existing expressions.
>
>ANYTHING other than .NULL would be great at this point!
>
>Thank you.
>
>Alan
You can use NVL(yourfield,"") as the field expression in the report if yourfield is expected to contain NULL values and NVL() will return a blank Character string in place of NULL.
Or you could use the print when condition NOT ISNULL(yourfield) and the field will not be printed when the value is NULL.
Or you may use as the field expression IIF(NOT ISNULL(yourfield),yourfield,"Print Anything you want here in place of NULL"), which is basically what NVL() function does, probably more efficiently.
HTH
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only