oracle-databaseoracle11goraclereports

Optional text in Oracle reports


I am using Oracle Report Builder 10.1.0. I want to display some optional text in the report. I have written a Format trigger on the text box. When the format trigger returns false, I want blank space instead of the text box. But in my case, when the format trigger returns false, the text box is not holding its space. Instead the report content shifts up. How I can ensure that the text box holds its space and I get blank space when the format trigger is false.


Solution

  • Here's what you should do:

    Now run the report. Even if text item isn't displayed, the frame will still be here, visible, keeping its height (as elasticity is set to "fixed")

    Once you're satisfied how it looks, remove frame's background color, as well as its border.