How to generate a report from a SQL Server database using the Report Wizard in ASP.NET.
In this article I will explain how to generate a report from a SQL Server database using the Report Wizard and display it in ASP.NET.
In this article we will generate a report from a SQL Server database using the Report Wizard and display it in ASP.NET using MicrosoftReportViewer control.
Create a new ASP.NET Web Application:
Add a new Report Wizard using right-click on project and Add -> New Item. Click on the Add button. Click Next on the Report Wizard welcome screen.
Choose your Data Connection and click on Next.
Click Next which will save a connection string in the Web.config file.
Select tables and columns to display on the report. Then click on Finish.
Select the Data Source (authors in this case) and click on Next.
Select the Report Type, Tabular or Matrix and click on Next.
Click Next in the "Design the Table" wizard.
Choose the table layout, Stepped or Block and click on Next.
Choose a table style from the left and click on Next and then Finish.
We have generated our report and added it to the project. Our next step is to display this report in a web form. To display the report we will use a Microsoft ReportViewer control.
Drag a Microsoft ReportViewer control to the Default.aspx from the Toolbox. It is found under Reporting tab. Select ReportViewer Tasks button (Little arrow in Top-Right of the ReportViewer) and select "Report1.rdls" from the "Choose Report" dropdown.