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.
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). Later in “Page configuration”, from where we will have the possibility of manually entering those values that we want to assign to the document margins.I recently was sent a SQL Server Reporting Services (SSRS) report that needed to be edited and updated. To access this section it will only be necessary to click on the “File” tab. In this way, as we will see below, we will be able to create specific margins, instead of dragging the ruler’s separator, as well as perform some complementary functions.
However, if we want to be more precise, in the event that we have to make a special type of document in terms of size, we can choose to use the settings in the Page Settings window. On the other hand, the left arrow is responsible for adjusting the indentation of the entire paragraph, while the right arrow modifies the indentation located on the right side. On the one hand, the blue bar is in charge of adjusting the indentation of the first line of the paragraph in which the cursor is located. In the same way, we can see how the gray area of the ruler is in charge of informing us what is the current margin that we have defined.Īs with the margins, these can also be adjusted by clicking on them and dragging them to the location we need. The first refers to the left and right margins, while the other controls the upper and lower margins. In case they are not shown, we must activate it by clicking on “View” and then on “Show rule”. Once the corresponding document is opened, we can see how the rules are located in the upper left part of it. In Google Docs, margins can be set using the ruler to make rough changes, simply by dragging the mouse, or in a much more detailed way using the page setup window. Next, we are going to see the different ways we have to change the margins and adapt them to our needs. Of course, we must bear in mind that this change can affect the entire page in its entirety or select a paragraph and make it adapt to that content. We can do it from the ruler that we see on the screen, such as from the menu bar. In addition, it is possible to have different indentations within the same document, but instead it is only possible that there is one margin.Īs we are going to see, the margin adjustment process is simple, which we can carry out in a matter of seconds. These are blank spaces that are included between the margin and the first line of the paragraph.
However, it is very important that we do not confuse margins with indents.