Thread: Printing from Report Manager

Sorry for the delay. I believe I have found an answer for you. The best way I can think of to do this is to modify the URL. You'll have to give the modified URL to your users obviously, but the good news is that the display is at 75% but the report prints at 100%.

Here is what you need to do.
1. Run the report and right click on the screen.
2. Select properties in the dropdown.
3. Select and copy the entire URL address.
4. Paste this into some text editor like notepad for example.
5. Look for the section that says "&rc%3aToolbar=True&"
6. After that (adding no spaces or quotes) add "&rc%3aZoom=75&"
7. Look for the bit at the end that says "3aArea=Report".
8. Change that to "3aArea=Parameters" (so your users can change parameters).

You can always give your users a more friendly looking url, but this will do what you want I think.

Let me know if that works for you.

Hmm... that URL does not look long enough. Did you run the report from the Report manager before getting the URL? Also - make sure you get the URL from the report section of the page. So run it in IE then right click on the body of the report and copy the URL in the Address section of the properties.

P.S. make sure to hold down the left mouse button... there is more to the URL than what you see. Here's a sample:

Code:

http://data1/ReportServer?%2fAccounting%2fSales_by_Order_Source&StartDate=8%2f1%2f2009+12%3a00%3a00+AM&EndDate=8%2f23%2f2009+12%3a00%3a00+AM&rs%3aCommand=Render&rs%3aFormat=HTML4.0&rc%3aReplacementRoot=http%3a%2f%2fdata1%2fReports2%2fPages%2fReport.aspx%3fServerUrl%3d&rc%3aToolbar=True&rc%3aJavaScript=True&rc%3aLinkTarget=_top&rc%3aArea=Report

Do you mean that you want to force the matrix to wrap so that it always fits within the borders of the report? Can you design the matrix so that the data goes down the page instead of across in order to conserve space?

Alternatively, you can decrease the margins or force the page to landscape mode if you have not tried that already (this is set in the report properties).

If none of that works, I suggest designing multiple matrices; forcing the amount of data in the dataset so that the data only goes across the page as far as you want it to. For example, each matrix could contain two months worth of data and each would be arranged so that they go down the page one after the other.

Hopefully some of this makes sense for you. I'd try the page settings first and see if you can't get that to work before attempting the other option.

Let me know how it goes!

You might also look at the matrix object's properties. There's a property that says "fit on one page if possible". You could check that checkbox and see if it fits onto one page that way. Remember that you will have to deploy the report with that change in order to see any difference on the server.

Another option is to make the font smaller and to modify the width of the columns so that they are only as wide as they need to be. You could also make the columns even smaller than that and allow the text to wrap if that wouldn't look too bad. Eliminate as much whitespace as you can between columns.

If that still doesn't work you can try the other option you asked about at the end of your post... creating multiple matrices. What I meant by that is that you could set up multiple report datasets. Each dataset would query the table for a specifc timeframe in an effort to limit the results. Then each dataset in your report is tied to a separate matrix. You would design the report with multiple matrices beneath each other vertically and a page break after each one. But this is a measure of last resort.