March 5, 2008 at 7:20 am
Is is possible to add pages numbers to a Report Builder report? From searching the web it would appear that it is not possible (which seems surprising). Although I am able to use some of the reporting services capability to add the date/time in a text box, using the =Globals. ... entry if I try to use =Globals!PageNumber it complains because this is only allowed in a header or footer which you can't get to!
I think it can be achieved by saving the report as an .rdl and using BIDS to modify the report, but this isn't a satisfactory solution for end-users who won't want to use Visual Studio.
Does anyone know if adding page numbers is possible? The users I trained yesterday in the product will not be impressed if it can't be done.
Thanks
Andy
March 5, 2008 at 8:18 am
Hi andy I had the same question? Fancy meeting you here
Colin
March 5, 2008 at 10:34 am
Right-click the report make sure you are showing footer. Drag a textbox into the footer. Set the footer value equal to an expression. Select the page number variable from the global list.
March 6, 2008 at 8:37 am
Adam,
thanks for the reply, but I think you're referring to creating reports using BIDS, not Report Builder which is an application for creating reports from the Reporting Services webpage. If I right-click the report area in Report Builder I get the option to insert Textbox, Picture, Filter Description or Row Count, or go into Page setup which doesn't show anything about headers and footers.
Showing pages numbers is a basic feature reporting tools and I can't believe it been left out of Report Builder, as this devalues the use of the product for end-user report writing considerably.
Andy
March 6, 2008 at 9:07 am
You are right, I was refereing to the report designer in BIDs. You are refereing to the ad-hoc report builder. There should be a similar option for ad-hoc reporting.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply