CODEWITHSUNDEEP
reporting-servicesprinting
Ole Lynge
Ole Lynge

Reputation: 4587

Reporting services: Print all pages

In SQL Server Reporting Services I would like to have an option to print all pages of the report, even though the report is split into multiple report pages in the user interface.

We currently have a report with the following:

and would like the following change:

Upvotes: 0

Views: 1887

Answers (1)

jgallant
jgallant

Reputation: 11273

In order to manually manage printing, you need to write your own print methods. This has been covered extensively online, by frustrated ReportViewer developers.

Basically, the idea is that you create your own print renderer. You would render all report pages into images (either by filestream or memorystream), and pass the images to the printer. A word of advice, is if you decide to use MemoryStream (which is the easier method, as it doesn't require cleanup), keep in mind that if your reports are very large, you may end up with out of memory issues.

Having a custom print method will give you full control on the report printing.

A MSDN article on the topic can be found at http://msdn.microsoft.com/en-us/library/ms252091%28VS.80%29.aspx

Also, if you google "Custom printing reportviewer", you will find many articles relating to this topic.

Upvotes: 2

Related Questions