This will only display 1st part of the page number with resetting to 1 based on the group but not the total. So using it instead of displaying nothing.
This option can be easily done in SSRS 2008 R2 using a property.
Hope this helps some one looking for same solution.
Marked as answer by swapna.anu on Aug 31, 2012 08:11 AM
swapna.anu
Contributor
2658 Points
745 Posts
Page numbers display based on grouping - SSRS report
Aug 24, 2012 03:51 PM|LINK
Hi All,
I am using SSRS 2008 to build a report and I need to display page numbers based on the group like below (displayed in bold)
Page 1 Page 1 of 2
Supplier Name : Supp1
Order Type : Order1
Details of client order 1….
Details of client order 2…
Details of client order 3…
Details of client order 4…
End Of Page
Page 2 Page 2 of 2
Supplier Name : Supp1
Oder Type : order1
Details of client order 5….
Details of client order 6…
Page 3 Page 1 of 1
Supplier Name: Supp1
Oder Type : Order 2
Details of client order 8….
Details of client order 9…
Page 4 Page 1 of 1
Supplier Name : Supp1
Order Type : Order 3
Details of client order 10….
Page 5 Page 1 of 1
Supplier Name : Supp2
Order Type 2
Details of client order 15….
Details of client order 18…
Page 6 Page 1 of 2
Supplier Name : Supp3
Order Type 1
Details of client order 12….
Details of client order 11…
Details of client order 18….
Details of client order 19…
End of PAge
Page 7 Page 2 of 2
Supplier Name : Supp3
Order Type 1
Details of client order 22….
Details of client order 25…
Details of client order 27….
Details of client order 28…
Problem here is I will not know how many page each group will be displayed on to. I tried searching some blogs and made the first part of the page numbers working based on the group using the link http://blogs.msdn.com/b/chrishays/archive/2006/01/05/resetpagenumberongroup.aspx but not able to get total page of the group
Can any one help me with this plz.
Thanks in advance.
syed.iddi
Participant
1688 Points
363 Posts
Re: Page numbers display based on grouping - SSRS report
Aug 24, 2012 03:54 PM|LINK
So even if it physically prints out on the new page, should the page number be displayed based on the group?
swapna.anu
Contributor
2658 Points
745 Posts
Re: Page numbers display based on grouping - SSRS report
Aug 26, 2012 06:32 PM|LINK
Yes. It should display based on the group and same while printing.
swapna.anu
Contributor
2658 Points
745 Posts
Re: Page numbers display based on grouping - SSRS report
Aug 31, 2012 08:11 AM|LINK
I have done this using the below link
http://blogs.msdn.com/b/chrishays/archive/2006/01/05/resetpagenumberongroup.aspx
This will only display 1st part of the page number with resetting to 1 based on the group but not the total. So using it instead of displaying nothing.
This option can be easily done in SSRS 2008 R2 using a property.
Hope this helps some one looking for same solution.