Reset Page Number for Table object
Hi There
Thanks for your posting. Please have alook on these that might help you
http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx
http://blogs.msdn.com/b/chrishays/archive/2006/01/05/resetpagenumberongroup.aspx
Many thanks
Syed Qazafi Anjum
August 9th, 2012 6:30pm
Thanks all, this did work, I was looking at the Overall Page Number and Overall Total Pages ;-)
Free Windows Admin Tool Kit Click here and download it now
August 12th, 2012 7:28am
Hi,
I have a report which has 2 tables.The report has page break between the 2 tables and has page numbering in the page footer.
At the moment there are 10 pages in total, 5 pages for table 1 and 5 pages for table 2 and the footer shows the pages as 1 of 10.
I want to be able to reset the page numbering on table 2, so when table 2 is shown the page number goes back to 1.
Does anybody now how to do this?
August 12th, 2012 7:30am
Hi,
Hope you are using sql 2008 R2 or report builder 3.0.
Is so, you can select the second tablix, open the property pane and set the values of Pagebreak as shown below.
- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
August 12th, 2012 10:10am
Hi,
Yes I am using ssrs2008 r2/report builder 3.0.
I have gone into the properties for the second table and changed the ResetPageNumber property to True but this doesn't seem to work.
The page numbering does not reset, am I missing something?
Thanks
August 12th, 2012 11:55am
Hi,
For displaying page number use Gobals!pageNumber as explained in post below
http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx
You can set the PageName property on a group and refer to its current value from the page header by referencing
=Globals!PageNameReference overall page number (OverallPageNumber) and total page count (OverallTotalPages), unaffected by page number resets, using
=Globals!OverallPageNumber, and
=Globals!OverallTotalPages.Reset page numbers with each new page break (e.g. on a group) using the
ResetPageNumber property, and reference related page counts (PageNumber, TotalPages) using
=Globals!PageNumber, and
=Globals!TotalPages.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
August 12th, 2012 2:26pm
Hi There
Thanks for your posting. Please have alook on these that might help you
http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx
http://blogs.msdn.com/b/chrishays/archive/2006/01/05/resetpagenumberongroup.aspx
Many thanks
Syed Qazafi Anjum
August 12th, 2012 6:19pm