April 26, 2009 at 9:05 pm
Dear,
I have two fields in SQL a table like:
Example:
Field1 contain: "Please click the link GIS"
Field2 contains: "www.GIS.com"
Do we have any way to make a link on the word "GIS" to open the URL "www.GIS.com" in PDF report which exports from Reporting Service 2005 or 2008.
(if we don't need to show full URL address.)
Please help,
Thank you.
April 27, 2009 at 8:53 am
I have two fields in SQL a table like:
Example:
Field1 contain: "Please click the link GIS"
Field2 contains: "www.GIS.com"
Do we have any way to make a link on the word "GIS" to open the URL "www.GIS.com" in PDF report which exports from Reporting Service 2005 or 2008. (if we don't need to show full URL address.)
I'm a little confused. Field1 and field2 are found in a report rendered as a PDF, and you just want to make field1 a clickable link to the http://www.gis.com page, right?
Once you have a textxbox or table cell to show the field1 text you want to make into a link, open the Properties dialog for it, go to the Navigation tab, choose the Jump to URL option and then enter an Expression to use the value from Field2. Here's one that should be adequate:
="ja vascript:void(window.open('http:"+Fields!field2.Value+"','_blank'))"
(I can't get this site to display the word javasrcipt so take the space out of the first word. And that second parameter, the ,'_blank' part, makes the link open a new browser window.)
[font="Arial"]Are you lost daddy? I asked tenderly.
Shut up he explained.[/font]
- Ring Lardner
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply