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