In ActiveReports for .NET 2.0, data sets with relationships can be used to populate fields in subreports.

Note   Subreports will not render PageHeader/Footer sections.

This walkthrough illustrates how to use data sets with relationships in nested subreports.

This walkthrough is split up into the following activities:

• Adding three ActiveReports to a Visual Studio project
• Adding controls to each report to display the data
• Setting the data connection for the reports, creating and filling data adapters and adding data set relations
• Adding the code needed to set the subreport control's data source equal to returned row collection of the data set
• Viewing the report 

To complete the walkthrough, you must have access to the NorthWind database (NWind.mdb).

When you have finished this walkthrough, you will have a report that looks similar to the following.

Adding three ActiveReports to a Visual Studio project

To add three ActiveReports to a Visual Studio project

1. Open a new project in Visual Studio.
2. Click on Project > Add New Item.
3. Select ActiveReports file and rename the file rptCategories.
4. Click Open.
5. Click on Project > Add New Item.
6. Select ActiveReports file and rename the file rptProductsSub.
7. Click Open.
8. Click on Project > Add New Item.
9. Select ActiveReports file and rename the file rptOrderDetailsSub.
10. Click Open.

Adding controls to display the data

To add controls to the reports

1. Add a GroupHeader/Footer section to rptCategories.
2. Make the following changes to the group header:
   • Change the name to ghCategories
   • Change the UnderlayNext property to True
   • Change the GroupKeepTogether property to FirstDetail
   • Change the DataField property to CategoryName
3. Add the following controls to rptCategories, naming them as indicated:

   Control	DataField	Name	Text/Caption	Section	Location
   Label	(Empty string)	lblCategoryName	Category Name	PageHeader	0, 0
   Label	(Empty string)	lblProduct	Product	PageHeader	1.25, 0
   Label	(Empty string)	lblOrderDetails	Order Details	PageHeader	2.75, 0
   TextBox	CategoryName	txtCategoryName	Category Name	GroupHeader	0, 0
   Subreport	(Empty string)	SubReport1	(Empty string)	Detail	1.25, 0

4. Add a GroupHeader/Footer section to rptProductsSub.
5. Make the following changes to the group header:
   • Change the Name to ghProducts
   • Change the UnderlayNext property to True
   • Change the GroupKeepTogether property to FirstDetail
   • Change the DataField property to ProductName
6. Add the following controls to rptProductsSub, naming them as indicated:

   Control	DataField	Name	Text/Caption	Section	Location
   TextBox	ProductName	txtProductName	Product Name	GroupHeader	0, 0
   Label	(Empty string)	lblUnitPrice	Unit Price	Detail	1.4375, 0
   Label	(Empty string)	lblQuantity	Quantity	Detail	2.5625, 0
   Label	(Empty string)	lblPrice	Price	Detail	3.5625, 0
   Subreport	(Empty string)	SubReport1	(Empty string)	Detail	1.4375, 0.1875

7. Add the following controls to the Detail section of rptOrderDetailsSub, naming them as indicated:

   Control	DataField	Name	Text/Caption	OutputFormat	Location
   TextBox	UnitPrice	txtUnitPrice	Unit Price	Currency	0, 0
   TextBox	Quantity	txtQuantity	Quantity	(Empty string)	1, 0
   TextBox	Discount	txtDiscount	Discount	Currency	2, 0

Setting the data connections, data adapters and data set relations

To set the data connections

1. Add a Windows Form to your project.
2. Add an ActiveReports viewer control to Form1 and set the Dock property to Fill.

To write the code for the viewer in Visual Basic

• Right-click on Form1, and click on View Code to display the code view for the form. At the top left of the code view for Form1, click the drop-down arrow and select (Base Class Events). At the top right of the code window, click the drop-down arrow and select Load. This creates an event-handling method for the Form1_Load event. Add code to the handler to:
  • Set the data connections
  • Create and fill the data adapters
  • Create data set relationships
  • Format the viewer to show the report when it is run

To write the code for the viewer in C#

• Click on the blue section at the top of Form1 to select the form. Click on the events icon in the Properties window to display available events for Form1. Double-click Load. This creates an event-handling method for the Form1_Load event. Add code to the handler to:
  • Set the data connections
  • Create and fill the data adapters
  • Create data set relationships
  • Format the viewer to show the report when it is run

  The following example shows what the code for the method looks like.

  'Visual Basic
  Dim myJoinedDS As New DataSet()
  Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) _
  	Handles MyBase.Load
  	Dim rpt As New rptCategories()
  	Dim cnnString As String
  	Dim cnn As New OleDb.OleDbConnection()
  	cnnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\NWIND.MDB"
  	cnn = New OleDb.OleDbConnection(cnnString)
  	cnn.Open()
  	Dim catAd As New OleDb.OleDbDataAdapter("Select * from categories order by _
  		categoryname", cnn)
  	Dim prodAd As New OleDb.OleDbDataAdapter("Select * from products order by _
  		productname", cnn)
  	Dim ODAd As New OleDb.OleDbDataAdapter("Select * from [order details]", cnn)
  	catAd.Fill(myJoinedDS, "Categories")
  	prodAd.Fill(myJoinedDS, "Products")
  	ODAd.Fill(myJoinedDS, "OrderDetails")
  	Me.myJoinedDS.Relations.Add("CategoriesProducts", myJoinedDS.Tables("Categories") _
  		.Columns("CategoryID"), myJoinedDS.Tables("Products").Columns("CategoryID"))
  	Me.myJoinedDS.Relations.Add("ProductsOrderDetails", myJoinedDS.Tables("Products") _
  		.Columns("ProductID"), myJoinedDS.Tables("OrderDetails").Columns("ProductID"))
  	rpt.DataSource = (myJoinedDS)
  	rpt.DataMember = "Categories"
  	rpt.Run()
  	Me.Viewer1.Document = rpt.Document
  End Sub

   

  //C#
  public DataSet myJoinedDS = new DataSet();
  private void Form1_Load(object sender, System.EventArgs e)
  {
  	rptCategories rpt = new rptCategories();
  	string cnnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\NWIND.MDB";
  	OleDbConnection cnn=new OleDbConnection(cnnString);
  	cnn.Open();
  	OleDbDataAdapter catAd  = new OleDbDataAdapter("Select * from categories order 
  		by categoryname",cnn);
  	OleDbDataAdapter prodAd  = new OleDbDataAdapter("Select * from products order by 
  		productname",cnn);
  	OleDbDataAdapter ODAd  = new OleDbDataAdapter("Select * from [order details]",
  		cnn);
  	catAd.Fill(myJoinedDS, "Categories");
  	prodAd.Fill(myJoinedDS, "Products");
  	ODAd.Fill(myJoinedDS, "OrderDetails");
  	this.myJoinedDS.Relations.Add("CategoriesProducts", myJoinedDS.Tables
  		["Categories"].Columns["CategoryID"], myJoinedDS.Tables["Products"].Columns
  		["CategoryID"]);
  	this.myJoinedDS.Relations.Add("ProductsOrderDetails", myJoinedDS.Tables
  		["Products"].Columns["ProductID"], myJoinedDS.Tables["OrderDetails"].Columns
  		["ProductID"]);
  	rpt.DataSource = (myJoinedDS);
  	rpt.DataMember = "Categories";
  	rpt.Run();
  	this.viewer1.Document = rpt.Document;
  }

  Adding the code needed to set the subreport's data source control equal to the data set's returned row collection for rptCategories

  To write the code in Visual Basic

  • Right-click in any section of the design window of rptCategories, and click on View Code to display the code view for the report. At the top left of the code view for rptCategories, click the drop-down arrow and select Detail. At the top right of the code window, click the drop-down arrow and select Format. This creates an event-handling method for rptCategories' Detail_Format event.

  To write the code in C#

  • Click in the Detail section of rptCategories to select the section. Click on the events icon in the Properties window to display available events for the section. Double-click Format. This creates an event-handling method for rptCategories' Detail_Format event.

    The following example shows what the code for the method looks like.

    'Visual Basic
    Dim cnt As Integer
    Private Sub Detail_Format(ByVal sender As Object, ByVal e As System.EventArgs) _
    	Handles Detail.Format
            Dim drCategories As DataRow
            If CType(Me.DataSource, DataSet).Tables("Categories").Rows.Count > cnt Then
            	drCategories = CType(Me.DataSource, DataSet).Tables("Categories") _
            		.Rows(cnt)
            	cnt = cnt + 1
            End If
            Dim rpt As New rptProductsSub()
            rpt.DataSource = drCategories.GetChildRows(CType(Me.DataSource, DataSet) _
            	.Relations("CategoriesProducts"))
            Me.SubReport1.Report = rpt
    End Sub

     

    //C#
    int cnt;
    private void Detail_Format(object sender, System.EventArgs eArgs)
    {
    	DataRow drCategories = null;
    	if(((DataSet)this.DataSource).Tables["Categories"].Rows.Count>cnt)
    	{
    		drCategories = ((DataSet)this.DataSource).Tables["Categories"]
    			.Rows[cnt];
    		cnt++;
    	}
    	rptProductsSub rpt = new rptProductsSub();
    	rpt.DataSource = drCategories.GetChildRows(((DataSet)this.DataSource)
    		.Relations["CategoriesProducts"]);
    	this.SubReport1.Report = rpt;
    }

  Adding the code needed to set the subreport's data source control equal to the data set's returned row collection for rptProductsSub

  To write the code in Visual Basic

  • Right-click in any section of the design window of rptProductsSub, and click on View Code to display the code view for the report. At the top left of the code view for rptProductsSub, click the drop-down arrow and select Detail. At the top right of the code window, click the drop-down arrow and select Format. This creates an event-handling method for rptProductsSub's Detail_Format event.

  To write the code in C#

  • Click in the Detail section of rptProductsSub to select the section. Click on the events icon in the Properties window to display available events for the section. Double-click Format. This creates an event-handling method for rptProductsSub's Detail_Format event.

    The following example shows what the code for the method looks like.

    'Visual Basic
    Dim cnt As Integer
    Private Sub Detail_Format(ByVal sender As Object, ByVal e As System.EventArgs) _
    	Handles Detail.Format
    	Dim rpt As New rptOrderDetailsSub()
    	Dim drc() As DataRow
    	drc = CType(Me.DataSource, DataRow())
    	rpt.DataSource = drc(cnt).GetChildRows("ProductsOrderDetails")
    	Me.SubReport1.Report = rpt
    	cnt = cnt + 1
    End Sub

     

    //C#
    int cnt;
    private void Detail_Format(object sender, System.EventArgs eArgs)
    {
    	rptOrderDetailsSub rpt = new rptOrderDetailsSub();
    	DataRow[] drc = ((DataRow[])this.DataSource);
    	rpt.DataSource = drc[cnt].GetChildRows("ProductsOrderDetails");
    	this.SubReport1.Report = rpt;
    	cnt++;
    }

Viewing the report

To view the report

1. Add the ActiveReports viewer control to a Windows Form.
2. Add the code needed to set the viewer document equal to the report document. See Using the ActiveReports WinForm Viewer for help.

Samples | Walkthroughs | Binding Reports to a Data Source | OutputFormat Strings | GroupKeepTogether enumeration

 

 

---

Copyright © 2004-2005 Data Dynamics, Ltd. All rights reserved.