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