Open Visual Studio reports from MS Access

Is there any way to open and view reports created with Visual Studio report writer using Microsoft Access?  Optionally, is there a way to open the report viewer from Access to view the reports?  The reports have xsc and xss extensions.  The webpage for the report viewer is  ReportViewer.aspx.
TIMASAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aranaCommented:
by visual studio report writer are you refering to SQLServer Reporting Services?
0
TIMASAuthor Commented:
No. Its called Microsoft Report Viewer and its part of Visual Studio.   The reports are capturing data from SQL Server.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
ReportViewer is a control that's hosted in .NET. You couldn't use that in Access. About the only way you could do this would be to either (a) create a small executable that does nothing more than show the report, configure it to use a commandline, and then show your reports in that executable or (b) use SSRS, as arana suggests, and automate that from Access. The reports you create in .NET are standard RDLC files, which can be opened and run in SSRS.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

TIMASAuthor Commented:
So how would I go about automating SSRS from Access
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Here's an EE question that shows how to do it from Dynamics. The concept would be the same, of course:

https://www.experts-exchange.com/questions/26683909/Creating-a-button-to-call-a-report-in-Sql-Reporting-services-from-a-form-in-dynamics.html
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Both comments addressed the author's question. The only way to show RDLC reports in Access is to create a small executable that shows those reports and then automate it, if needed.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.