freereport: How I print NULL instead ZERO at runtime

LuigiLuigi
in FreeReport

Hello,

I need to print NULL instead of the value ZERO at runtime for several fields, about 900, within the report.

I thought of using the OnDrawObject event at runtime, but I don't understand which TfrView property to query to replace the value from ZERO to NULL. Example : if View.???? = 0.00 then View.??? := NULL.

Can anyone suggest the most suitable method without having to intervene on every field of the report?

Thank you.

Comments

  • gpigpi

    Use IIF function

    [IIF([YourDatasetName."YourFieldName"] = 0, 'NULL', [YourDatasetName."YourFieldName"])]

  • LuigiLuigi
    edited March 12

    I have about 900 memos in a report. This feature makes the report unmanageable.

    Thank You.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FreeReportComment As ...

© Vanilla Keystone Theme 2026