StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>The short answer is that you can't exactly do what you want with the Excel renderer</strong>. Some workarounds that come to mind:</p> <ul> <li>Filling an Excel template with data might be an option, but is more of a job for <em>SSIS</em>, not reporting services.</li> <li>Send the report in PDF for printing, and if needed in Excel as well.</li> <li>Re-layout the report so it plays well with the default printing of Excel. This won't be very pretty, you'd need to either make columns much smaller (and perhaps rotate headers using the WritingMode property) or turn columns into row groups somehow.</li> <li>(hack warning!) create an Excel macro or something alike for your users, that does some printing-quick-fixes.</li> </ul> <p><strong>Some background</strong><br> Unfortunately SSRS gives you only a small bit of control over how the report is rendered in the various rendering extensions. There's <a href="http://msdn.microsoft.com/en-us/library/ee210530.aspx#RenderingExtensions" rel="nofollow">this MSDN page on rendering extensions</a> (additional emphasis mine) with some useful info:</p> <blockquote> <ul> <li><p><strong>Soft page-break renderers</strong>: Soft page-break renderers maintain the report layout and formatting. The resulting file is <strong>optimized for screen-based viewing and delivery</strong>, such as on a Web page. The available soft page-break renderers are: <strong>Microsoft Excel</strong>, Microsoft Word, Web archive (MHTML), and HTML.</p></li> <li><p><strong>Hard page-break renderers</strong>: Hard page-break renderers maintain the report layout and formatting. The resulting file is <strong>optimized for a consistent printing experience</strong>, or to view the report online in a book format. The available hard page-break renderers are supported: TIFF and <strong>PDF</strong>.</p></li> </ul> </blockquote> <p>So, if you want to optimize for printing experience, you should probably use the PDF export. You can then play around with the page size and margins to fit as much info as possible on a page, and let the client program (probably Adobe Reader) worry about printing it nicely.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload