1 Reply Latest reply: Jan 25, 2013 12:12 PM by monty.latiolais RSS

    Avoid printing of blank page

    984603
      I am having following issue. In reports 10g if there is no data returned by the data model query then is there any way I can avoid blank page to be displayed in the output.
      There is a blank page being printed everytime if there is no output generated. Instead I need to get oracle generated message "this concurrent request did not generate any output"

      Any inputs would be of great help.

      Edited by: 981600 on Jan 14, 2013 7:30 PM
        • 1. Re: Avoid printing of blank page
          monty.latiolais
          981600, (Please include your name)

          This can be accomplished by:

          On the data model: Create a summary object outside of the query that stores a value from the first record returned from the query.

          On the layout model: Create a boilerplate text item "this concurrent request did not generate any output" with a format trigger that renders TRUE if your CS object is NULL.

          Hope this helps.

          Monty