How to open a URL in an SSRS report in a new window? While the URLs keep changing in every record

I want to be able to open URLs in a new window in my SSRS report, and the URLs keep changing in every record. The problem is these links are not the only things present in the record, and there is other data present. I keep seeing examples where they are considering only a link to be present in the record with no other data.

Also the data in the record includes HTML tags and I checked the option that says "HTML - Interpret HTML tags as styles" on the placeholder properties window.

Example of data in the record:

Hello! Welcome to google, the most used search engine. 
Click on www.google.com to go the website

So when I click on the www.google.com URL, it should open in a new window.

June 28th, 2015 11:18pm

You would use the expression: javascript:void(window.open('http://www.google.com','_blank'))

Further explanation available at:

http://www.sqlchick.com/entries/2010/8/22/opening-a-link-in-ssrs-within-a-new-window.html

  • Proposed as answer by jholden90 1 hour 6 minutes ago
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 2:02am

Right click on textbox and choose properties. Select Navigation tab and give expression for jump to url property as below

="javascript:void(window.open('"+ Fields!URLFieldName.Value + "','_blank'))"

Then it will add hyperlink action and will navigate to url as returned by dataset row

Also see

http://www.bidn.com/blogs/BrianKnight/ssis/972/ssrs-action-to-open-a-url-in-a-new-wind

June 29th, 2015 2:33am