RDLC: (Report Definition Language
Client-side) Note: First Install Report Viewer in your system. Step 1: Create database.
Prepare Database tables. Table 1:
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.
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
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
Finally Save Student Order dataset.
Connection String is created with the name as StudentConnectionString in
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
Select Report Wizard,Give Report Name(StudentOrder) Click Add.
In Solution Explorer Report is generated with the name as StudentOrder in
Report Wizard window Display.
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
Deselect Show Only data components.
Click drop down list select table Adapter.
Finally Click Next.
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.