In the SSRS 2019 web UI, can the search results grid be customised to display the full report path?

Andrew Inchley 0 Reputation points
2024-10-22T23:28:57.1266667+00:00

We have a single SQL Server Reporting Services 2019 instance that services several different business units across two continents. We have a set of core reports which are the same RDL but deployed to different folders configured with different shared datasources to enable the report to query a result from country 1 or country 2 depending on the folder it's deployed to. This works fine for 95% of the workforce, however certain departments have oversight over both countries.

To further complicate matters (somewhat), we don't allow access to the base folder where our reports are deployed. We have subfolders where we create linked reports and set folder permissions based on functional area of the user.
When a user searches for e.g. "Sales Report", they can see all of the versions in the different subfolders they have been granted permissions to, however the UI does not provide any visual indication of which subfolder the report belongs to, so it's not easy for them to resolve whether the report is for "country 1" or "country 2"

.User's image The user could mouse over the hyperlink and see the location its linking to, but that's not a great end user experience. We could also rename the reports as we create the linked reports, but before we go down that path I was wondering whether there was any way to modify the search (and favorite) pages on the SSRS web UI to display the path on the results? I can't seem to find anything in the documentation, and surprisingly I couldn't even find any results of anyone asking this question.

Thanks in advance

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,066 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,496 Reputation points
    2024-10-23T02:21:16.1166667+00:00

    Hi @Andrew Inchley,

    Here is a workaround, you may use List when using portal url.

    User's image

    And then when you search the report, you could see the description.

    User's image

    For Suggestions/Other Ideas: Tell us how this impacts your business operations and how what you're asking for will enable/unblock your scenario. You may share your idea here.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.