October 14, 2014

SSRS report header and footer get cut off when exported to word format

Problem: I had an experience of header and footer cut off while printing the exported SSRS report to word format.

According to Riccardo Muti from Microsoft  "The margins in the word document do match those in the report at 2 cm or 0.79 in. However, Word and SSRS treat page headers and footers differently. Word actually positions them inside the page margins, whereas SSRS positions them inside the area that the margins surround. As a result, in Word, the page margins do not control the distance between the top edge of the page and that of the page header (or similarly for the page footer). Instead, Word has separate "Header from Top" and "Footer from Bottom" properties to control those distances. Since RDL does not have equivalent properties, the Word renderer sets these properties to zero."

Reference:
http://connect.microsoft.com/SQLServer/feedbackdetail/view/614558/word-export-sets-margin-top-margin-bottom-to-0mm

I have the solution so far is before printing the report from Word, we have to increase the size of header and footer. This will help to print the report from word format without header and footer cut off.