• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2112
  • Last Modified:

How to add hyperlink navigation to Reporting Services field.

In SQL Server 2005 Reporting Services I have a text field that needs to have a URL navigation function.
The field value is:
=Fields!bug_id.Value

How do I place this URL navigation behind it:
http://xyz.com/show_bug.cgi?id=[Fields!bug_id.Value]

I basically need the field value appended to the end of the hyperlink.
0
brooksmato
Asked:
brooksmato
  • 2
1 Solution
 
LindaClaesCommented:
Have a look at the action property of your textbox. Here you can say that the action is to jump to a specific URL. For the URL you can insert the following expression: = "http://xyz.com/show_bug.cgi?id=[" & Fields!bug_id.Value & "]"

Please let me know whether this is helpfull.
0
 
brooksmatoAuthor Commented:
Linda,
Thank You! Thank You! Thank You! It works perfectly. I'm trying to get a handle on reporting services and I couldn't even find this simple answer by googling it. Coming from an extensive Crystal background It's so frustrating to run into small issues like this that take me so long to find answers to. Would you be able to recommend some other resource/book that would be a good reference for Reporting Services?

Thanks
Brooks
0
 
LindaClaesCommented:
Hi Brooks,

To be honest I'm also pretty new in reporting services. I also used to work with Crystal reports and I'm still trying to get adjusted to the new environment. By best advice: Microsoft help, Google and Experts Exchange.
So far I used only these resource to train myself on reporting services and so far I always managed to get my reports exactly as I want them :-)

Good luck.
Kind regards,

Linda
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now