Information générale
Catégorie:
Gestionnaire de rapports & Rapports
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement