How do you launch URL by opening an SSRS report

Question

I have the following scenario in my company:

• We have two BI tools
• One is a highly interactive reporting platform that reports from and generates the company data warehouse
• The other is SSRS which we use for our static form type reports. We also use it for real time reporting as this sources directly from the transactional databases

It is a hassle to have users jumping between two reporting platforms to find specific reports they are looking for.

What I would like to do is use SSRS as the home for all reports by creating dummy reports in SSRS whose only purpose is to redirect the user the report in other reporting platform

I imagine this should be possible using custom code functionality in SSRS.

What code (VB.net / C#) can I use to invoke a URL when a user clicks on the report.

Answer 1

Add a textbox to your report with whatever text you want the user to see (e.g. My Other Report).

Right-click the textbox and choose properties, then click the Action tab

Select "Go to URL" and then set the URL as required.