Create RDLC Report Using DataSet in ASP.Net

Anoop Kumar Sharma

RDLC ReportRDLC Report in ASP.NETRDLC Report using DataSet

17 Comments

Join the conversation! Your thoughts help the community grow.

Venky S4y ago
HI Anoop if we have 2 datasets from a store proc. How do I say instead of this dsemp.Tables[0]. The store proc gives two result sets as the output and both are used in the report
Darshan Balar5y ago
This code is perfectly work on local pc But when i publish so unable to fill data in rdlc report please help
- Anoop Kumar Sharma5y ago
  Darshan Balar Are you getting any error after publishing? If yes, please share so that I can help you.
mahesh wabale7y ago
Hi Anoop, Very Good article, I have uses same stems which u have wrote. only you need to add two line after this code below are the lines this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport();
Fahim Bhuiyan8y ago
Anoop Create RDLC Report Using DataSet in ASP.Net is a effective article you done!
- Anoop Kumar Sharma8y ago
  Thanks Fahim Bhuiyan, for your valuable comment.
- Fahim Bhuiyan8y ago
  Thanks anoop. I want to ask a question you. I used your technique to show a simple report in a website but it shows only a blank report. Fyi I filled up data set instance successfully but I can see that report data source shows the data table. When I finally add reportdatasource instance it shows the datatable but finally shows the blank report. Can you give me the sln pls?
Mrinmoy Roy10y ago
thanks
Anoop Kumar Sharma10y ago
Thanks Manoj Kalla..!!
Manoj Kalla10y ago
Short and Sweet, Great
Murali krishna10y ago
hi how to print directly
Vincent Onyinye11y ago
Nice work, but does it work only on internet explorer browser?
- Anoop Kumar Sharma11y ago
  Thanks Vincent Onyinye..!! It works fine on all modern browser. I have shown the working screenshot of google chrome browser.
madhuri Gamane11y ago
working... but how to print directly ??
- Rashmi Ransingh6y ago
  Internet explorer
Anoop Kumar Sharma11y ago
Thanks Jitendra Kumar
Jitendra Kumar11y ago
Nice one..

In my previous article, we saw how to create a RDLC Report in ASP.Net using Visual Studio Report Designer. If you missed that, visit the following link:

Create RDLC Reports in ASP.Net Web Application / Website

You have seen that in the previous example, we haven't provided even a single line of code. In this article, we will create a RDLC Report using a DataSet and use a few lines of code to fill the DataSet with data and use that DataSet as a ReportDataSource. For demonstration, I have created a database (named Sample) and created a table tbl_Employee in it. The following is the table design for creating tbl_Employee.

Add some records to tbl_Employee. I have attached the script of the database along with the source code for download.

Let's Begin

1. Create a new website.

2. Right-click on Website then select Add New Item then select DataSet.

3. You will see Empty DataSet. Right-click on the DataSet then go to Add then select DataTable.

4. Right-click on DataTable and add the column's name. The column name must match the name of the column added in the the tbl_Employee.

Set the DataType of each column the same as declared in tbl_Employee. Save the DataSet (in other words dsEmployee).

5. Right-click on Website then select Add new item then select Report Wizard then click on Add.

6. Now the Report Wizard opens. Select the DataSource as Dataset (in other words dsEmployee).

7. Drag and drop the required fields from the Available fields into the Values section.

Click on "Next" because we didn't want to display a subtotal in our report.

8. Choose a style for your report then click on "Finish". I have selected Slate as the style for my report.

You will see the report named Report.rdlc is created.

9. Now, add a ScriptManager and ReportViewer Control from the Toolbox on a Webform. I have added them on Default.aspx.

Now go to the Code Behind file of the Default.aspx Webform.

10. Add the System.Data.SqlClient and Microsoft.Reporting.WebForms namespaces (they contain methods and properties for the ReportViewer Web server control). Then add the following code for the Page_Load event of Default.aspx.

using System;
using System.Data.SqlClient;
using Microsoft.Reporting.WebForms;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//set Processing Mode of Report as Local
ReportViewer1.ProcessingMode = ProcessingMode.Local;
//set path of the Local report
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc");
//creating object of DataSet dsEmployee and filling the DataSet using SQLDataAdapter
dsEmployee dsemp = new dsEmployee();
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Sample;Integrated Security=true;");
con.Open();
SqlDataAdapter adapt = new SqlDataAdapter("select * from tbl_Employee", con);
adapt.Fill(dsemp, "DataTable1");
con.Close();
//Providing DataSource for the Report
ReportDataSource rds = new ReportDataSource("dsEmployee", dsemp.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
//Add ReportDataSource
ReportViewer1.LocalReport.DataSources.Add(rds);
}
}
}

Build and run the application.

Click on the Save Button in the report and save the entire report in PDF/Excel/Word format.

I hope you like it. Thanks.