SSRS 2008 export to MS Word A4 issue

Question

I have a simple report maid in bids 2008 and deployed to a ssrs2008 server. it has this report properties:

page unit : Centimeters page size : Orientasion: Landscape paper sise: A4 width : 29,7cm Height: 21cm all margins ar 2,5cm

Showing and printing this report works fine making it perfekt on a A4 paper. exporting to difrent formats works also grate exept the format i made the report for. The word files ither end up whit an letter paper size or a A3 size. Do enyone have a solution for this problem?

Answer 1

I am getting this the print preview looks ok after exporting to word but when it is printed it is scaled down to some random facter.

There also seems to be an inconsistency in the dimension of the report as you make you page size A4, get you columns set up to be under 21cm run the report and the print preview is terrible with half of it cut off. If you export it to Word it appears fine but then printing it goes terrible again.

Are there any special printer settings you need to set when you export via the web service?

I have also noticed that when designing in Report Builder 2.0 that the Font and column sizes don't seem to match when comparing against a word document. I have to recreate a word based report in SSRS and though this would be better than word automation. I think I was wrong.