Wednesday, June 3, 2020

Dynamic CRM SSRS Report best configuration


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?

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.

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.

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




Thanks.
Vipin Jaiswal 
vipinjaiswal12@gmail.com

No comments: