1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Page breaks in Oracle Reports

Discussion in 'Oracle Forms and Reports' started by Julian, Mar 30, 2009.

  1. Julian

    Julian Forum Advisor

    Messages:
    48
    Likes Received:
    1
    Trophy Points:
    90
    Page breaks in Oracle Reports

    I have a report which is being printed to a PDF output file.

    So my report output spans multiple pages ad is printed on both sides. Now according to no. of pages in the records I would want a pagebreak. For example if my record has 3 pages I want the next record to start from a fresh page and not from the back of thrid page.

    How to achieve this in oracle reports 10g. Thanks for your help.
     
  2. juan

    juan Active Member

    Messages:
    18
    Likes Received:
    2
    Trophy Points:
    90
    hi

    I had developed a report once which had a similar situation. To insert Page Breaks you can do one of the following:

    1. Set page break after / before of any object in the report.

    2. Set a Maximum Records per page of repeating frame (if it is required to put a page break for each group)