Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Reset Page Number with several groups

edited September 2001 in General
Hi,

Is there a particular way to reset the page number when the report has
several groups ?
For the moment the page number reset is done for only the 1st group but the
page breaking is done for all the groups.
I made a test with the table Items.db on the DBDEMO database.
OrderNO ItemNo
1003 1
1004 1
1004 2
1004 3
1004 4
etc....
I created 2 groups : 1st group on OrderNo, 2nd group on ItemNo. I asked for
page breaking and page number ressetting for each group.
The report breaks correctly for each new OrderNo and each new ItemNo but the
page number ressetting does not follow the page breaking.

the result looks like :
OrderNo ItemNo
1st Page 1003 1 Page 1 Of 1
2nd 1004 1 Page 1 of 4 (I expect page 1
of 1)
3rd 1004 2 Page 2 of 4 (I expect page
1 of 1)
4th 1004 3 Page 3 of 4 (I expect page
1 of 1)
5th 1004 4 Page 4 of 4 (I expect page
1 of 1)

I would have expected the result above if I had the values below in the
table Items.db

OrderNO ItemNo
1003 1
1004 1
1004 1
1004 1
1004 1

Is this behaviour normal for ReportBuilder ?
Do you see how I can get the result I expect ?

Thanks for any tip.

Lila.

Comments

  • edited September 2001
    In the groups dialog, there is a check box to reset the page count to 1 when
    each new group begins printing.


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited September 2001
    Thanks for your response.
    The checkBox had been checked for all the groups but the pageNo is reset to
    1 only for the first group and t the page breaking is done correctly for all
    the groups. Is this a bug ?

    Thanks.
    Lila.

This discussion has been closed.