• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2114
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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