How to print a SQLServer Reporting Services (SSRS) Report from Access

[Paletti]

Hello,


I'm working with a inhouse application based on data in SQLServer and a

Access 2003 ADP as frontend. I want to make a smooth move to .Net
technology. So I would like to use SQL Server Reporting Services for
new reports or migrate existing reports little by little to SSRS.


But how to print a SSRS report from Access without using Acrobat etc.?
I just want to press a button and the printer should print - like
printing an Access report.


In some positings I've read, that it is possible using SOAP!?


Has anyone out there an idea how to get it done?


Thanks
Tobias

 

[Brendan Reynolds]

SQLSRS doesn't have any 'native' rendering format of its own. It can render
in several common formats, including Adobe Acrobat and Excel. The default
format is HTML, which is great for on-screen display, but not so great for
printing.

You could use a web-browser control to display the report in an Access form,
or just generate the report URL in code and use FollowHyperlink to open the
report in the browser. SQLSRS provides a toolbar with an Export button, so
the users can choose for themselves which format they prefer for printed
output.

Rendering reports using the SOAP interface is non-trivial. See the SQLSRS
documentation at the following URL ...
http://www.microsoft.com/sql/technologies/reporting/default.mspx