Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Parameter Values as Hyperlinks

Author  Topic  jabin Starting Member 3 Posts Posted - 2007-04-27 : 16:07:20 I have need to deploy same reports to various servers. All the reports have a custom GUI front end. I want to include a hyperlink on each report that will link back to the site specific url for the front end. This expression for navigation/jump to URL works--="http://127.0.0.1/SAM3/ReportParams.aspx?name=PUXReport12a&FromDateTime="&Parameters!FromDateTime.Value But I'd like to have the link not hard coded (to avoid having to change each report everytime I deploy it. I've tried setting a parameter and value to equal http://anh-ssisql/SAM3/... and then for the navigation code I went with =Parameters!URL.Value which isn't recognized as a hyperlink. What am I doing wrong. Appreciate any help. Thanks, Jim