Tuesday, July 7, 2009

Using RDLC and DataSets to develop ASP.NET Reporting Services Reports


While developing on ASP.NET, you may experience some difficulties or hard decisions with Reporting Services. Do you really need a Reporting Services Server installed and working for your ASP.NET applications to access the reports?

The answer is RDLC, which are the Reporting Services report files on ASP.NET applications. These are simple to create, but after creating the layout, when you attempt to load data from a SQL Server 2005 database, you'll find the issue - how can I map DataSets to my report?

On RDL (Common Server Reporting Services), you can do this directly, but on RDLC, you will have to create your DataSets on your Web Application/Project, and send the correct parameters to the report so it can get the respective data from the database and show it on the report.

Sounds simple, right? The problem is trying to find this code..


This article covers the existing gap on how to send DataSets into an RDLC file so it can display a report with data.

Using the code

Even if the introduction or the concept sounds simple, you must apply the code carefully.

In the first place, drag and drop a ReportViewer into your page (in the code, I'll name it as ReportViewer1).

See full detail: http://www.codeproject.com/KB/reporting-services/RDLC_and_DataSet.aspx

No comments: