SSRSViewer displays folders, but not report

I used the Radzen tool to generate a Blazor app proof-of-concept to display pre-existing reports located on SSRS 2016.

However, I cannot get a report to show. When clicking the run button, a browser window opens, 3 error dialogs are generated, and after clicking 'OK' on all of them, the root folder is shown displaying all the available folders.

I can then drill into the folders, until reaching the report. When clicking on the report, the following json is generated in the page.

{"data":"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\"\"http://www.w3.org/TR/html4/strict.dtd\">\r\n<HTML><HEAD><TITLE>Not Found</TITLE>\r\n<META HTTP-EQUIV=\"Content-Type\" Content=\"text/html; charset=us-ascii\"></HEAD>\r\n<BODY><h2>Not Found</h2>\r\n<hr><p>HTTP Error 404. The requested resource is not found.</p>\r\n</BODY></HTML>\r\n","status":404,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"cache":true,"url":"api/v1.0/reportserverinfo/model.GetVirtualDirectory","headers":{"Accept":"application/json, text/plain, */*"}},"statusText":"Not Found"}

The browser developer tools display the following on the console and network tabs.

In the Radzen tool, the following properties are set:

  • ReportServer: http://devXYZreports/reports
  • ReportName: report/ABC/DEF/SummaryGHI
  • UseProxy: true

When viewing SSRS directly:

  • Home URL: http://devXYZreports/reports/browse/
  • Report URL: http://devXYZreports/reports/report/ABC/DEF/SummaryGHI

Any advice would be appreciated. Thanks!

Hi @mdrake-rwb,

Try setting the ReportServer property to one of the following values:

  1. http://devXYZreports/reports
  2. http://devXYZreports

Thanks for the reply @korchev

My apologies. I had a copy/paste error, but have now edited my original post. The ReportServer property was http://devXYZreports/reports. I have tried with and without a trailing slash.

Regarding your second suggestion, using http://devXYZreports for the ReportServer property causes the page to display "HTTP Error 404. The requested resource is not found.".

Any other thoughts or suggestions?

Here is how the viewer creates the URL to the report: radzen-blazor/RadzenSSRSViewer.razor.cs at master · radzenhq/radzen-blazor · GitHub

You can try constructing such a URL in your browser and see if it displays as expected.

@korchev,
Using line 60 in your GitHub link as a URL template, I came up with the following: http://devXYZreports/reports/Pages/ReportViewer.aspx?%2freport/ABC/DEF/SummaryGHI&rs:Command=Render&rs:Embed=true

When I paste the above in a browser, it takes me to the home page of our SSRS site. This is similar to what I see when using the report viewer (only, without the 3 error dialogs described earlier).

What do you make of this? For some reason, it is not able to display the report (SummaryGHI), but instead navigates 3 folders up in the reports hierarchy.

According to the documentation this should have been the path to the report.

https://myserver/ReportServer/Pages/ReportViewer.aspx?%2fProduct_and_Sales_Report_AdventureWorks&SellStartDate=7/1/2005

I am not really sure what could be different in your installation.

Could the difference be that the example you shared has the report located at the root/home location? Do you have any examples where the report lies in a subfolder on the SSRS server?

Unfortunately we don't have such an example. You can probably test with a sample report at root level to see if this would make a difference.

I put a copy of the report in the root location, and renamed it "TestSummaryGHI". After changing the ReportName property to TestSummaryGHI, I saw the same behavior I noted in the original post. I could see the "TestSummaryGHI" report in the root listing, so I clicked on it. Again, same behavior as first noted where it displays json.

{"data":"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\"\"http://www.w3.org/TR/html4/strict.dtd\">\r\n<HTML><HEAD><TITLE>Not Found</TITLE>\r\n<META HTTP-EQUIV=\"Content-Type\" Content=\"text/html; charset=us-ascii\"></HEAD>\r\n<BODY><h2>Not Found</h2>\r\n<hr><p>HTTP Error 404. The requested resource is not found.</p>\r\n</BODY></HTML>\r\n","status":404,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"cache":true,"url":"api/v1.0/reportserverinfo/model.GetVirtualDirectory","headers":{"Accept":"application/json, text/plain, */*"}},"statusText":"Not Found"}

I can open the solution in Visual Studio. Is there not something I can look for while in debug mode? Or something further to look for in the browser's developer tools? I would think there must be some other troubleshooting I can zero in on. I'd be grateful for any further suggestions.

The problem seems to be with your report server configuration. You should see a report by browsing its URL (without the Radzen report viewer).

As mentioned in my original post, the direct SSRS Report URL http://devXYZreports/reports/report/ABC/DEF/SummaryGHI successfully displays the report. However, the Radzen ReportViewer control doesn't create this particular URL. If there was a configuration that could be changed on our end, do you have an idea of what that could it be?

I am afraid I am not a SSRS expert and I don't know if this URL is enabled somewhere. You can perhaps check again the documentation - hopefully there would be some hints. To be honest I think the URL should contain reportserver in the name as suggested here

An example of the complete URL string might be as follows:
https://+:80/reportserver, provides access to the report server.
https://+:80/reports, provides access to the web portal.

I would try http://devXYZreports/reportserver as the ReportServer property you are now using /reports which according to the documentation is the web portal.

1 Like

@korchev, that was the solution. Thanks! The ReportServer property should not be taken from the web portal URL, but rather from the web service URL. In addition, the ReportName property needed to be ABC/DEF/SummaryGHI