ActiveReports Developer 7
RecordsetPattern Property
See Also  Example
GrapeCity.ActiveReports.v7 Assembly > GrapeCity.ActiveReports.Data Namespace > XMLDataSource Class : RecordsetPattern Property

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Property RecordsetPattern As System.String
C# 
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/library/default.asp?url=/library/en-us/xmlsdk/html/xmrefxpathsyntax.asp.

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.
C#Copy Code
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.
Visual BasicCopy Code
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

See Also