Hey! Can we shift the logo to the top most?
Can we put a page number in the bottom and make it center align
Can we shift an overall footer to the very bottom of the page?
Can we shift an overall footer to the very bottom of the page?
If you involve yourself with SSRS report development, then you often hear such comments from your customer.
When trying to export report in PDF or in MS-Word there will be more surprises and when it comes to printing your might be like - Awwwwww Jesus.
When trying to export report in PDF or in MS-Word there will be more surprises and when it comes to printing your might be like - Awwwwww Jesus.
After making a lot of adjustments and doing trial and error one can have a perfect report. Some reports like Quotation or Invoice, which are mailed to customers requires an out most precision.
In this blog post, I would be listing out few important properties which must not be missed when it comes to SSRS report.
Note: I am referring A4 paper size and all settings are considered based on this.
Note: I am referring A4 paper size and all settings are considered based on this.
Page Setup
Right-Click outside the report body area to get to Report Properties.
- These setting works perfect for PDF / Word / Printing
- Notice bottom margin is set to 0cm, which helps in keeping footer to very bottom
Report Body Size
Report body can have three sections - Header, main body and footer. All three sections must have WIDTH of 20cm which is 1cm less than Page width size.
The HEIGHT should be 28.7cm in total of height of Header + Footer + Main Body.
If report is not having header and footer section than we can utilize full height of 28.7cm for main report body.
A typical example:
Page Header and Footer
Once Page layout is configured, report body boundary should stay within that otherwise it may result in weird behavior in PDF or MS-Word.
Header and Footer space should be kept minimum as it is going to repeat itself in all the pages.
Information that may goes on header or Footer
- Company Logo
- Customer Number
- Quotation Number
- Invoice Number
- Page Number
- Company Contact details – Address / Phone
- Company VAT Details
- Page Number 5th page of Total 15 pages
Page Number Formula
=CStr(Globals!PageNumber) + "/" + CStr(Globals!OverallTotalPages)
Alignment and Padding
Vertical Align for all data type – Middle
Text Align
Numbers, Decimals, Money or Currency – Right Align
Text – Left Align
Padding : It specify the amount of space/padding between report item boundary
There can be more settings which could result in better report.
Share your findings in the comments sections if you have any.
Here are more SSRS related blog to follow
Report not appearing for certain users
Dynamic CRM SSRS Report common syntax help
https://vjcity.blogspot.com/2019/05/dynamic-crm-ssrs-report-syntax-help.html
If you are looking for an expert in Dynamic CRM or in SSRS Report, please feel free to reach me.
Share your findings in the comments sections if you have any.
Here are more SSRS related blog to follow
How to create SSRS Report in Dynamic 365 CRM
Report not appearing for certain users
https://vjcity.blogspot.com/2019/07/reports-missing-for-certain-users-in.html
Dynamic CRM SSRS Report common syntax help
https://vjcity.blogspot.com/2019/05/dynamic-crm-ssrs-report-syntax-help.html
If you are looking for an expert in Dynamic CRM or in SSRS Report, please feel free to reach me.
Thanks.
Vipin Jaiswal
vipinjaiswal12@gmail.com
No comments:
Post a Comment