SSRS Open URL in New Window

For many that are not aware, SSRS is excellent at displaying SharePoint list data.  Whether in Native or SharePoint-Integrated mode, SSRS connects directly to a SharePoint site and will enumerate all the lists and libraries.

We recently used pie charts to display the major statuses for a business process.  We wanted to set a hyperlink on the chart that would send the user to the list view that shows the data items in the chart.  A requirement was to open this hyperlink in a new window/tab.  Well the Action section allows you to add a URL to a page, but by using a expression you can run JavaScript, very powerful.

Steps:
  1. Rick-click on the chart area and choose 'Series Properties'.
  2. Click on 'Action' section.
  3. Click on 'Go to URL', and click on the Expression button.
  4. Enter this expression in this format (replace url.com with your web address):
="javascript:void(window.open('url.com','_blank'))"

Example:

Note: Feel free to use variables and expressions to build your URL.  It may be helpful to pull in the item ID field for the URL as this typically is necessary to open a single item from an SSRS table view.

Comments

Popular posts from this blog

SharePoint Designer 2013 Approval Workflow with Comments

Change SharePoint server hostname and Web Application Names

The Timer Service Failed to Recycle