View Access Reports on the web Through Sharepoint?

Question

I am using MS Access 2010 as a front-end to a 2008 SQL Server back-end.  Reports produced are complex and printed in PDF form.  I want to make them available for viewing on the web. This will prove very useful to customers that make changes to the SQL data and want to see a new report.  The reports are already designed and saved in the MS Access database under various report names.

Questions:

1) How can I execute a saved MS 2010 Access Report from an asp page where the customer makes data changes?

2) Once the new MS Access Report is created, how do I retrieve it to show to the customer?

I assume Sharepoint Server will work for this purpose, but after numerous web searches, I am confused about what I am seeing as to whether it can definitely do it or not.

FYI ... I also design web pages via Visual Studio 2010 if that makes a difference for integration purposes.

Steve

Answer 1

The standard answer to this, is that you'll need to publish the database to sharepoint using Access Services.  Once your database is inside of SharePoint as a site, you still have to make sure that SSRS is functioning, because that's what's used in the browser to display the reports. 

---

Laura Rogers
SharePoint911: SharePoint Consulting
Blog: http://www.sharepoint911.com/blogs/laura
Twitter: WonderLaura
Books:Beginning SharePoint 2010: Building Business Solutions with SharePoint
Using InfoPath 2010 with Microsoft SharePoint 2010 Step by Step