1 Reply Latest reply: Dec 4, 2012 10:02 AM by Mike Parr RSS

    Page Break in 6i

    944993
      Hi,

      I am new to reports, can any one help me to format this

      Consider this as my table
      S.no, Name and code is column name

      S.No     Name     code
      1     Justin     1000
      2     Raj     1000
      3     sara     1001
      4     kish     1001
      5     vinoth     1002
      6     rep     1003

      When we generate report we will get all the 6 in one page but i need in below format.

      Page 1:
      S.No     Name     code
      1     Justin     1000
      2     Raj     1000

      Page 2:
      S.No     Name     code
      3     sara     1001
      4     kish     1001

      Page 3:
      5     vinoth     1002

      Page 4:
      S.No     Name     code
      6     rep     1003

      This should depend on the column "Code"

      Can anyone help me how to do this.
        • 1. Re: Page Break in 6i
          Mike Parr
          What you need to do is to split the columns from the query into 2 groups - 1for the code and the other for the other columns.
          When you create the layout you can specify the number of records per page for a repeating group Set this to 1 and you will have your result.

          Hope this helps.