.NET Reporting Service in web application

Step 1: Create ASP.NET Web Site
Please do the following to create an ASP.NET Web Site:
Select File menu -> New -> Web Site.
Choose File System from Location.
Choose Visual C# from Language.
In the Templates pane, choose ASP.NET Web Site.
Please update the following property of page default.aspx:
Feel free to change any other properties of the default.aspx as per your requirement.
Using namespace for
using System.Data.SqlClient;
using Microsoft.Reporting.WebForms;

Step 2: Add Report Viewer to the Page
Report Viewer is the other half of the Client-Side reporting components provided with the Visual Studio 2005. For all those who are new to report writing, I would say, report viewer gives life to your reports.
It not only previews you the output, further, it also facilitates you to generate the information in the various popular formats (pdf, excel etc.). You can also take a hard copy print of the report while you are viewing the output.
Step 3: Add Report to the Project
Alright, so far we created the project; added Report Viewer and DataSet. Now, it is the time to deal with star of the show! Let's create that neat report.
Following steps is required to have Report (rptProductList.rdlc):
• Select Add -> New Item -> Report from Solution Explorer. Change name from Report1.rdlc to rptProductList.rdlc and click on Add button to complete the action.
Typically, after add action is finished your screen should be similar to the Image 6. When a report is added to the project, it is ready to use the DataSet for designing.