Report Builder Page Numbers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Report Builder Page Numbers

Report Builder Page Numbers

Rate Topic

Display Mode

Topic Options

Author

Message

Andrew Lamberth

Posted Wednesday, March 05, 2008 7:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 15, 2011 10:37 AM
Points: 8, Visits: 53

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

Post #464421

colin-625136

Posted Wednesday, March 05, 2008 8:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, August 25, 2008 2:15 AM
Points: 1, Visits: 3

Hi andy I had the same question? Fancy meeting you here

Colin

Post #464468

Adam Haines

Posted Wednesday, March 05, 2008 10:34 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:39 PM
Points: 2,278, Visits: 2,998

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.

My blog: http://jahaines.blogspot.com

Post #464611

Andrew Lamberth

Posted Thursday, March 06, 2008 8:37 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 15, 2011 10:37 AM
Points: 8, Visits: 53

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

Post #464959

Adam Haines

Posted Thursday, March 06, 2008 9:07 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:39 PM
Points: 2,278, Visits: 2,998

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.

My blog: http://jahaines.blogspot.com

Post #465249

« Prev Topic | Next Topic »

Permissions