SQL 2005 SSRS - Report Builder Default Page settings - How to Change?

kpetobo
kpetobo used Ask the Experts™
on
We've deployed SQL Server 2005 Reporting Services, and made the Report Builder available to users so that they can build ad-hoc reports.
The problem is that when you use Report Builder to create a new report (based on previously defined models), the 'default' page is North American in format; i.e. page size Letter, units in inches, etc. Problem is that we are in the UK and need these values to default to A4 paper size and centimeters.
Can anyone provide information or a link to how one adjusts the 'normal' template for SSRS?

Many Thanks,
Kevin
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
How to: Set the Locale for a Report or Text Box (Report Builder 3.0 and SSRS)
http://msdn.microsoft.com/en-us/library/ms159642.aspx

Author

Commented:
Icohan,
Thanks for the information; unfortunately it doesn't answer my question on two levels:
1. The document at the link discusses settings for a singular report. We've worked out how to change things on a report, once created (even if still blank). What I am looking for is how to set the 'Defaults'.
2. I had hope with the second part of the first papragraph saying that the server will pick up the settings from the locale of the operating system on the Report Server... then I notices that the page was for SQL 2008. Switching over to the 'Other Version' for SQL 2005 and the same statement isn't made. Anyway, it is worth my checking, as the locale setting for the server may have been set incorrectly when the machine was commissioned.

I let you know if that solves the problem.

Author

Commented:
Unfortunately Icohan's solution did NOT solve the problem. The Locale settings of the server have been confirmed as United Kingdom.
Anyone else before I close the question and wade into the Support forums?
Commented:
I've found that by checking the 'Locale' setting for the Model used by  Report Builder that we can force the software to present dates, currency, etc. in UK format. Still no idea how to get it to use A4 instead of letter.
Guess I will close this, as no one seems to be answering.

Author

Commented:
I appreciate Icohan's input, but it was nothing I hadn't already found. The question asked specifically needed a broader solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial