SQL Server 2000 Reporting Services:  Embedding URL links into a Report

Posted on 2005-04-14
Last Modified: 2012-08-13
Hi.  I am developing a Reporting Services report, and would like to make one of the Detail Textbox fields link to another webpage.  One of the QueryString parameters should be populated by a field value from the Report.  So, for example....

(DTL)   ID          Description                     Cost                     Entry Date

This Detail line has 4 items.  I want the Description text to be a clickable link navigating to Detail.aspx?id=Fields!ID.Value.

Is this possible?  Any help would be greatly appreciated.

Question by:jasonwisdom
    1 Comment
    LVL 14

    Accepted Solution


    When you say " to another webpage" do you mean another report?

    If your after further detail by clicking the detail line, you could either use the Jump To Report method to pass the parameter to show further details, or you could use a Drilldown option so that the details are displayed under the detail line when the user clicks the drilldown control.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    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…
    This video discusses moving either the default database or any database to a new volume.

    729 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

    20 Experts available now in Live!

    Get 1:1 Help Now