SSRS Viewer

RadzenSSRSViewer displays a report created in SQL Server Reporting Services (SSRS).

There is no live demo of RadzenSSRSViewer because hosting a public SSRS server is not a trivial task.

To display a report you should specify:

The name of the report via the ReportName property.
The URL of your report server via the ReportServer property.

Here is a minimal example:


<RadzenSSRSViewer ReportName="Untitled" ReportServer="http://myserver/ReportServer/" />

Parameterslink

Often SSRS reports have parameters. You can specify those via the Parameters collection:


<RadzenSSRSViewer ReportName="Untitled" ReportServer="http://myserver/ReportServer/">
  <Parameters>
    <RadzenSSRSViewerParameter ParameterName="Param1" Value="1" />
    <RadzenSSRSViewerParameter ParameterName="Param2" Value="2" />
  </Parameters>
</RadzenSSRSViewer>

Proxylink

Often your report server won't be exposed to the public Internet or you would want to either hide report parameters or provide security credentials. In this case you can use the built-in proxy support in RadzenSSRSViewer. To enable it set the UseProxy property to trueand add the ReportController class below to your Blazor application.

Page
ReportController


<RadzenSSRSViewer UseProxy="true" ReportName="Untitled" ReportServer="http://myserver/ReportServer/">
  <Parameters>
    <RadzenSSRSViewerParameter ParameterName="Param1" Value="1" />
    <RadzenSSRSViewerParameter ParameterName="Param2" Value="2" />
  </Parameters>
</RadzenSSRSViewer>

Provide credentialslink

To provide user credentials when making the proxy requests you can implement the OnHttpClientHandlerCreate partial method of ReportController.

Add a new file e.g. ReportController.Credentials.cs

Implement the OnHttpClientHandlerCreate partial method:


using System.Net;
using System.Text;
using Microsoft.AspNetCore.Http.Extensions;
using Microsoft.AspNetCore.Mvc;
public namespace YourAppNamespace.Controllers
{
   public partial class ReportController
   {
       void OnHttpClientHandlerCreate(ref httpClientHandler);
       {
         httpClientHandler.Credentials = new NetworkCredential("username", "password", "domain");
       }
   }
}

Alternatively you can set the Credentials property of httpClientHandler directly in the CreateHttpClient method of the ReportController class:


private HttpClient CreateHttpClient()
{
    var httpClientHandler = new HttpClientHandler();

    httpClientHandler.AllowAutoRedirect = true;
    httpClientHandler.UseDefaultCredentials = true;

    // Set the credentials
    httpClientHandler.Credentials = new NetworkCredential("username", "password", "domain");

    if (httpClientHandler.SupportsAutomaticDecompression)
    {
        httpClientHandler.AutomaticDecompression = DecompressionMethods.GZip | DecompressionMethods.Deflate;
    }

    OnHttpClientHandlerCreate(ref httpClientHandler);

    return new HttpClient(httpClientHandler);
}

In some setups authenticating the request like this could fail with exceptions such as:

HttpRequestException: Authentication failed because the connection could not be reused.. If this happens check this forum thread
System.ComponentModel.Win32Exception (0x80090302): The function requested is not supported. If this happens check this forum thread

Supercharge your Blazor development with Radzen

Whether you prefer a standalone environment or integration directly within Visual Studio, Radzen provides a powerful toolkit to increase development speed, reduce repetitive coding, and focus on building exceptional applications.

Pro

Radzen Blazor Studio

Radzen Blazor Studio is a software development environment that empowers developers to design, build and deploy Blazor applications without the traditional hurdles.

Learn More

New

Radzen Blazor for Visual Studio

Radzen Blazor for Visual Studio extension streamlines Blazor development within the Visual Studio environment. The Blazor extension you need to boost productivity!

Download Learn More