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

Posted on 2011-10-27
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

    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:

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
    Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    745 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

    18 Experts available now in Live!

    Get 1:1 Help Now