Creating a typed dataset in ReportViewer

CODE SNIPPET

I found this post that shows how to create a typed dataset. Thought I would share it here:

DataTable dt = new DataTable();
DataColumn dc = dt.Columns.Add();
dc.ColumnName = "DataColumn1";
dc = dt.Columns.Add();

dc.ColumnName = "DataColumn2";
dt.Rows.Add(new object[] { "Frank", 32 });
this.reportViewer1.LocalReport.DataSources.Clear();

this.reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1_DataTable1", dt));
this.reportViewer1.RefreshReport();


Here is the original post

Multilevel subreports in SSRS Reporting Services

CODE SNIPPETS, TUTORIAL

Microsoft's SSRS Reporting services allows 20 levels of subreports. A Subreport can be helpful when data from different datasets need to be embedded within lists, tables or matrix. When using business objects from memory, tables and lists do not allow inputting fields from different datasets. For eg: if a List is linked to a class Product, and you would like to embed a table within this list from a different class, SSRS won't let you do it. This is where subreports can be useful.

For this tutorial, I will create a main report and 2 levels of subreports.

1. Create the main report MainReport.rdlc.
2. Create two additional reports SubReport1.rdlc and SubReport2.rdlc
3. In MainReport.rdlc, drag and place a Subreport placeholder from the toolbox. Right click to view the properties and under "Use this report as a subreport" textbox, write SubReport1. Note that the extension ".rdlc" is not written in this textbox
4. Repeat step 3 in SubReport1 to create a second-level subreport
5. Now we need to bind datasources and provide data to the subreports.
6. Open Form.cs. Write the following lines in the Form1_Load() method before the this.reportViewer1.RefreshReport();

               
          reportViewer1.LocalReport.SubreportProcessing +=
new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
7. Now create a handler for the above method:

private void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e){

//this should match the DataSet name given in .rdlc filee.DataSources.Add(new ReportDataSource("Grade", (this.bindingSource6)));e.DataSources.Add(
new ReportDataSource("Measurement", (this.bindingSource5)));}

Make sure the dataset name("Grade") matches the name given in .rdlc file.

8. Go to Form's designer and click on smartag. Choose Report1.rdlc to make this the main report.

Using business objects in Report Viewer in Microsoft Visual Studio - (problems with data sources, data bindings)

I recently started using Visual Studio to create reports from business objects ( objects in C#). However, I must admit, it is a bumpy ride trying to figure out all the nicks and nacks of Reporting Software and the resources available are quite scattered and all over the place. I hope this post will help you to overcome the problems that I had during the development phase.

To create a report using ReportViewer in Visual Studio:

1. Create a new Windows Forms Application Project. This creates a Form.cs file and Form designer file.
2. Add a class which will hold all business objects. Go to Project->Add Item->C# class.
3. Write the code for returning objects in this class file.
4. Now Add a New Item and click on Dataset. If you don't find it, it is probably hidden in the "Data" section.
5. Here you would want to literally draw out your dataset. Use the toolbox on the left to "Add a DataTable". The name of the Datable could be something sensible such as "Products", "Persons" etc.
6. Add methods that return values in the columns of this datatable. Keyboard shortcut is Ctrl + L to add a new column.
7. Once you have finished adding columns, you can create another datatable or hit "Save".
8. Now "Add another Item" and add a "Report" CAUTION: DO NOT USE REPORT WIZARD. CLICK ON REPORT (NOT REPORT WIZARD). DO NOT CLICK REPORT WIZARD. Got it? Good! :)
9. Now you would need to access your Report Data. If you do not already see a Sidebar titled "Report Data", click on View-> Report Data