Saturday, February 25, 2012

Adding hyperlinks to rows in a table report

Is it possible to add hyperlinks to a table report.
I have been asked to add a link for each result in a table report to a
specific webpage.
I build the link to the webpage using queried data. (i.e.
="www.mywebsite.com/mypage/transientkey=" & fields.transientkey.value &
"&CompanyNum=" & fields.companynum.value & "&")
Any suggestions are greatly appreciated.
Thank you for your help.
--
SamyraUse the jump to URL action (right click on the control, properties,
navigation tab).
This shows how to make it open up in a new window. Also in this case I am
opening a report but you would just put in yours. I suggest using the
expression builder so you get the appropriate fields properly.
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
Also, you might try to first hard code the values and then modify the
expression to use the field values.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Samyra" <Samyra@.discussions.microsoft.com> wrote in message
news:639E0563-DEAA-4F3F-8053-72F8B7113D64@.microsoft.com...
> Is it possible to add hyperlinks to a table report.
> I have been asked to add a link for each result in a table report to a
> specific webpage.
> I build the link to the webpage using queried data. (i.e.
> ="www.mywebsite.com/mypage/transientkey=" & fields.transientkey.value &
> "&CompanyNum=" & fields.companynum.value & "&")
> Any suggestions are greatly appreciated.
> Thank you for your help.
> --
> Samyra

No comments:

Post a Comment