ActiveReports 9
RecordsetPattern Property
Example 

Gets or sets a valid XPath pattern used to select the data source nodes to be printed in the report.

Syntax
'Declaration
 
Public Property RecordsetPattern As System.String
public System.string RecordsetPattern {get; set;}
Remarks

The report uses each node selected in the RecordSetPattern to create a detail section.

Note: XSL patterns are case sensitive and must use valid XSL syntax. XSL and XPath documentation can be found on MSDN at http://msdn.microsoft.com/en-us/library/ms25617228v=vs.11029.aspx and http://msdn.microsoft.com/en-us/library/ms25647128v=vs.11029.aspx

Typical XSL patterns:

Pattern                    Description

//*                            All Nodes
//ITEM                       All ITEM Nodes
/                               Root item
/LAYOUT/ITEM/*         All child nodes of /LAYOUT/ITEM
//ITEM[@type]            All item nodes that contain the type attribute
//ITEM[@id="1"]         All item nodes that have an id attribute value of "1"

Example
Paste into the Detail Format event.
GrapeCity.ActiveReports.Data.XMLDataSource xDS = new GrapeCity.ActiveReports.Data.XMLDataSource();
SectionReport1 rpt = new SectionReport1();

    xDS.ValidateOnParse = true;
    xDS.FileURL = System.Windows.Forms.Application.StartupPath + " \\customer.xml";
    xDS.RecordsetPattern = "//ITEM";
    xDS.NodeList = (System.Xml.XmlNodeList)ds.Field("ITEM",true);
    this.Label1.Text = xDS.CurrentPosition;
    Console.WriteLine(xDS.Count.ToString());

    if (xDS.BOF && xDS.EOF)
    {
        return;
    }
Paste into the Detail Format event.
Dim xDS As New GrapeCity.ActiveReports.Data.XMLDataSource()
Dim rpt As New SectionReport1()

    xDS.ValidateOnParse = True
    xDS.FileURL = System.Windows.Forms.Application.StartupPath + " \\customer.xml"
    xDS.RecordsetPattern = "//ITEM"
    xDS.NodeList = xDS.Field("ITEM", True)
    Me.Label1.Text = xDS.CurrentPosition
    Console.WriteLine(xDS.Count.ToString())

    If xDS.BOF & xDS.EOF Then
        Exit Sub
    End If
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

XMLDataSource Class
XMLDataSource Members

 

 


Copyright © 2014 GrapeCity, inc. All rights reserved

Support Forum