Hello,
Anyone try calling a SQL Server Reporting Service report from with 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 Servics.
Don
Anyone try calling a SQL Server Reporting Service report from with 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 Servics.
Don