RDLC Report Generation using Dataset

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.