ReportViewer Control in Visual Studio 2008

Introduction

ReportViewer is a freely redistributable control that enables embedding reports in applications developed using the .NET Framework. Reports are designed with drag-and-drop simplicity using Report Designer included in Visual Studio 2008 (Standard editon and above.)

The ReportViewer control offers the following benefits:

• Processes data efficiently. The reporting engine built into ReportViewer can perform operations such as filtering, sorting, grouping and aggregation.
• Supports a variety of ways in which to present data. You can present data as lists, tables, charts and matrices (also known as crosstabs.)
• Adds visual appeal. You can specify fonts, colors, border styles, background images etc to make your report visually appealing.
• Enables interactivity in reports. You can have collapsible sections, document map, bookmarks, interactive sorting etc in your report.
• Supports conditional formatting. You can embed expressions in the report to change display style dynamically based on data values.
• Supports printing and print preview.
• Supports export to Excel, Word and PDF formats. (Word export in Visual Studio 2010 and up.)

The control can process and render reports independently using a built-in engine ('local mode') or it can display reports that are processed and rendered on a Report Server ('remote mode').

There is a WinForms and a WebForms version of the control.

Passing Parameters to Server Report

ReportViewer1.ShowParameterPrompts = false;

ReportViewer1.ShowCredentialPrompts = false;

ReportViewer1.ProcessingMode = ProcessingMode.Remote;

ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://venkateswarlu/ReportServer");

IReportServerCredentials irsc = new CustomReportCredentials("username","password","domain");

ReportViewer1.ServerReport.ReportServerCredentials = irsc;

//ReportViewer1.ServerReport.ReportPath = "/AdventureWorks/CHCompanySales";

ReportViewer1.ServerReport.ReportPath = "/AdventureWorks/CHSalesOrderDetail";

ReportParameter[] rptParams = new ReportParameter[1];

rptParams[0] = new ReportParameter("SalesOrderNumber", "SO50750");

ReportViewer1.ServerReport.SetParameters(rptParams);

ReportViewer1.ServerReport.Refresh();

ReportViewerCredentials Class

using System.Security.Principal;

using System.Net;

///

/// Summary description for ReportViewerCredentials

///

public class CustomReportCredentials : Microsoft.Reporting.WebForms.IReportServerCredentials

{

// local variable for network credential.

private string _UserName;

private string _PassWord;

private string _DomainName;

public CustomReportCredentials(string UserName, string PassWord, string DomainName)

{

_UserName = UserName;

_PassWord = PassWord;

_DomainName = DomainName;

}

public WindowsIdentity ImpersonationUser

{

get

{

return null; // not use ImpersonationUser

}

}

public ICredentials NetworkCredentials

{

get

{

// use NetworkCredentials

return new NetworkCredential(_UserName, _PassWord, _DomainName);

}

}

public bool GetFormsCredentials(out Cookie authCookie, out string user, out string password, out string authority)

{

// not use FormsCredentials unless you have implements a custom autentication.

authCookie = null;

user = password = authority = null;

return false;

}

}