Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    ha noi

    Question Unanswered: How to Put page break on Ora Report?

    Hi all,
    I have a program that consolidate data and then print out paper report.
    My data is devided into two main kinds (the 1st and the 2nd) and I want to put each of them on the separate page ( that means when ar the end of 1st I want to insert one page-break).
    any suggesstion, please!

    thanks a lot!

  2. #2
    Join Date
    Apr 2004
    Toronto, Canada
    If you are using Oracle reports:

    I'm assuming that the two sets of data are presented using different frames (repeating frame or group frame)

    If so, then you can go to the property sheet of the frame and set the Page Break property of that frame.

    If you are using SQL*Plus and spooling the output to files:
    One way is to spool the output to two files. And run the two commands from a master file.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts