Solved

Launch Reporting Services Report from Microsoft Access?

Posted on 2009-04-10
3
393 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 500 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

739 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