Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Launch Reporting Services Report from Microsoft Access?

Posted on 2009-04-10
3
Medium Priority
?
402 Views
Last Modified: 2012-06-27
Have SQL Reporting Services (2008) up and running. Reports work great.

Have a Microsoft Access project (.adp, version 2007) that I would like to be able to integrate some of these reports from. Its no problem to create a .NET form with a report viewer control to view the report.

I "could" write a generic viewer that takes a report name and parameters as parameters and launch a report from Access' VBA environment that way. However, I'd PREFER to have something that maybe already exists? Am I missing something, either from Microsoft, or even a third party?
0
Comment
Question by:dday515
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 2000 total points
ID: 24126212
The following links may contain the info you are looking for on report launchers:

http://msdn.microsoft.com/en-us/library/ms365173(SQL.90).aspx

Download whitepaper from MSDN Webcast on Report Designer for Reporting Services
http://whitepapers.zdnet.co.uk/0,1000000651,260137899p,00.htm

http://mosshowto.blogspot.com/2009/03/reporting-services-sharepoint-multiple.html

Hope this helps.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 24126291
See this link as a good general reference for SQL Server Reporting Services.
                         http://www.databasejournal.com/features/msaccess/article.php/10895_3373661_1/MS-Access-for-the-Business-Environment-Upsize-MS-Access-Reports-to-MS-Reporting-Services.htm
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question