Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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 ed...
built-in references
Need Help
Report Server
  • d_gosbell's avatar
    d_gosbell
    5 years ago
    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 

d_gosbell's avatar
d_gosbell
Super User
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • d_gosbell's avatar
      d_gosbell
      Super User
      5 years ago
      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