Solved

Launch Reporting Services Report from Microsoft Access?

Posted on 2009-04-10
3
389 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 500 total points
Comment Utility
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
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

744 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now