Groups | Blog | Home
all groups > sql server reporting services > april 2007 >

sql server reporting services : Export Multiple Reports and Export to 1 PDF?


Rob
4/5/2007 4:44:11 AM
Is it possible to render multiple reports and then export them to 1 PDF file?
Lisa Slater Nicholls
4/6/2007 9:00:22 AM
Is this using the ReportViewer control (client-side) or server side?

IAC -- here is what I know on this issue,which is not particular Reporting
Services specific:

1) It is easy to move multiple source files into a PDF file if the source
files are in postscript.

2) Most printing engines can write postscript files simply by specifying a
postscript print driver

3) postscript drivers come with the OS.

4) It is easier to manage this type of activity client-side than
server-side, for many reasons.

Here is some advice for you:

You can find a demo app with code for printing reports without UI, using the
ReportViewer control, on this page. http://www.gotreportviewer.com/

I expect it can be adapted to go to a ps printer driver and given target
file information (or the ps driver setup can be set to go to a file target
explicitly -- but that doesn't seem thread safe to me).

Then you can use standard postscript to PDF capabilites to convert the
string of files you just wrote out. I use Ghostscript to do this, you don't
need Adobe and you don't need any UI for this step either.

You can learn about Ghostscript here http://www.ghostscript.com/awki There
is a overview of command-line switches here
http://ghostscript.com/doc/8.54/Use.htm#Options -- for your purposes, pay
particular attention to the ability to create a commandfile listing all the
switches as well as all the files you wish to process in this run (more
flexible than listing the files directly on the command line if your list
may be long). YOu may prefer to use the API directly (DLLs rather than
command-line). It's quite extensive.

[quoted text, click to view]


[quoted text, click to view]
Rob
4/9/2007 4:10:02 AM
My apologies for not specifying. This is the client side control for use in
a Windows application. This is good stuff. I'll take a look at it and let
you know how it goes. Thanks!

[quoted text, click to view]
AddThis Social Bookmark Button