0

We have a single SSRS report with a lot of parameters. End-users would like to have a single-click hyperlink that runs the SSRS report with the parameters pre-selected - that appears to be possible (source).

Our problem now is that our users are accustomed to going to the SSRS Report portal and searching for the report they want to run (e.g. https://ssrs-server.domain.local/reports/browse).

How do I add a hyperlink to the list of "reports" that will launch the parameterized URL that launches our report with the preselected parameters? e.g. https://ssrs-server.domain.local/reports/report/path/to/ssrs-report?Parameter=1.

This report is used by multiple departments and can be used for different use cases depending on the parameters selected. My goal is to have a list of hyperlinks that runs the same report, each link specifying the parameters via the URL.

8
  • Could you not set the default parameter values of the report itself, so when they open it, it automatically runs?
    – J.D.
    Jul 8, 2023 at 12:24
  • Hi @J.D. - Multiple departments use this same report. The idea is to have multiple hyperlinks to the report with different default values. Jul 9, 2023 at 20:36
  • You could deploy multiple copies of the report each instance with separate parameter values configured as the defaults.
    – J.D.
    Jul 9, 2023 at 21:20
  • @J.D. For version-control and management reasons I was hoping to avoid doing that. Any other suggestions? Anyone else? Jul 10, 2023 at 22:03
  • You wouldn't need separate copies of the report rdl file. You would just change the path of deployment for each version (which you can automate a multitude of ways). You may need a separate folder on the SSRS server for each version to deploy to. But you can then create a shortcut (with something called a Linked Report) to each of them in the same main folder, if you wanted them all shown in the same place. From a version control / management perspective, you'd still only have 1 report to manage. This would basically emulate what you're trying to do. 🙂
    – J.D.
    Jul 10, 2023 at 22:10

1 Answer 1

0

So after all of that, a spark clicked in my brain, and I remembered I was overcomplicating it. You can simply use Linked Reports in SSRS to completely create the "links" with the different parameters you're looking for.

Linked Reports are similar to creating a customizable shortcut to the original report in SSRS. The parameters of them can be configured differently than the source report. The nice thing though is they inherit the same report design and data sources as the original source report. So any changes to the report only needs to be deployed once, and all Linked Reports will have the updates automatically.

Some info from the previous linked docs:

A linked report is a report server item that provides an access point to an existing report. Conceptually, it is similar to a program shortcut that you use to run a program or open a file.

A linked report is derived from an existing report and retains the original's report definition. A linked report always inherits report layout and data source properties of the original report. All other properties and settings can be different from those of the original report, including security, parameters, location, subscriptions, and schedules.

Sorry, I was having a total mind fart until I remember this is essentially how to emulate hyperlinks in the SSRS repository.

2
  • 1
    This worked perfectly. Thank you, J.D. Jul 25, 2023 at 14:29
  • @user1913559 Np! Sorry for the brain fart lol.
    – J.D.
    Jul 25, 2023 at 16:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.