Skip to main content

SSRS Best Pracitice - 3

Page Setup:

This Property have a very high importance when we need to print the report or export the report to the hard page break formats like PDF, word etc.

For every Report as a best practice we should do proper page set so that the report items are properly displayed while printing or exporting the PDF or word etc.

Let’s see an example how to do it:
1. Enable the Ruler in the design




2. Open the Report Properties

3. By default the page size is width-8.5in Height: 11in, now you have to set the page size as following:

Take the width of the design using ruler and add the margin into that and set this value as the width of the page.

E.g. width in the design is showing as 15in and margin is set at 1in left and right  so total width of the page is 17in (15in+1in+1in).
Set this amount in the page width and when you run the report it will display the objects properly on the PDF or Print etc.

View of the report before setting the page setup in the report properties:



View after setting the page setup properly:



So before setting the proper page width in the Report, the chart is breaked into two pages, but after setting the page setup properly - this chart is fit properly in export to PDF on a single page only!

Note: when we set the page width and Height it will reset the page zoom in the output(PDF etc.) so that the object is displayed properly and infromation can fit in the page.

Happy Learning!
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