MS Reporting Services report viewer in MS Access Database

Question

Hi there,

I have a report deployed on a MS Reporting Services server, working fine. I can access it from a ASPX page with no problems, set the report parameters, etc, using the Report Viewer component from Microsoft. Works great.

The question is: is there any way to view this report WITHIN a form in an Access database? Is there a version of the report viewer that can be used with MS Access?

I have searched online, but I can't find a solution.

I know an Access report can be imported into SSRS, but I need to be able to view an SSRS report from within Access.

Thanks!!

Answer 1

Not in a form directly.

The best you'll get is some kind of "Web" Control that can be used to give an IE session to the report. Or have a link label with URL Access to create a separate IE Window.

Answer 2

how would you set up a "web" control so that could be done?