WPF – RDLC Report in WPF
In this article i will show you how to generate RDLC report in WPF application.
Step 1
Download northwind database from the following link.
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en
Step 2
Attach a northwind database into MS-SQL server
Step 3
Create a WPF application and give solution name as SolRDLCReportWPF.
Step 4
First we need to create Report Viewer in WPF Application.Unfortunately there is no ReportViewer control for WPF application but ReportViewer only exists in WinForms and ASP.NET.So we can used WindowsFormsHost to integrate the report viewer control with the WPF form.
Drag and drop WindowFormHostControl on window from Toolbox.it is look like this
Click on image for better view
- <Grid>
- <WindowsFormsHost x:Name=“WinFormHost”>
- </WindowsFormsHost>
- </Grid>
Step 5
Add Microsoft.ReportViewer.WinForms assembly reference to the project from solution explorer,it is look like this
Click on image for better view
Note : Select only Version 10.0.0.0
Step 6
Add a ReportViewer assembly reference in window tag,it is look like this
- xmlns:RV=“clr-namespace:Microsoft.Reporting.WinForms;assembly=Microsoft.ReportViewer.WinForms”
Finally it’s look like this
- <Window x:Class=“SolRDLCReportWPF.MainWindow”
- xmlns=“http://schemas.microsoft.com/winfx/2006/xaml/presentation”
- xmlns:x=“http://schemas.microsoft.com/winfx/2006/xaml”
- xmlns:RV=“clr-namespace:Microsoft.Reporting.WinForms;assembly=Microsoft.ReportViewer.WinForms”
- Title=“MainWindow” Height=“350” Width=“525”>
Step 7
Wrap the ReportViewer control in a WindowsFormsHostelement,it is look like this
- <Grid>
- <WindowsFormsHost x:Name=“WinFormHost”>
- <RV:ReportViewer x:Name=“ReportEmployee”></RV:ReportViewer>
- </WindowsFormsHost>
- </Grid>
Finally Presentation part done now we Create DataSet Schema and Report Design.
Step 8
First We create a DataSet Schema.it can be define Dataset schema without connecting to any datasource.
Add a DataSet Schema,right click on Add new Item,select DataSet from installed Visual Studio templates and name it NorthwindDataSet and click on add button,it is look like this
Click on image for better view
Step 9
Click on toolbox icon,it is look like this
Click on image for better view
Select DataTable from Toolbox and drag and drop to the dataset design editor,it is look like this
Finally Add column to schema,it is look like this
Click on image for better view
DataSet Schema is ready now we create Report Design in WPF
Step 10
Add a RDLC Report,right click on solution,select Add new Item,select Report from installed Visual Studio templates and name it NorthwindReport and click on add button,it is look like this
Click on image for better view
Step 11
Add DataSet Schema to the report,it is look like this
Click on image for better view
In the next dialog, give the dataset a name called EmployeeDataSet. Change the data source to NorthwindDataSet and select available dataset Employee and click OK,it is look like this
Click on image for better view
Step 12
Add Header and Footer on report,it is look like this
Click on image for better view
In Header Section Add TextBox from toolbox,it is look like this
Click on image for better view
In Footer Section Add Page number from build in field,it is look like this
Click on image for better view
Step 13
Add Table from toolbox for display employee data,it is look like this
Click on image for better view
Drag and Drop all Employee Fields from NorthwindDataSet into table,it is look like this
Click on image for better view
Finally Report is ready now we move to programming part.
Step 14
Bind Employee data to Dataset Schema,it is look like this
- #region Bind Employee Data to DataSet Schema
- /// <summary>
- /// Get Employee data from Northwind database and bind in NorthwindDataSet
- /// </summary>
- /// <returns>DataTable</returns>
- private DataTable GetEmployeeData()
- {
- try
- {
- // Open Sql Connection
- SqlConnection SqlCon = new SqlConnection(@“Data Source=SHREE\SHREE;Initial Catalog=Northwind;Integrated Security=True”);
- SqlCon.Open();
- // Create a Command
- SqlCommand SqlComm = new SqlCommand();
- SqlComm.Connection = SqlCon;
- SqlComm.CommandType = CommandType.Text;
- SqlComm.CommandText = “SELECT FirstName,LastName,BirthDate,Address,City,PostalCode,Country FROM Employees”;
- // Create instance of Northwind DataSetXSD
- NorthwindDataSet.EmployeeDataTable EmployeeDt = new NorthwindDataSet.EmployeeDataTable();
- // Set a Data Commands
- SqlDataAdapter SqlDa = new SqlDataAdapter(SqlComm);
- SqlDa.Fill(EmployeeDt); // Fill Data in NorthwindDataSet Object.
- return EmployeeDt;
- }
- catch (Exception ex)
- {
- throw new Exception(ex.Message);
- }
- }
- #endregion
Step 15
Display Report in Report Viewer,it is look like this
- #region Display Report
- /// <summary>
- /// Display Report in Report Viewer
- /// </summary>
- private void DisplayReport()
- {
- try
- {
- // Set a DataSource to the report
- // First Parameter – Report DataSet Name
- // Second Parameter – DataSource Object i.e DataTable
- ReportEmployee.LocalReport.DataSources.Add(new ReportDataSource(“EmployeeDataSet”, GetEmployeeData()));
- // Set A Report Embedded Resource
- ReportEmployee.LocalReport.ReportEmbeddedResource = “SolRDLCReportWPF.NorthwindReport.rdlc”;
- // OR Set Report Path
- // Alternative: ReportEmployee.LocalReport.ReportPath = @”../../NorthwindReport.rdlc”;
- // Display Report
- ReportEmployee.RefreshReport();
- }
- catch (Exception ex)
- {
- throw new Exception(ex.Message);
- }
- }
- #endregion
Call DisplayReport function on window constructor,it is look like this
- public MainWindow()
- {
- InitializeComponent();
- try
- {
- DisplayReport();
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- }
Run the project.
Output
Click on image for better view
Full Code
1. XAML Code
- <Window x:Class=“SolRDLCReportWPF.MainWindow”
- xmlns=“http://schemas.microsoft.com/winfx/2006/xaml/presentation”
- xmlns:x=“http://schemas.microsoft.com/winfx/2006/xaml”
- xmlns:RV=“clr-namespace:Microsoft.Reporting.WinForms;assembly=Microsoft.ReportViewer.WinForms”
- Title=“MainWindow” Height=“350” Width=“525”>
- <Grid>
- <WindowsFormsHost x:Name=“WinFormHost”>
- <RV:ReportViewer x:Name=“ReportEmployee”></RV:ReportViewer>
- </WindowsFormsHost>
- </Grid>
- </Window>
2. Code Behind
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Windows;
- using System.Windows.Controls;
- using System.Windows.Data;
- using System.Windows.Documents;
- using System.Windows.Input;
- using System.Windows.Media;
- using System.Windows.Media.Imaging;
- using System.Windows.Navigation;
- using System.Windows.Shapes;
- using System.Data;
- using System.Data.SqlClient;
- using Microsoft.Reporting.WinForms;
- namespace SolRDLCReportWPF
- {
- /// <summary>
- /// Interaction logic for MainWindow.xaml
- /// </summary>
- public partial class MainWindow : Window
- {
- public MainWindow()
- {
- InitializeComponent();
- try
- {
- DisplayReport();
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- }
- #region Bind Employee Data to DataSet Schema
- /// <summary>
- /// Get Employee data from Northwind database and bind in NorthwindDataSet
- /// </summary>
- /// <returns>DataTable</returns>
- private DataTable GetEmployeeData()
- {
- try
- {
- // Open Sql Connection
- SqlConnection SqlCon = new SqlConnection(@“Data Source=SHREE\SHREE;Initial Catalog=Northwind;Integrated Security=True”);
- SqlCon.Open();
- // Create a Command
- SqlCommand SqlComm = new SqlCommand();
- SqlComm.Connection = SqlCon;
- SqlComm.CommandType = CommandType.Text;
- SqlComm.CommandText = “SELECT FirstName,LastName,BirthDate,Address,City,PostalCode,Country FROM Employees”;
- // Create instance of Northwind DataSetXSD
- NorthwindDataSet.EmployeeDataTable EmployeeDt = new NorthwindDataSet.EmployeeDataTable();
- // Set a Data Commands
- SqlDataAdapter SqlDa = new SqlDataAdapter(SqlComm);
- SqlDa.Fill(EmployeeDt); // Fill Data in NorthwindDataSet Object.
- return EmployeeDt;
- }
- catch (Exception ex)
- {
- throw new Exception(ex.Message);
- }
- }
- #endregion
- #region Display Report
- /// <summary>
- /// Display Report in Report Viewer
- /// </summary>
- private void DisplayReport()
- {
- try
- {
- // Set a DataSource to the report
- // First Parameter – Report DataSet Name
- // Second Parameter – DataSource Object i.e DataTable
- ReportEmployee.LocalReport.DataSources.Add(new ReportDataSource(“EmployeeDataSet”, GetEmployeeData()));
- // Set A Report Embedded Resource
- ReportEmployee.LocalReport.ReportEmbeddedResource = “SolRDLCReportWPF.NorthwindReport.rdlc”;
- // OR Set Report Path
- // Alternative: ReportEmployee.LocalReport.ReportPath = @”../../NorthwindReport.rdlc”;
- // Display Report
- ReportEmployee.RefreshReport();
- }
- catch (Exception ex)
- {
- throw new Exception(ex.Message);
- }
- }
- #endregion
- }
- }