2.325 DataSet

Article
03/08/2023

The DataSet element specifies information about a set of data to be used as a part of a Report.

The following are the parent elements, attributes, and child elements of the DataSet element.

Parent elements
DataSets

Attributes
DataSet.Name

Child elements
DataSet.AccentSensitivity
DataSet.CaseSensitivity
DataSet.Collation
DataSet.Fields
DataSet.Filters
DataSet.InterpretSubtotalsAsDetails
DataSet.KanatypeSensitivity
DataSet.Query
DataSet.SharedDataSet
DataSet.WidthSensitivity

Applies to RDL 2011/01

Child elements
DataSet.DefaultRelationships
DataSet.NullsAsBlanks
DataSet.CollationCulture

The following is the XML Schema definition of the DataSet element in RDL 2003/10 and RDL 2005/01.

 <xsd:complexType name="DataSetType">
   <xsd:choice minOccurs="1" maxOccurs="unbounded">
     <xsd:element name="Fields" type="FieldsType" minOccurs="0" />
     <xsd:element name="Query" type="QueryType" />
     <xsd:element name="CaseSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="Collation" type="xsd:string" minOccurs="0" />
     <xsd:element name="AccentSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="KanatypeSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="WidthSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="Filters" type="FiltersType" minOccurs="0" />
     <xsd:any namespace="##other" processContents="skip" />
   </xsd:choice>
   <xsd:attribute name="Name" type="xsd:normalizedString" use="required" />
   <xsd:anyAttribute namespace="##other" processContents="skip" />
 </xsd:complexType>

The following is the XML Schema definition of the DataSet element in RDL 2008/01.

 <xsd:complexType name="DataSetType">
   <xsd:choice minOccurs="1" maxOccurs="unbounded">
     <xsd:element name="Fields" type="FieldsType" minOccurs="0" />
     <xsd:element name="Query" type="QueryType" />
     <xsd:element name="CaseSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="Collation" type="xsd:string" minOccurs="0" />
     <xsd:element name="AccentSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="KanatypeSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="WidthSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="Filters" type="FiltersType" minOccurs="0" />
     <xsd:element name="InterpretSubtotalsAsDetails" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:any namespace="##other" processContents="skip" />
   </xsd:choice>
   <xsd:attribute name="Name" type="xsd:normalizedString" use="required" />
   <xsd:anyAttribute namespace="##other" processContents="skip" />
 </xsd:complexType>

The following is the XML Schema definition of the DataSet element in RDL 2010/01 and RDL 2016/01.

Note The following XSD represents RDL macro-versioned schemas only. Possible additions, identified earlier in this section, to base schema RDL 2010/01 from micro-versioned schemas RDL 2011/01, RDL 2012/01, and RDL 2013/01 are provided in sections 5.5, 5.6, and 5.7, respectively. For more information about macro- and micro-versioned schemas, see section 2.1.

 <xsd:complexType name="DataSetType">
   <xsd:choice minOccurs="1" maxOccurs="unbounded">
     <xsd:element name="Fields" type="FieldsType" minOccurs="0" />
     <xsd:element name="Query" type="QueryType" minOccurs="0" />
     <xsd:element name="SharedDataSet" type="SharedDataSetType" minOccurs="0" />
     <xsd:element name="CaseSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="Collation" type="xsd:string" minOccurs="0" />
     <xsd:element name="AccentSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="KanatypeSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="WidthSensitivity" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:element name="Filters" type="FiltersType" minOccurs="0" />
     <xsd:element name="InterpretSubtotalsAsDetails" minOccurs="0">
       <xsd:simpleType>
         <xsd:restriction base="xsd:string">
           <xsd:enumeration value="True" />
           <xsd:enumeration value="False" />
           <xsd:enumeration value="Auto" />
         </xsd:restriction>
       </xsd:simpleType>
     </xsd:element>
     <xsd:any namespace="##other" processContents="lax" />
   </xsd:choice>
   <xsd:attribute name="Name" type="xsd:normalizedString" use="required" />
   <xsd:anyAttribute namespace="##other" processContents="lax" />
 </xsd:complexType>

2.325 DataSet

Additional resources