SSRS 2008 word export doesn't print to landscape

Question

I have a number of SSRS 2008 reports that need to be exported to word in landscape mode. The reports look great when exported but when you attempt to print (or even preview) the page Word appears to be trying to print the reports in portrait mode thus cutting off all content to that is more then 8.5" from the leftmost side of the page.

I have ensured that the following settings have been made.

1) Report -> Report Properties -> Landscape is set 2) the paper size is 11" wide X 8.5" high. 3) the body properties are smaller than the overall paper size.

Answer 1

Set your paper size to the normal 8.5" wide and 11" high. The landscape setting should automatically do the translation of height and width.

Answer 2

I did some research and it turns out this is in fact a bug with SSRS 2008. Microsoft has a fix available.

First, you will need to install SQL Server 2008 sp1.

Next, install the SQL Server 2008 Sp1 Cumulative Update Package 3

I installed both and the Word document exported with the correct print settings.