Sunday, December 19, 2010

Reporting in .NET

Most business applications require some type of reporting. Why bother with all of the CRUD (create, review, update, delete) if there is no reporting on all that data?

With .NET, there are several reporting options and features. This set of posts focuses on two features:
Report file: An installed template in Visual Studio for building the layout for a report.
ReportViewer: A control in the toolbox that can be added to a form for displaying the report to the user.
The example below provides an overview of building the "world's simplest report". In building the "simplest" report, there are still a very large number of steps. So this post provides an overview and other referenced posts provide detail.

To Create a Report:

1) Add a report file to your project.
Select Project | Add New Item, click on Reporting under Installed Templates on the left and then select Report (or Report Wizard if you want to use the Wizard) in the middle.

NOTE: Though using the Report Wizard could arguably be the best approach when building the "world's simplest report", when I first starting building reports with these tools I found the Wizard to be confusing (DataSource, DataSet, Row group, Column group, etc) . So for clarity, these posts walk through the manual steps.

Read more: Deborah's Developer MindScape