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!

Paper Layout Print Options

Discussion in 'Oracle Forms and Reports' started by legi0nare, Jul 30, 2012.

  1. legi0nare

    legi0nare Active Member

    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    65
    Location:
    Stalingrad
    Hello,

    I have a receipt paper layout which has two items, now what i need is that to print that receipt five times in single paper layout. Is it possible in reports ??
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    You need to place another repeating frame outside of items repeating frame.

    For that outer repeating frame you need to write query as

    Code (Text):

    SELECT LEVEL FROM DUAL CONNECT BY LEVEL < 6;
     
    BY this you can get those two items 5 times in the report. But if you have more than 2 items then it may breaks from that page. Hope this is for your practice purpose.