Margin Default Settings 1

ablackwe · Dec 2, 2005

I am trying to set the margins on my reports to 1cm rather than the 2.5cm that seems to be standard. Does anyone know how I can set this as my default for all future reports so I don't have to change each one individually?

Thanks
Adam

Sheco · Dec 2, 2005

I'm using Reporting Services for SQL Sever 2000... on my machine there is a file that is used when you pick Add New Report from the designer:
[tt]C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ProjectItems\ReportProject\Report.rdl[/tt]

Inside the file looks like this:

Code:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="[URL unfurl="true"]http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"[/URL] xmlns:rd="[URL unfurl="true"]http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">[/URL]
	<Width>6.5in</Width>
	<Body>
		<Height>2in</Height>
	</Body>
	<rd:InitialLanguage>true</rd:InitialLanguage>
	<rd:InitialDimensions>
		<rd:UnitType>Inch</rd:UnitType>
		<rd:LeftMargin>1in</rd:LeftMargin>
		<rd:RightMargin>1in</rd:RightMargin>
		<rd:TopMargin>1in</rd:TopMargin>
		<rd:BottomMargin>1in</rd:BottomMargin>
		<rd:PageWidth>8.5in</rd:PageWidth>
		<rd:PageHeight>11in</rd:PageHeight>
		<rd:ColumnSpacing>0.5in</rd:ColumnSpacing>
	</rd:InitialDimensions>
	<rd:InitialDimensions>
		<rd:UnitType>Cm</rd:UnitType>
		<rd:Width>16cm</rd:Width>
		<rd:Height>5cm</rd:Height>
[highlight]		<rd:LeftMargin>2.5cm</rd:LeftMargin>
		<rd:RightMargin>2.5cm</rd:RightMargin>
		<rd:TopMargin>2.5cm</rd:TopMargin>
		<rd:BottomMargin>2.5cm</rd:BottomMargin>[/highlight]
		<rd:GridSpacing>0.25cm</rd:GridSpacing>
		<rd:PageWidth>21cm</rd:PageWidth>
		<rd:PageHeight>29.7cm</rd:PageHeight>
		<rd:ColumnSpacing>1cm</rd:ColumnSpacing>
	</rd:InitialDimensions>
</Report>

ablackwe · Dec 4, 2005

Thanks for this. Works a treat

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Margin Default Settings 1

ablackwe

Programmer

Sheco

Programmer

ablackwe

Programmer

Similar threads

Part and Inventory Search

Sponsor