
More importantly, once your template is setup with your preconfigured settings, you save yourself a ton of extra work.Īlso, I don’t recommend this, but you can mix and match units (centimeters and inches). This is one of the main reasons why you’d want to use a template from the beginning in order to ensure that everything looks right. Given that there were a number of existing items, I ended up selecting each one and changing their size to inches. If this seems like a lot of work, it is, that’s why I always start with my SSRS templates. After the page was converted the gauge and all other objects stayed in centimeters until I manually converted them to inches. For example, this gauge was within the report prior to the report page units being converted to inches. It might not be obvious at first, but when you convert from centimeters to inches, all existing items within your report will STAY as they were originally created. Once all of the changes are completed, your Page Setup will look similar to the one above. For my purposes, a 1-inch margin is too large! Although I didn’t call it out before, I also changed the default margins from 1-inch to 0.25 inches. Next, since I wanted the report to be on an 11” x 8.5” page, I selected Landscape under Orientation. Notice that all of the options that I was looking for are found on the Page Setup node!įirst, I selected Inches under Page units. This will allow the Report menu item to be displayed (purple arrow).Įxpand the Report menu and click on the Report Properties item. Now that you have your report open, ensure that you are on the Design tab (highlighted above in blue). Start by opening SQL Server Data Tools (SSDT). The SSRS report I was updating was originally created in Canada, so the measurements were in centimeters and the page size was A4.īelow are the steps I took to change the report’s page measurements and layout. The first thing to note about Visual Studio is that it tries to be helpful by setting the page measurements based on your location.
#How to adjust margins in pages 2015 how to#
I thought that I would document them here, so that the next time I have to perform them I will know exactly where to look! This blog post shows you how to change the page measurements and paper size of a SSRS report. Unfortunately, it took me longer than expected to remember these steps. This should be a simple task if you remember exactly where to configure this information, however, I always use preconfigured SSRS templates, so I don’t have to configure my settings each time. One of the items that I was tasked with was converting the report’s page size from centimeters to inches and changing the page layout from A4 to 11” x 8.5” (letter size). After setting all the desired values for all the margins, click the OK button to apply the margins.I recently was sent a SQL Server Reporting Services (SSRS) report that needed to be edited and updated. Step 4 − If you are going to bind the document and want to add an extra amount of space on one edge for the binding, enter that amount in the Gutter text box, and select the side the gutter is on with the Gutter Position drop-down list.


Select the Apply to: option to apply the margin on selected text or complete document.

Step 3 − You will have to display a Page Dialog Box as shown below where you can set top, left, right and bottom margins under the Margins Tab. You can also select any of the predefined margins from the list, but using custom margins option you will have more control on all the settings. This will display a list of options to be selected but you have to click the Custom Margins option available at the bottom. Step 2 − Click the Page Layout tab, and click the Margins button in the Page Setup group. If you want the margins to be applied only to a selected part of a document, select that particular part. Step 1 − Open the document the margins of which need to be set. The following steps will help you understand how to set margins for an open document. In the screenshot given below, I have shown top, left and right margins, if you will type the complete page, word will leave 1-inch bottom margin as well. By default, Word sets all margins left, right, top, and bottom to 1 inch. You can adjust the right, left, top, and bottom margins of your document.

Margins are the space between the edge of the paper and the text. In this chapter, we will discuss how to adjust page margins in Word 2010.
