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.
<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
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.