SSRS Report Rendering error in M-Files

Hello

Whenever we try to upload a new report to a clients SSRS server we get this weird error when trying to view it on M-Files vault.

The Error: "the attempt to connect to the server failed. check your connection information and that the report server is a compatible version"

The SSRS Version: 16.0.8361.39598

what we have tried:

-we have tried with three different versions of report builder, all version 15.X versions

-we have tried uploading without the table data set or even a data source each separately and together and all from scratch.

 

No matter what we do only new reports are getting this issue, all the other reports we have that were uploaded as long as a month or 2 ago are not getting the issue and can be viewed fine from within M-Files. The links on the report metadata card work, this issue is only within M-Files report rendering.

If anyone could help figure out what is causing this and how it can be resolved that would be greatly appreciated.

Parents Reply
  • We have picked up on the cause of the issue. There is a difference between the URL structure of working reports and the report breaking. If you use the previous URL structure then M-Files will read it and render the report fine. However, if you put the old URL in a browser it will auto convert to the new URL structure. 

     

    For Example we had a report Test in folder TestFolder the old URL would be:
    ServerName/ReportServer?/TestFolder/Test 

    The browser would display the URL as the below: 
    ServerName/ReportServer/Pages/ReportViewer.aspx?/TestFolder/Test.

     

    This is the URL we used on the report object in M-Files, which would give the mentioned error if trying to render the report in the app, clicking on the URL in the metadata would render it in the browser fine, causing our confusion.

    Weirdly, M-Files prefers the previous URL structure. Now we know.

Children
No Data