2.3 Report

Article
03/08/2023

The Report element specifies the structure, data, and layout information of a Report. The following elements MUST be specified for a Report element:

Report.Body and Report.Width in RDL 2003/10 and RDL 2005/01.
Report.Body, Report.Page, and Report.Width in RDL 2008/01.
Report.ReportSections in RDL 2010/01 and RDL 2016/01.

The following element can be specified for a Report element:

Report.ReportParametersLayout in RDL 2016/01.

The following are the child attributes of the Report element.

Child attributes
Report.MustUnderstand

The following are the child elements of the Report element.

Child elements
Report.AuthoringMetadata
Report.Author
Report.AutoRefresh
Report.Body
Report.Classes
Report.Code
Report.CodeModules
Report.ConsumeContainerWhiteSpace
Report.CustomProperties
Report.DataElementName
Report.DataElementStyle
Report.DataSchema
Report.DataSets
Report.DataSources
Report.DataTransform
Report.DefaultFontFamily
Report.DeferVariableEvaluation
Report.Description
Report.EmbeddedImages
Report.InitialPageName
Report.InteractiveHeight
Report.InteractiveWidth
Report.Language
Report.BottomMargin
Report.LeftMargin
Report.TopMargin
Report.RightMargin
Report.PageFooter
Report.PageHeader
Report.PageHeight
Report.PageWidth
Report.Page
Report.ReportParameters
Report.ReportParametersLayout
Report.Variables
Report.Width
Report.ReportSections

The following is the XML Schema definition of the Report element in RDL 2003/10.

 <xsd:element name="Report">
   <xsd:complexType>
     <xsd:choice minOccurs="1" maxOccurs="unbounded">
       <xsd:element name="Description" type="StringLocIDType" minOccurs="0" />
       <xsd:element name="Author" type="xsd:string" minOccurs="0" />
       <xsd:element name="AutoRefresh" type="xsd:unsignedInt" minOccurs="0" />
       <xsd:element name="DataSources" type="DataSourcesType" minOccurs="0" />
       <xsd:element name="DataSets" type="DataSetsType" minOccurs="0" />
       <xsd:element name="ReportParameters" type="ReportParametersType" minOccurs="0" />
       <xsd:element name="Code" type="xsd:string" minOccurs="0" />
       <xsd:element name="EmbeddedImages" type="EmbeddedImagesType" minOccurs="0" />
       <xsd:element name="Language" type="xsd:string" minOccurs="0" />
       <xsd:element name="CodeModules" type="CodeModulesType" minOccurs="0" />
       <xsd:element name="Classes" type="ClassesType" minOccurs="0" />
       <xsd:element name="Custom" type="Custom" minOccurs="0" />
       <xsd:element name="DataTransform" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataSchema" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataElementName" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataElementStyle" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string">
             <xsd:enumeration value="AttributeNormal" />
             <xsd:enumeration value="ElementNormal" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="PageHeader" type="PageHeaderFooterType" minOccurs="0" />
       <xsd:element name="PageFooter" type="PageHeaderFooter" minOccurs="0" />
       <xsd:element name="PageHeight" type="SizeType" minOccurs="0" />
       <xsd:element name="PageWidth" type="SizeType" minOccurs="0" />
       <xsd:element name="InteractiveHeight" type="SizeType" minOccurs="0" />
       <xsd:element name="InteractiveWidth" type="SizeType" minOccurs="0" />
       <xsd:element name="LeftMargin" type="SizeType" minOccurs="0" />
       <xsd:element name="RightMargin" type="SizeType" minOccurs="0" />
       <xsd:element name="TopMargin" type="SizeType" minOccurs="0" />
       <xsd:element name="BottomMargin" type="SizeType" minOccurs="0" />
       <xsd:element name="Body" type="BodyType" minOccurs="1" />
       <xsd:element name="Width" type="SizeType" minOccurs="1" />
       <xsd:any namespace="##other" processContents="skip" />
     </xsd:choice>
     <xsd:anyAttribute namespace="##other" processContents="skip" />
   </xsd:complexType>
 </xsd:element>

The following is the XML Schema definition of the Report element in RDL 2005/01.

     <xsd:element name="Report">
       <xsd:complexType>
         <xsd:choice minOccurs="1" maxOccurs="unbounded">
           <xsd:element name="Description" type="xsd:string" minOccurs="0" />
           <xsd:element name="Author" type="xsd:string" minOccurs="0" />
           <xsd:element name="AutoRefresh" type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element name="DataSources" type="DataSourcesType" minOccurs="0" />
           <xsd:element name="DataSets" type="DataSetsType" minOccurs="0" />
           <xsd:element name="Body" type="BodyType" />
           <xsd:element name="ReportParameters" type="ReportParametersType" minOccurs="0" />
           <xsd:element name="Code" type="xsd:string" minOccurs="0" />
           <xsd:element name="Width" type="SizeType" />
           <xsd:element name="PageHeader" type="PageHeaderFooterType" minOccurs="0" />
           <xsd:element name="PageFooter" type="PageHeaderFooterType" minOccurs="0" />
           <xsd:element name="PageHeight" type="SizeType" minOccurs="0" />
           <xsd:element name="PageWidth" type="SizeType" minOccurs="0" />
           <xsd:element name="InteractiveHeight" type="SizeType" minOccurs="0" />
           <xsd:element name="InteractiveWidth" type="SizeType" minOccurs="0" />
           <xsd:element name="LeftMargin" type="SizeType" minOccurs="0" />
           <xsd:element name="RightMargin" type="SizeType" minOccurs="0" />
           <xsd:element name="TopMargin" type="SizeType" minOccurs="0" />
           <xsd:element name="BottomMargin" type="SizeType" minOccurs="0" />
           <xsd:element name="EmbeddedImages" type="EmbeddedImagesType" minOccurs="0" />
           <xsd:element name="Language" type="xsd:string" minOccurs="0" />
           <xsd:element name="CodeModules" type="CodeModulesType" minOccurs="0" />
           <xsd:element name="Classes" type="ClassesType" minOccurs="0" />
           <xsd:element name="CustomProperties" type="CustomPropertiesType" minOccurs="0"/>
           <xsd:element name="DataTransform" type="xsd:string" minOccurs="0"/>
           <xsd:element name="DataSchema" type="xsd:string" minOccurs="0"/>
           <xsd:element name="DataElementName" type="xsd:string" minOccurs="0"/>
           <xsd:element name="DataElementStyle" minOccurs="0">
             <xsd:simpleType>
               <xsd:restriction base="xsd:string">
                 <xsd:enumeration value="AttributeNormal" />
                 <xsd:enumeration value="ElementNormal" />
               </xsd:restriction>
             </xsd:simpleType>
           </xsd:element>
           <xsd:any namespace="##other" processContents="skip"/>
         </xsd:choice>
         <xsd:anyAttribute namespace="##other" processContents="skip" />
       </xsd:complexType>
     </xsd:element>

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

 <xsd:element name="Report">
   <xsd:complexType>
     <xsd:choice minOccurs="1" maxOccurs="unbounded">
       <xsd:element name="Description" type="StringLocIDType" minOccurs="0" />
       <xsd:element name="Author" type="xsd:string" minOccurs="0" />
       <xsd:element name="AutoRefresh" type="xsd:unsignedInt" minOccurs="0" />
       <xsd:element name="DataSources" type="DataSourcesType" minOccurs="0" />
       <xsd:element name="DataSets" type="DataSetsType" minOccurs="0" />
       <xsd:element name="ReportParameters" type="ReportParametersType" minOccurs="0" />
       <xsd:element name="Code" type="xsd:string" minOccurs="0" />
       <xsd:element name="EmbeddedImages" type="EmbeddedImagesType" minOccurs="0" />
       <xsd:element name="Language" type="xsd:string" minOccurs="0" />
       <xsd:element name="CodeModules" type="CodeModulesType" minOccurs="0" />
       <xsd:element name="Classes" type="ClassesType" minOccurs="0" />
       <xsd:element name="CustomProperties" type="CustomPropertiesType" minOccurs="0" />
       <xsd:element name="DataTransform" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataSchema" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataElementName" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataElementStyle" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string">
             <xsd:enumeration value="Attribute" />
             <xsd:enumeration value="Element" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Variables" type="VariablesType" minOccurs="0" />
       <xsd:element name="DeferVariableEvaluation" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="ConsumeContainerWhitespace" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="Page" type="PageType" minOccurs="1" />
       <xsd:element name="Body" type="BodyType" minOccurs="1" />
       <xsd:element name="Width" type="SizeType" minOccurs="1" />
       <xsd:any namespace="##other" processContents="skip" />
     </xsd:choice>
     <xsd:anyAttribute namespace="##other" processContents="skip" />
   </xsd:complexType>
 </xsd:element>

The following is the XML Schema definition of the Report element in RDL 2010/01.

 <xsd:element name="Report">
   <xsd:complexType>
     <xsd:choice minOccurs="1" maxOccurs="unbounded">
       <xsd:element name="Description" type="StringLocIDType" minOccurs="0" />
       <xsd:element name="Author" type="xsd:string" minOccurs="0" />
       <xsd:element name="AutoRefresh" type="xsd:string" minOccurs="0" />
       <xsd:element name="InitialPageName" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataSources" type="DataSourcesType" minOccurs="0" />
       <xsd:element name="DataSets" type="DataSetsType" minOccurs="0" />
       <xsd:element name="ReportParameters" type="ReportParametersType" minOccurs="0" />
       <xsd:element name="Code" type="xsd:string" minOccurs="0" />
       <xsd:element name="EmbeddedImages" type="EmbeddedImagesType" minOccurs="0" />
       <xsd:element name="Language" type="xsd:string" minOccurs="0" />
       <xsd:element name="CodeModules" type="CodeModulesType" minOccurs="0" />
       <xsd:element name="Classes" type="ClassesType" minOccurs="0" />
       <xsd:element name="CustomProperties" type="CustomPropertiesType" minOccurs="0" />
       <xsd:element name="Variables" type="VariablesType" minOccurs="0" />
       <xsd:element name="DeferVariableEvaluation" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="ConsumeContainerWhitespace" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="DataTransform" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataSchema" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataElementName" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataElementStyle" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string">
             <xsd:enumeration value="Attribute" />
             <xsd:enumeration value="Element" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="ReportSections" type="ReportSectionsType" minOccurs="1" />
       <xsd:any namespace="##other" processContents="lax" />
     </xsd:choice>
     <xsd:anyAttribute namespace="##other" processContents="lax" />
   </xsd:complexType>
 </xsd:element>

The following is the XML Schema definition of the Report element in RDL 2016/01.

 <xsd:element name="Report">
   <xsd:complexType>
     <xsd:choice minOccurs="1" maxOccurs="unbounded">
       <xsd:element name="DefaultFontFamily" type="xsd:string" minOccurs="0" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily" />
       <xsd:element name="AuthoringMetadata" type="xsd:string" minOccurs="0" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/authoringmetadata" />
       <xsd:element name="Description" type="StringLocIDType" minOccurs="0" />
       <xsd:element name="Author" type="xsd:string" minOccurs="0" />
       <xsd:element name="AutoRefresh" type="xsd:string" minOccurs="0" />
       <xsd:element name="InitialPageName" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataSources" type="DataSourcesType" minOccurs="0" />
       <xsd:element name="DataSets" type="DataSetsType" minOccurs="0" />
       <xsd:element name="ReportParameters" type="ReportParametersType" minOccurs="0" />
       <xsd:element name="ReportParametersLayout" type="ReportParametersLayoutType" minOccurs="0" />
       <xsd:element name="Code" type="xsd:string" minOccurs="0" />
       <xsd:element name="EmbeddedImages" type="EmbeddedImagesType" minOccurs="0" />
       <xsd:element name="Language" type="xsd:string" minOccurs="0" />
       <xsd:element name="CodeModules" type="CodeModulesType" minOccurs="0" />
       <xsd:element name="Classes" type="ClassesType" minOccurs="0" />
       <xsd:element name="CustomProperties" type="CustomPropertiesType" minOccurs="0" />
       <xsd:element name="Variables" type="VariablesType" minOccurs="0" />
       <xsd:element name="DeferVariableEvaluation" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="ConsumeContainerWhitespace" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="DataTransform" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataSchema" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataElementName" type="xsd:string" minOccurs="0" />
       <xsd:element name="DataElementStyle" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string">
             <xsd:enumeration value="Attribute" />
             <xsd:enumeration value="Element" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="ReportSections" type="ReportSectionsType" minOccurs="1" />
       <xsd:any namespace="##other" processContents="lax" />
     </xsd:choice>
     <xsd:attribute name="MustUnderstand" type="MustUnderstandType" />
     <xsd:anyAttribute namespace="##other" processContents="lax" />
   </xsd:complexType>
 </xsd:element>

2.3 Report

Additional resources