Reset Page Number with several groups
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.
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.
This discussion has been closed.
Comments
each new group begins printing.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com
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.