Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Go To URL Action in SSRS

by suresh

In SSRS, Actions are used to add additional functionality to Reports. It means, we can define the events to take place when users click on the text box or specific area displayed on a report. The SSRS Go To URL Action allows you to navigate from the report to a specified URL.

TIP: SSRS Actions can define on Matrix, Table (Together Tablix), Charts, Data bars, Pie Charts, Gauges and so on

Go To URL Action in SSRS 2014

From the above screenshot, you can observe that there are three types of actions:

  • Go to report: Most commonly called Drill Through Action. It allows the user to navigate from one report to another by clicking an object in the main report.
  • Go to bookmark: It allows the user to navigate to a pre-defined bookmark within the same SSRS report. For instance, If the report is too long, then we can define bookmarks to navigate easily.
  • Go to URL: This type of action allows the user to navigate from the SSRS report to the specified URL. For instance, if we are displaying sales by country and user want to view the Heat Map of each country when he clicked on it then we can use this Go to URL action

Go To URL Action in SSRS Example

In this example, we will show you how to enable Go to URL action in SSRS Reports with an example. The below screenshot shows you the Embedded Dataset we are going to use for this example.

Go To URL Action in SSRS 2014

Let us see the Report preview as well. If you observe the below screenshot, It’s a normal Table Report displaying tutorialgateway.org posts archive.

Go To URL Action in SSRS 2014

Here we are going to apply go to URL action on the Tutorials column. So, Right-click on the Tutorials text box and select the Text Box Properties.. option from the context menu

Go To URL Action in SSRS 2014

Once you select the Text Box Properties.. option, a new window will be opened to configure the properties. For this SSRS Report, Please Navigate to Action tab and choose to Go to URL option as shown below.

If you know the URL, then Hard code it in the text box. Otherwise, Please select the fx button as we did

Go To URL Action in SSRS 2014

Within the Expression window, Please write the following expression

="https://www.tutorialgateway.org/" + LCase(Fields!Tutorials.Value.ToString())

We are just adding the user clicked text to www.tutorialgateway.org/ URL. For instance, if user click on MDX, then MDX is added after the /

Go To URL Action in SSRS 2014

Click Ok to close the Expression window

Go To URL Action in SSRS 2014

Next, Please navigate to the Font tab and change the color of the Text. It helps the end-user to identify as Hyperlink

Go To URL Action in SSRS 2014

Click Ok to finish enabling Go to URL action on the SSRS table report.

Go To URL Action in SSRS 2014

Let us see the SSRS Go To URL Action report preview by clicking preview tab

Go To URL Action in SSRS 2014

Once we click on SQL, our default browser will open the www.tutorialgateway.org/sql/ as shown below

Go To URL Action in SSRS 2014

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021 · All Rights Reserved by Suresh

About Us | Contact Us | Privacy Policy