Click here to Skip to main content
Click here to Skip to main content

Developing Reports Using Microsoft Reporting Add-In control.

, 22 Nov 2007
Rate this:
Please Sign up or sign in to vote.
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

<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

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

Share

About the Author

satish.phadke
Web Developer
India India
No Biography provided

Comments and Discussions

 
GeneralDeployment of Reports Pinmembermantrimanoj27-Nov-07 0:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.141022.2 | Last Updated 23 Nov 2007
Article Copyright 2007 by satish.phadke
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid