ActiveReports 8
RecordsetPattern Property
See Also  Example
GrapeCity.ActiveReports.v8 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/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.
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

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