SSRSViewer and Authentication

I used my domain credentials for it. I simply put that back in there as a placeholder of what I used.

Is the report server on your machine (localhost) or somewhere else? Please post screenshot from SSRSViewer properties in Radzen.

It is on another server. If I uncheck the Use Proxy it does work. Not sure what I'm missing. Proxy does work on another project I'm working on that is still a POC and I run locally just not on my remote production server.

Please change the report server url to http://10.30.4.10/ReportServer to check if this will change anything. What are the settings in your other project where everything works? Is the report name similar to this one?

I changed the setting but it had no effect. The other project runs completely locally on my laptop right now as it is a proof of concept still. It works with and without proxy use. It seems to be when I use a remote SQL server for SSRS as I tried it with another SQL server as a test. The database itself is remote to this machine and has no issues talking to the server from a data perspective only reporting. Thanks for all the help.

I've updated Radzen to the latest version as I saw there were some SSRS fixes implemented. Unfortunately, I still have issues when attempting to use the "Use Proxy" feature. Now it asks for credentials constantly and never displays the report. When Use proxy is off it works fine.

Perhaps it has something to do with not having any references? I noticed in the example screenshot there was 1 reference but mine has none.

Hi @joshwilliam,

You can try setting the PreAuthenticate property of the handler to true.

partial void OnHttpClientHandlerCreate(ref HttpClientHandler handler)
{
     handler.PreAuthenticate = true;
     handler.Credentials = new System.Net.NetworkCredential('user', 'password', 'domain');
}

Unfortunately we have been unable to determine a predictable way to authenticate from .NET code - for some users it works, for some it does not. Sometimes it depends on the account itself.

Other possible workarounds are:

  1. Allow access to those reports to the account under which your IIS application pool works. In this case set UseDefaultCredentials property of the handler to true and remove the other code.
  2. Avoid setting useProxy to true altogether - it is required only if you want to pass ‘hidden’ report parameters.
  3. Allow anonymous access to those reports so login is not required.

I am having this exact issue. Was there a final resolution to this problem, I see the post is from October 2018. Please let me know if there is a way to solve this since this should be a pretty simple standard practice; create a report in report services, and be able to call it from a Radzen screen without any problems and view it via the browser from anywhere.

My last reply is the final resolution to the problem. No other solution is known to us. If this doesn't meet your needs you can use the report by providing the URL to your users as a hyperlink.

Thank You, I will let you know what exactly worked.

What is your recommended report utility that best works with Radzen?

SSRS is the only reporting solution that Radzen supports.

Can someone assist please.
I've created a Controller: ReportController.cs
added this inside:

using System;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Http.Extensions;
using Microsoft.AspNetCore.Mvc;

namespace LMSPortalCore.Data.Controllers
{
public partial class ReportController
{
partial void OnReportRequest(ref HttpRequestMessage requestMessage)
{
// Customize report parameters
}

}
}

It gives me this error:

No defining declaration found for implementing declaration of partial method 'ReportController.OnReportRequest(ref HttpRequestMessage)

Can someone please assist?

The ReportController should be in the LMSPortalCore.Controllers namespace.

Please see attached image, my project is a Blazor server side .net core 3.1
Still getting the same issue

Your application does not have a ReportController file generated by Radzen. This is why you can't create a partial class for it.

How do I do that? Can you advise pls.

The ReportController.cs is generated automatically on every application run from Radzen.

Hi,

Could you please share the way to create the Report Controller.

Thanks,
Praveen

Check my reply here: RadzenSSRSViewer - Pass credentials - #2 by korchev