This discussion is archived
1 Reply Latest reply: Dec 4, 2012 8:02 AM by Mike Parr RSS

Page Break in 6i

944993 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points