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...
6 comments
Read more

How to do Error Handling for Transaction using Try Catch Block

Issue : Some time we get requirements where we have to use transaction to do some DML operations to make sure the unit of work should be done completely. But there could be error while doing this. So, how we can cope up with errors to achieving this? Solution: We can use Transaction in the Try Catch block to make sure that the transaction either successful or rollback if there is any error. Below is an example for this: BEGIN TRY --Start the Try Block.. BEGIN TRANSACTION -- Start the transaction.. UPDATE [dbo] . [Table] SET salary = salary * 1.1 WHERE MID = 6 --DML operations to be done in the transaction COMMIT TRAN -- Transaction Success! END TRY --End of the Try Block BEGIN CATCH --Start the Catch Block IF @@TRANCOUNT > 0 --check the error count for the errors ROLLBACK TRAN --RollBack in case of Error --to raise the error message when there is an issue. Declare the variables and se the values for them DECLARE @Er...
Post a Comment
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