The Report Viewer controls can be used to integrate Reporting Services RDL reports into WebForms and WinForms apps.
Install the Report Viewer control NuGet package via the NuGet package manager console.
Install-Package Microsoft.ReportingServices.ReportViewerControl.WebForms.aspx page
<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>
<div style="height:100vh;">
<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="100%" Width="100%">
<ServerReport ReportServerUrl="http://localhost:8080/ReportServer" ReportPath="/CustomersdbReports/ProductList" />
</rsweb:ReportViewer>
</div><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Sample" %>
<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager runat="server"></asp:ScriptManager>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote">
<ServerReport ReportServerUrl="https://AContosoDepartment/ReportServer" ReportPath="/LatestSales" />
</rsweb:ReportViewer>
</form>
</body>
</html>Authentication with Report Server
https://stackoverflow.com/questions/671694/passing-credentials-to-sql-report-server-2008
IReportServerCredentials irsc = new CustomReportCredentials("user01", "password01", "domain01");
rv_ReportsViewer.ServerReport.ReportServerCredentials = irsc;CustomReportCredentials.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Web;
using Microsoft.Reporting.WebForms;
namespace CustomersdbReportViewer.Models
{
public class CustomReportCredentials : IReportServerCredentials
{
private string _UserName;
private string _PassWord;
private string _DomainName;
public CustomReportCredentials(string UserName, string PassWord, string DomainName)
{
_UserName = UserName;
_PassWord = PassWord;
_DomainName = DomainName;
}
public System.Security.Principal.WindowsIdentity ImpersonationUser
{
get { return null; }
}
ICredentials IReportServerCredentials.NetworkCredentials
{
get { return new NetworkCredential(_UserName, _PassWord, _DomainName); }
}
bool IReportServerCredentials.GetFormsCredentials(out Cookie authCookie, out string userName, out string password, out string authority)
{
authCookie = null;
userName = password = authority = null;
return false;
}
}
}
Comments