Developing Reports Using Microsoft Reporting Add-In control.

Introduction

Simple Tutorial for Developing Reports, Using Microsoft Reporting Add-In control.

Background

Now we can develope complex Reports, Using Microsoft Reporting Add-In control in within no time. Its very easy to create reports using Microsoft Reporting Add-In control.

Using the code

Download Reporting Add-In for Visual Studio Web Developer 2005 Express Edition form http://msdn2.microsoft.com/en-us/express/aa975050.aspx and install on your system.

Step 1:

Create the ASP.NET web site as ReportTest

Step 2: Create Report File.

Click on File->New File and create report file as Report1.rdlc

Step 3: Now open Report1.rdlc file and click on DATA -> Show Data Sources.

Step 4: In Website Data Sources dialog box click on the Add New Data Source link.

Step 5: It will open TableAdapter Configuration Wizard.

Step 6: Click on New Connection.

Step7: In Add Connection Dialog box enter Server Name, User Name, Password and database

Step8: Click on Next button

Step9: select the check box 'Yes, Save the connection as ' and click on Next

Step10: In How should the TableAdapter access the database dialog box select 'Use Sql Statement' option and click on Next.

Step11: Specify the sql Query and click on Next button

Step12: Select 'Fill a DataTable' and 'Return a DataTable' and click on Finish button.

Step14: Form Toolbox, Drag 'table' from the Report Item in Report area to populate data from sql database.

Step15: From Website data sources drag 'U_name' in Table detail area as shown in the figure.

<formulas /></formulas />

Step16: Now click on File New file and create new Web Form as ViewReport.aspx

Step17: Select 'ReportViewer' from Standard Tool box and drag in design area

Step18: Select ReportViewer and Right Click mouse button and select Smart Tag.

Step 21: Build the project and view in browser.

Points of Interest

Download Reporting Add-In for Visual Studio Web Developer 2005 Express Edition form http://msdn2.microsoft.com/en-us/express/aa975050.aspx and install on your system.

History

Keep a running update of any changes or improvements you've made here.