In a ssrs 2008 r2 dashboard application, I have a question about how ssrs automatically determines the length of paper that is required to print some of the reports.
In one ssrs 2008 r2 report in particular, 50% of the columns are not visible when the report is exported to pdf or word. The problem is the page length is longer than legal size paper. There is no way that the exported report needs that size of paper.
Thus can you tell me how to modify the ssrs report so that it needs only letter size paper?