RDLC Report Generation using Dataset

Vamshi Krishna

asp.net tutorialsRDLC file for ASP.Net 2010RDLC Report GenerationRDLC Report Generation using Dataset

12 Comments

Join the conversation! Your thoughts help the community grow.

yogesh bhanushali10y ago
how can use where statement here? pelese mail me on [email protected]
Nitin Sharma11y ago
how can we do this when we are using simple report not report wizard?
Raghavender Reddy11y ago
helpful
Mohit Dutta11y ago
to extract the values from the table of your above program
Mohit Dutta11y ago
how we can use external SQL query through ASP.NET
Manish Kumar Choudhary11y ago
Good one.. Thanks..
Vamshi Krishna12y ago
Thank you every body to read my artical.. and sorry am not availabe all these days give to replay....
Dhanaraj Salaimani13y ago
OMG! Thanks a lot. Really nice explanation..
Chirag Khatsuriya14y ago
Hi it's well explained... When we export to excel the data from report viewer it's give error for maximum row exceed? can we split in multiple sheets using report viewer?
Viishnuu Devenddra14y ago
really well explained... thanks... :)
Sai Prakash14y ago
good article krishna
Anil Kumar15y ago
Nice explanation !!!

RDLC: (Report Definition Language Client-side)

Note: First Install Report Viewer in your system.

Step 1: Create database.

Prepare Database tables.

Table 1:

Table 2:

Table 3:

Step 2: Create a Web Application.

Open Visual studio 2010.

Go to file menu select New ->Project.

New Project Window Display in that select ASP.NET Empty Web Application.

Give Application name--RDLC and Click OK.

Step 3: Prepare Dataset

Right click on Application select Add, and again select New Item.

Select dataset and give dataset name (Student Order) and click Add button.

Student Order dataset is prepared in Solution Explorer. Right click on Dataset and select Open.

Dataset Designer window is display. In that window right click select add and select Table Adapter.

Table Adapter Configuration Wizard is display. In that click new connection.

Add Connection Window is Display.

Data Source: Microsoft SQL Server (SqlClient).
Server name: Give Local System name/Server System name.
Log on to the server: Click Use SQL Server Authentication Radio button.
User Name: Give SQL Server username.
Password: Give SQL Server Password.
Connect to Data base: Click Select or enter a Database name Radio button. Select/enter your database name in combo box.
Test connection: click test connection button if test connection is successful click ok button.

Click Next in Table Adapter wizard window.

Next check Yes, Save the Connection as check Box. And Connection String Name as StudentConnectionString. And Click Next button.

Select Use SQL Statements Radio button. And Click Next button.

Next Click Query builder. Add Table Window display. In that select tables one by one. Finally click close button.

After, In Query builder Window select Particular fields from tables and generate query.

Click Next Button.

Again Click Next Button.

Finally Click Finish button.

Finally Create Data table with the name as DataTable1.Change Data Table name as StudentOrderTable.

Finally Save Student Order dataset.

Connection String is created with the name as StudentConnectionString in web.config file.

Next Build Entire Solution. I think no errors are found.

Step 4: Design RDLC Report.

First Install ReportViewer in your System.

Create One Folder with name as Reports. Right Click select Add and select new item.

Select Report Wizard,Give Report Name(StudentOrder) Click Add.

In Solution Explorer Report is generated with the name as StudentOrder in Reports folder.

Report Wizard window Display.

Name: Give Dataset name (StudentOrder).
Data Source : Select Data Source (StudentOrder)
Available Datasets : select (StudentOrderDataTable)
Click Next.

Next Arrange Fields.

Drag and Drop required fields from Available fields to Values.

If you want Arrange groups based on any field just drag field from Available fields to Row Groups. Click Next.

Choose Layouts. Click Next.

Choose Styles. And Click Finish.

Save and Build Solution.

Step 5: Create Web Page.

Create web page With the Name as Student report. And Place Script Manager and Report viewer.

Go to Design view, Select Smart tag.
Click Choose Report Dropdown, Select RDLC report (StudentReport).
Click Choose Data Source and select <New data Source>.
Select Object and Give DataSource Name. And Click OK.

Deselect Show Only data components.

Click drop down list select table Adapter.

Finally Click Next.

Click Finish.

Click OK.

Finally Save the Solution and Click Build. In Solution Explorer Select Web Page (StudentOrder.aspx), Right Click Select Set as Star page and Run application.