Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / web / ASP.NET

Developing Reports Using Microsoft Reporting Add-In control.

1.22/5 (5 votes)
23 Nov 20072 min read 1  
Tutorial for 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

Screenshot - Screen1-1.jpg

Step 2: Create Report File.

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

Screenshot - Screen2-1.jpg

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.

Screenshot - Screen4-1.jpg

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

Screenshot - Screen6-1.jpg

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

Screenshot - Screen7-1.jpg

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

Screenshot - Screen9-1.jpg

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

Screenshot - Screen10-1.jpg

<shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><stroke joinstyle="miter"><formulas /><f eqn="if lineDrawn pixelLineWidth 0"><f eqn="sum @0 1 0"><f eqn="sum 0 0 @1"><f eqn="prod @2 1 2"><f eqn="prod @3 21600 pixelWidth"><f eqn="prod @3 21600 pixelHeight"><f eqn="sum @0 0 1"><f eqn="prod @6 1 2"><f eqn="prod @7 21600 pixelWidth"><f eqn="sum @8 21600 0"><f eqn="prod @7 21600 pixelHeight"><f eqn="sum @10 21600 0"></formulas /><path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"><lock aspectratio="t" v:ext="edit"><shape id="_x0000_i1025" style="WIDTH: 431.25pt; HEIGHT: 228.75pt" type="#_x0000_t75"><imagedata cropbottom="13046f" croptop="6220f" src="file:///C:\DOCUME~1\SATISH~1.PHA\LOCALS~1\Temp\msohtml1\01\clip_image001.png">

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

Screenshot - Screen11-1.jpg

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

Screenshot - Screen12-1.jpg

Step 21: Build the project and view in browser.

Screenshot - Screen14-1.jpg

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.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here