[Last Call] Learn how to a build a cloud-first strategyRegister Now


how do you create a ASP link to an SQL Server Reporting Services (SSRS) report

Posted on 2011-10-27
Medium Priority
Last Modified: 2012-05-12
I have an old ASP web page with a report button. The old report is being replaced by a new SQL Server Reporting Services (SSRS) report which resides somewhere on same server. Could some one show or tell me what I need to do such that when I click on the old ASP button I will be directed to the new SQL Server Reporting Services (SSRS) report. Show me the code for button link or example and what I have to do please. thanks
Question by:tcmmaxt
1 Comment
LVL 37

Accepted Solution

ValentinoV earned 2000 total points
ID: 37043136
All that you need to do to open up an SSRS report through a click is construct a valid URL and point your page to that.

Here's a simple example of what that looks like: http://servername/reportserver?/SampleReports/Employee Sales Summary&rs:Command=Render&rs:format=HTML4.0

More info on URL access can be found here: http://msdn.microsoft.com/en-us/library/ms153586(v=SQL.105).aspx

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month18 days, 14 hours left to enroll

834 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