Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
s_anr
Yak Posting Veteran
81 Posts |
 Posted - 2010-09-22 : 22:45:12
|
| I have a view which gives following output / query(select name, ('http://' + name + '.com') as URL from my table)Name URLtest1 http://test1.comtest2 http://test2.comtest3 http://test3.comtest4 http://test4.comI created a SSRS report (report on report manager). It dosn't show a hyperlink.i'd like to show just one column and link it to the corresponding URLNamewithURLtest1 (pointing to http://test1.com)test2 (pointing to http://test2.com)test3 (pointing to http://test3.com)test4 (pointing to http://test4.com)It simply doesn't show the hyperlink.i even tried (select name, ('<a href http://' + name + '.com>' + '</a>') as URL from my table)Any suggestions please... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-23 : 12:35:05
|
| nope. you just bring url as it as without hyperlink tag and add the field to jump to url property of cell in expression as=Fields!yoururlfieldname.value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
s_anr
Yak Posting Veteran
81 Posts |
Posted - 2010-09-23 : 23:59:43
|
| Thanks vikash. It was really simple and i spent hours on it.. :) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-25 : 00:26:30
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
s_anr
Yak Posting Veteran
81 Posts |
Posted - 2010-09-25 : 00:34:59
|
| Hey vikash,The hyperlink opens in the same window. Any idea how to open in a target new window. Appreciate your help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-25 : 00:55:10
|
| give like="javascript:void(window.open('" & Fields!yoururlfieldname.value & "','_blank'))"------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
s_anr
Yak Posting Veteran
81 Posts |
Posted - 2010-09-25 : 16:25:30
|
| Awesome...... Perfect!!!!Thanks Vikash. You made my day! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-26 : 02:07:55
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
HTML in SSRS