topic Re: Link to another report using Built-in Collections (global variable) in Report Server

Link to another report using Built-in Collections (global variable)

Anonymous — Thu, 04 Feb 2021 15:40:30 GMT

Hello Community,

On SSRS the global variable for the server URL is working fine, but in PBIRS not. I found this MS documentation and like to know if and where these built-in references can be edited.

My example:

Link to the report: http://dev-kpl-pbi-vm/Reports/report/test_report

[&ReportServerUrl] is giving me: http://dev-kpl-pbi-vm:80/ReportServer

In SSRS I can use the global built-in variable followed by the folder structure to link to a report, but in PBIRS it is not opening the linked report. It shows me the following instead:

Best,

Mogry

Re: Link to another report using Built-in Collections (global variable)

d_gosbell — Fri, 05 Feb 2021 05:12:03 GMT

What is the expression you were using in SSRS. As far as I am aware the url syntax for the ReportServer endpoint has not changed since SSRS 2005.

Typically you would use something like the following:

[&ReportServerUrl]?<path to report>

So you your case something like the following should work:

[&ReportServerUrl]?/test_report

I think it is the extra /report/ in your url that is used in the portal, but is not required by the ReportServer that is give you the issue.

Re: Link to another report using Built-in Collections (global variable)

Anonymous — Fri, 05 Feb 2021 12:46:39 GMT

Thanks for the reply. For me it looks like the built-in collection is not giving back the correct Report Server URL.

I need: dev-kpl-pbi-vm/Reports/report/

[&ReportServerUrl] is giving me: http://dev-kpl-pbi-vm:80/ReportServer

The expression is Globals!ReportServerUrl. This is the same which is used on the SSRS.

Neither http://dev-kpl-pbi-vm:80/ReportServer/report/test_report nor http://dev-kpl-pbi-vm:80/ReportServer/test_report is opening the report.

Re: Link to another report using Built-in Collections (global variable)

d_gosbell — Fri, 05 Feb 2021 13:35:51 GMT

Anonymous wrote:

Neither http://dev-kpl-pbi-vm:80/ReportServer/report/test_report nor http://dev-kpl-pbi-vm:80/ReportServer/test_report is opening the report.

That is probably because neither of those match the format I suggested. As in my previous post, you need to have the report server url, then a question mark (?) then the path to the report.

So I would expect one of the following to work (I'm not sure if you need the leading / when the report is in the home folder)

http://dev-kpl-pbi-vm:80/ReportServer?/test_report

http://dev-kpl-pbi-vm:80/ReportServer?test_report

Re: Link to another report using Built-in Collections (global variable)

Anonymous — Fri, 05 Feb 2021 14:11:31 GMT

I totally missed the question mark. The report is opening with "http://dev-kpl-pbi-vm:80/ReportServer?/test_report" and the leading slash is necessary.