In this article, I will discuss how to create reports from a business objects collection. I will be creating a Windows Forms application with reporting being processed as local processing mode. See my article, Getting started with ReportViewer control to understand local and remote processing modes.
Step 1. Create an Objects Collection
I have a class that stores an employee's information. The class looks like Listing 1.
Friend Class Employee
Private name_Renamed As String
Public Property Name() As String
Get
Return name_Renamed
End Get
Set(ByVal value As String)
name_Renamed = value
End Set
End Property
Private address_Renamed As String
Public Property Address() As String
Get
Return address_Renamed
End Get
Set(ByVal value As String)
address_Renamed = value
End Set
End Property
Private ssn_Renamed As String
Public Property Ssn() As String
Get
Return ssn_Renamed
End Get
Set(ByVal value As String)
ssn_Renamed = value
End Set
End Property
Private age_Renamed As Int16
Public Property Age() As Int16
Get
Return age_Renamed
End Get
Set(ByVal value As Int16)
age_Renamed = value
End Set
End Property
Public Sub New(ByVal EmpName As String, ByVal EmpAddress As String, ByVal EmpSsn As String, ByVal EmpAge As Int16)
Me.name_Renamed = EmpName
Me.address_Renamed = EmpAddress
Me.ssn_Renamed = EmpSsn
Me.age_Renamed = EmpAge
End Sub
End Class
Listing 1.
Now I build a Company class, which is a generic collection of Employee with three records in it. The Company class is listed in Listing 2.
Friend Class Company
Private m_employees As List(Of Employee)
Public Sub New()
m_employees = New List(Of Employee)()
m_employees.Add(New Employee("Mahesh Chand", "112 New Road, Chadds Ford, PA", "123-21-1212", 30))
m_employees.Add(New Employee("Jack Mohita", "Pear Lane, New York 23231", "878-12-2334", 23))
m_employees.Add(New Employee("Renee Singer", "Near medow, Philadelphia, PA", "980-00-2320", 20))
End Sub
Public Function GetEmployees() As List(Of Employee)
Return m_employees
End Function
End Class
Listing 2.
In Listing 2, the GetEmployees method returns all the employees in the company.
Step 2. Add a Report to the Project
Now add a report to the project by Right click on the project > Add > New Item and select Report from the items listing. It will add Report1.rdlc file to the project.
Step 3. Add a Data Source
Now I am going to add a data source to the project. Double click on your Form so Form Designer is open. Now from the Data menu of Visual Studio, select Add New Data Source item. See Figure 1.
Figure 1.
It will launch the Data Source Configuration Wizard. Select Object item on the first page. See Figure 2.
Figure 2.
Now on next screen you should see your application namespace. If you don't see the namespace, make sure to Rebuild the application.
If you expand the namespace, you should see Employee class. See Figure 3. Select Employee and click Next and click Finish on the next screen.
Figure 3.
Now you should see Employees in Data Sources window. See Figure 4.
Figure 4.
Note: When you add a DataSource to the project, the designer adds the EmployeeBindingSource to the designer, which will play a major role later.
Step 4. Bind Data Source with Report
Now open Report1.rdlc file and drag and drop a Table from the Toolbox to the report designer. Add Name, Address, Age, and Ssn items from the DataSource to the second row of the table. See Figure 5.
Note: First row in the table is Header and third row in the table is Footer. The second row is the Details row. Make sure you do not drop the items on the First and Third rows of the table, otherwise you will see only one record in your report.
Figure 5.
Now you can format the table the way you want by right clicking on the table, column, or a cell and select Properties item.
Step 5. Binding EmployeeBindingSource and Data
Now last step is to bind EmployeeBindingSource with the Employee data. If you remember, we added a GetEmployees method to the Company class that returns all the Employees in that company.
Now we simply call GetEmployees, which returns a collection and set DataSource property of EmployeeBindingSource as seen in Listing 3.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Company As Company = New Company
EmployeeBindingSource.DataSource = Company.GetEmployees
Me.reportViewer1.RefreshReport()
End Sub
End Class
Listing 3.
Step 6. Build and Run
Now build and run the application. The output looks like Figure 6.
Figure 6.
Summary
In this article, I discussed how we could take advantage of the ReportViewer control to display a generic collection of object to generate reports.