Groups | Blog | Home
all groups > sql server reporting services > august 2005 >

sql server reporting services : displaying of hyperlinks


Harolds
8/19/2005 8:35:04 AM
How do I get the report to display a hyperlink such as this would display and
do:
<a href=""http://www.site.com/page""
target=""_blank"">http://www.site.com/page</a>
--
BillD
8/19/2005 8:39:17 AM
Right click the textbox, go to advance properties, click the navigation tab
and put the URL in the "Jump tto URL" box. ?

[quoted text, click to view]
Harolds
8/19/2005 10:28:02 AM
Thanks for the replies, but to throw a monkey wrench in, the url string is
one of the fields being returned by the dataset.
--
Harolds


[quoted text, click to view]
Bruce L-C [MVP]
8/19/2005 10:45:43 AM
You use the jump to url. Put a textbox on the page, make it blue and
underline. Right click, properties, advanced properties, navigation, jump to
URL. Put in the URL.

If you want to have it open in another window (and you have sp1 or sp2
installed) then put in an expression:
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"

Note the single and double quotes used.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Harolds
8/19/2005 11:51:48 AM
Your right, after I thought about if for a minute it dawned on me.
--
Harolds


[quoted text, click to view]
Bruce L-C [MVP]
8/19/2005 1:36:04 PM
That doesn't matter. If you look at my expression example that created the
hyperlink to pull up a particular report, you can do a similar thing but
instead use the field value. When you build the expression you come to the
expression builder where you can reference the field you want.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button