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