Skip to main content

SSRS Reports - Importance of setting of the Page Setup in the Reporting services

Benefits of setting the Page setup properties:

à In Proper format data export in the hard page break render formats(e.g PDF)
à We can properly print the report data on the different size of pages as per our business requirements
à It will also save the pages required to print the information properly, which will help to save the environment also J



How to open Report Properties to set the page setup:


Below window will appear on the screen:


In this window there are many options are given as Page setup, Code, References, Variables.

On the Page setup option,
 Ã  Page Units: here two options are given
1. Inches (it displays the measures in Inches)
2. Centimeters (it displays the measures in Centimeters)

If you want more accurate formatting and placement of the object use Centimeters scale.

à Paper Size: This Property is very important for the reports.

While designing the Report the developer should keep in mind that the how my data will be shown if report is printed.

In the reporting services there are many pre defined options are given which we can use to set the page setup for the Reports.

Following are the available options for Paper size:

Letter (this is default one)
Tabloid
Legal
Statement
Executive
A3
A4
A5
A6
215x330
9x11
B4
5x7
B6
8x10
Postcard
Oversized A4
Custom

Choose the size as per the requirement and then design the report layout to fit the objects in this page size.

And when we run the report and print the report the data will properly fit into the printer page (e.g. if we have set A4 size in the Paper Size in the Report and printing the report in the A4 size paper, the data will be properly printed on this size.)

The important option here is “Custom” which is use full when we have so many fields in tables to be displayed in report and we want to export the data to PDF Format (hard page break option) with the proper formatting.

In this case we use custom page size and provide the Page height and width in the Report.

We can calculate the Page width in the Report design using the Ruler

How to enable Ruler in the Report design:

Ruler is visible:

Now we can estimate the report width from the ruler and can set in the custom width of the Page (e.g. for this report layout we can set the page width to 9 inches in the Page size).

And when we export the data to the PDF it will fit the data into the PDF page with proper formatting. If the width is more then the default size of the PDF pages then it will set the Zoom option accordingly and display the report data.

Example to calculate the page width:


In the above layout the width in the ruler is around 11.5 inches and the left and right margin is 0.5 inches both
So the width of the page we have to set more then or equal to Ruler reading + Left Margin + Right Margin (11.5+0.5+0.5=12.5 inches).
So, in this report the page width is set to 13 inches.

Export to PDF output:


In the output it has set the zoom to 98% automatically to display the proper format

à Margin: Margin is the space which will be left in the report for Left, Right, Top, and Bottom.

We can set this as per our requirement and by default is it 1in for all the sides (when inches are selected in the Page units
Labels:

Comments

Post a Comment

Popular posts from this blog

SSRS Reports - Space/Gap issue between the objects in SSRS Reports

In Reports where some objects are set to be shown/hide based on some expression/filter condition etc. There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report). Following are few ways using which we can handle this kind of issue: 1. Remove the Gap between the objects in the report layout. 2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it. 3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color. below is one approach: The report before any space handling: -----------------------------------------------------------------------------  Report Preview when all the o...
5 comments
Read more

SSRS Reports - When few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report

In Reports where some objects are set to be shown/hide based on some expression/filter condition etc. There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report). Following are few ways using which we can handle this kind of issue: 1. Remove the Gap between the objects in the report layout. 2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it. 3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color. below is one approach: The report before any space handling: -----------------------------------------------------------------------------  Report Preview when all the obj...
Post a Comment
Read more

SSRS Reports - How to Create Static Rows in a Matrix in SSRS?

Today one of my team members asked me about how to create a matrix in which the rows will remain static/constant and the column group will grow as per the data available. SQL Server Reporting Services 1. Create a data set to get the required data for the matrix. 2. Drag a matrix object on the report body. 3. Add the number of required rows to outside the row group  (This is the main trick for creating the static rows in the matrix) 4. Delete the row group detail row from the matrix 5. Add the labels to the row lines headers, add the column group values and data values in the matrix 6. Run the Report and your Matrix is ready with Static Rows! Happy learning!!!
1 comment
Read more