Access calling SQL Server Reporting Services

[Don]

Hello,

Anyone try calling a SQL Server Reporting Service report from within
Access? I have an Access application that uses SQL Server as the backend.
I want to have the feature from an invoice screen to create a PDF of the
Invoice report and then email it to the customer.

I was thinking about using reporting service to do this. If I can't
do it directly I might have the application update a table with the customer
email address and InvoiceID to be sent out. Then schedule the SQL Service
Reporting Service to have a job that checks the table every ten minutes to
find what invoices need to be mailed out. What do you think of this
approach? I've really not had much experience with Reporting Services.

Thanks

Don

 

[Brendan Reynolds]

SRS is implemented as a web service, and in theory it should be possible to
call the web service from Access 2003 or Access 2002 using the Office Web
Services Toolkit. I've done this successfully with other web services.
Unfortunately, when I attempted to test this, the attempt to set a reference
to the SRS web service failed with a message that "the Web Service
References Tool could not generate the requested code". As I've been unable
to find any further information, I'm unable to test this any further. If you
want to follow up on it yourself, you'll need the web services toolkit for
your version of Office if you don't already have it. URLs are below ...

Office 2003 Web Services Toolkit
http://www.microsoft.com/downloads/...8a-e1cf-48a3-9b35-169d819ecf18&DisplayLang=en

Office XP Web Services Toolkit
http://www.microsoft.com/downloads/...0F-002A-4F5B-AF74-978F2CD6C798&displaylang=en