D
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
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