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"
.
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