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
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.
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.
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
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
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 /
Click Ok to close the Expression window
Next, Please navigate to the Font tab and change the color of the Text. It helps the end-user to identify as Hyperlink
Click Ok to finish enabling Go to URL action on the SSRS table report.
Let us see the SSRS Go To URL Action report preview by clicking preview tab
Once we click on SQL, our default browser will open the www.tutorialgateway.org/sql/ as shown below
Comments are closed.