SSRS 2008R2, Unable to Reset Page Numbers
I am using SSRS 2008R2, and can see the BreakLocation, ResetPageNumber, and PageName properties, but am unable to get the reset working. Currently, my dataset has no groups, only detail records, but adding a group on the key field and setting the properties made no difference. The textbox in the footer has this expression in it: =Globals!PageName & ": Page " & Globals!PageNumber & " of " & Globals!TotalPages & " pages" When the report runs, I notice that the PageName is always empty. Setting the InitialPageName made no difference. I have read these: http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx Understanding Pagination in Reporting Services: http://msdn.microsoft.com/en-us/library/dd255278.aspx Thanks Thanks, Corey Furman @ Facebook ______________________________________________________ Please mark posts as answer or helpful when they are.
May 3rd, 2011 1:40pm

It took a colleague pointing it out - I didn't notice that Robert Bruckner's blog post specified Report Designer 3.0. I was setting the correct fields, but I was using VS2008. When I edited the report in the report designer, it works as expected. But it doesn't work from within visual studio. WTF? Thanks, Corey Furman @ Facebook ______________________________________________________ Please mark posts as answer or helpful when they are.
Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2011 2:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics