2017 R1

AppendixPermanent link for this heading

Eclipse BIRT Demo Report DesignPermanent link for this heading

The following XML data describes a report that can be used with the examples throughout this white paper.

Note: Use UTF-8 as encoding for this file.

<?xml version="1.0" encoding="UTF-8"?>

<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">

    <property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build &lt;3.7.2.v20120214-1408></property>

    <property name="units">in</property>

    <property name="iconFile">/templates/blank_report.gif</property>

    <property name="bidiLayoutOrientation">ltr</property>

    <property name="imageDPI">96</property>

    <data-sources>

        <oda-data-source extensionID="org.eclipse.datatools.enablement.oda.xml" name="Data Source" id="7">

            <property name="FILELIST">test.xml</property>

        </oda-data-source>

    </data-sources>

    <data-sets>

        <oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="logbook" id="8">

            <list-property name="columnHints">

                <structure>

                    <property name="columnName">id</property>

                    <property name="analysis">dimension</property>

                    <text-property name="heading">id</text-property>

                </structure>

                <structure>

                    <property name="columnName">objname</property>

                    <property name="analysis">attribute</property>

                    <text-property name="heading">objname</text-property>

                </structure>

                <structure>

                    <property name="columnName">logdescription</property>

                    <property name="analysis">attribute</property>

                    <text-property name="heading">logdescription</text-property>

                </structure>

                <structure>

                    <property name="columnName">logvehicleid</property>

                    <property name="analysis">dimension</property>

                    <text-property name="heading">logvehicleid</text-property>

                </structure>

            </list-property>

            <list-property name="parameters"/>

            <structure name="cachedMetaData">

                <list-property name="resultSet">

                    <structure>

                        <property name="position">1</property>

                        <property name="name">id</property>

                        <property name="dataType">string</property>

                    </structure>

                    <structure>

                        <property name="position">2</property>

                        <property name="name">objname</property>

                        <property name="dataType">string</property>

                    </structure>

                    <structure>

                        <property name="position">3</property>

                        <property name="name">logdescription</property>

                        <property name="dataType">string</property>

                    </structure>

                    <structure>

                        <property name="position">4</property>

                        <property name="name">logvehicleid</property>

                        <property name="dataType">string</property>

                    </structure>

                </list-property>

            </structure>

            <property name="dataSource">Data Source</property>

            <list-property name="resultSet">

                <structure>

                    <property name="position">1</property>

                    <property name="name">id</property>

                    <property name="nativeName">id</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                </structure>

                <structure>

                    <property name="position">2</property>

                    <property name="name">objname</property>

                    <property name="nativeName">objname</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                </structure>

                <structure>

                    <property name="position">3</property>

                    <property name="name">logdescription</property>

                    <property name="nativeName">logdescription</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                </structure>

                <structure>

                    <property name="position">4</property>

                    <property name="name">logvehicleid</property>

                    <property name="nativeName">logvehicleid</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                </structure>

            </list-property>

            <xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//logbook]#:#{id;STRING;@id},{objname;STRING;objname},{logdescription;STRING;logdescription},{logvehicleid;STRING;logvehicleid}]]></xml-property>

            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>

<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">

  <Version>2.0</Version>

  <design:ResultSets derivedMetaData="true">

    <design:resultSetDefinitions>

      <design:resultSetColumns>

        <design:resultColumnDefinitions>

          <design:attributes>

            <design:identifier>

              <design:name>id</design:name>

              <design:position>1</design:position>

            </design:identifier>

            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>

            <design:precision>-1</design:precision>

            <design:scale>-1</design:scale>

            <design:nullability>Unknown</design:nullability>

          </design:attributes>

          <design:usageHints>

            <design:label>id</design:label>

            <design:formattingHints/>

          </design:usageHints>

        </design:resultColumnDefinitions>

      </design:resultSetColumns>

      <design:criteria/>

    </design:resultSetDefinitions>

  </design:ResultSets>

</model:DesignValues>]]></xml-property>

            <list-property name="privateDriverProperties">

                <ex-property>

                    <name>MAX_ROW</name>

                    <value>-1</value>

                </ex-property>

                <ex-property>

                    <name>XML_FILE</name>

                </ex-property>

            </list-property>

        </oda-data-set>

        <oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="logtriplog" id="9">

            <list-property name="columnHints">

                <structure>

                    <property name="columnName">objname</property>

                    <text-property name="heading">objname</text-property>

                </structure>

                <structure>

                    <property name="columnName">trlfrom</property>

                    <text-property name="heading">trlfrom</text-property>

                </structure>

                <structure>

                    <property name="columnName">trluntil</property>

                    <text-property name="heading">trluntil</text-property>

                </structure>

                <structure>

                    <property name="columnName">trlmiles</property>

                    <text-property name="heading">trlmiles</text-property>

                </structure>

            </list-property>

            <list-property name="parameters">

                <structure>

                    <property name="name">logbook</property>

                    <property name="nativeName">logbook</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                    <property name="position">1</property>

                    <property name="isInput">true</property>

                </structure>

            </list-property>

            <structure name="cachedMetaData">

                <list-property name="resultSet">

                    <structure>

                        <property name="position">1</property>

                        <property name="name">objname</property>

                        <property name="dataType">string</property>

                    </structure>

                    <structure>

                        <property name="position">2</property>

                        <property name="name">trlfrom</property>

                        <property name="dataType">string</property>

                    </structure>

                    <structure>

                        <property name="position">3</property>

                        <property name="name">trluntil</property>

                        <property name="dataType">string</property>

                    </structure>

                    <structure>

                        <property name="position">4</property>

                        <property name="name">trlmiles</property>

                        <property name="dataType">string</property>

                    </structure>

                </list-property>

            </structure>

            <property name="dataSource">Data Source</property>

            <list-property name="resultSet">

                <structure>

                    <property name="position">1</property>

                    <property name="name">objname</property>

                    <property name="nativeName">objname</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                </structure>

                <structure>

                    <property name="position">2</property>

                    <property name="name">trlfrom</property>

                    <property name="nativeName">trlfrom</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                </structure>

                <structure>

                    <property name="position">3</property>

                    <property name="name">trluntil</property>

                    <property name="nativeName">trluntil</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                </structure>

                <structure>

                    <property name="position">4</property>

                    <property name="name">trlmiles</property>

                    <property name="nativeName">trlmiles</property>

                    <property name="dataType">string</property>

                    <property name="nativeDataType">12</property>

                </structure>

            </list-property>

            <xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//logbook[@id="{?logbook?}"]/logtriplog]#:#{objname;STRING;objname},{trlfrom;STRING;trlfrom},{trluntil;STRING;trluntil},{trlmiles;STRING;trlmiles}]]></xml-property>

            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>

<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">

  <Version>2.0</Version>

  <DataSetParameters>

    <parameter>

      <design:ParameterDefinition>

        <design:inOutMode>In</design:inOutMode>

        <design:attributes>

          <design:identifier>

            <design:name>logbook</design:name>

            <design:position>1</design:position>

          </design:identifier>

          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>

          <design:precision>-1</design:precision>

          <design:scale>-1</design:scale>

          <design:nullability>Unknown</design:nullability>

        </design:attributes>

      </design:ParameterDefinition>

    </parameter>

  </DataSetParameters>

  <design:ResultSets derivedMetaData="true">

    <design:resultSetDefinitions>

      <design:resultSetColumns>

        <design:resultColumnDefinitions>

          <design:attributes>

            <design:identifier>

              <design:name>objname</design:name>

              <design:position>1</design:position>

            </design:identifier>

            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>

            <design:precision>-1</design:precision>

            <design:scale>-1</design:scale>

            <design:nullability>Unknown</design:nullability>

          </design:attributes>

          <design:usageHints>

            <design:label>objname</design:label>

            <design:formattingHints/>

          </design:usageHints>

        </design:resultColumnDefinitions>

        <design:resultColumnDefinitions>

          <design:attributes>

            <design:identifier>

              <design:name>trlfrom</design:name>

              <design:position>2</design:position>

            </design:identifier>

            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>

            <design:precision>-1</design:precision>

            <design:scale>-1</design:scale>

            <design:nullability>Unknown</design:nullability>

          </design:attributes>

          <design:usageHints>

            <design:label>trlfrom</design:label>

            <design:formattingHints/>

          </design:usageHints>

        </design:resultColumnDefinitions>

        <design:resultColumnDefinitions>

          <design:attributes>

            <design:identifier>

              <design:name>trluntil</design:name>

              <design:position>3</design:position>

            </design:identifier>

            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>

            <design:precision>-1</design:precision>

            <design:scale>-1</design:scale>

            <design:nullability>Unknown</design:nullability>

          </design:attributes>

          <design:usageHints>

            <design:label>trluntil</design:label>

            <design:formattingHints/>

          </design:usageHints>

        </design:resultColumnDefinitions>

        <design:resultColumnDefinitions>

          <design:attributes>

            <design:identifier>

              <design:name>trlmiles</design:name>

              <design:position>4</design:position>

            </design:identifier>

            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>

            <design:precision>-1</design:precision>

            <design:scale>-1</design:scale>

            <design:nullability>Unknown</design:nullability>

          </design:attributes>

          <design:usageHints>

            <design:label>trlmiles</design:label>

            <design:formattingHints/>

          </design:usageHints>

        </design:resultColumnDefinitions>

      </design:resultSetColumns>

      <design:criteria/>

    </design:resultSetDefinitions>

  </design:ResultSets>

</model:DesignValues>]]></xml-property>

            <list-property name="privateDriverProperties">

                <ex-property>

                    <name>MAX_ROW</name>

                    <value>-1</value>

                </ex-property>

                <ex-property>

                    <name>XML_FILE</name>

                </ex-property>

            </list-property>

        </oda-data-set>

    </data-sets>

    <styles>

        <style name="report" id="4">

            <property name="fontFamily">sans-serif</property>

            <property name="fontSize">10pt</property>

        </style>

        <style name="crosstab-cell" id="5">

            <property name="borderBottomColor">#CCCCCC</property>

            <property name="borderBottomStyle">solid</property>

            <property name="borderBottomWidth">1pt</property>

            <property name="borderLeftColor">#CCCCCC</property>

            <property name="borderLeftStyle">solid</property>

            <property name="borderLeftWidth">1pt</property>

            <property name="borderRightColor">#CCCCCC</property>

            <property name="borderRightStyle">solid</property>

            <property name="borderRightWidth">1pt</property>

            <property name="borderTopColor">#CCCCCC</property>

            <property name="borderTopStyle">solid</property>

            <property name="borderTopWidth">1pt</property>

        </style>

        <style name="crosstab" id="6">

            <property name="borderBottomColor">#CCCCCC</property>

            <property name="borderBottomStyle">solid</property>

            <property name="borderBottomWidth">1pt</property>

            <property name="borderLeftColor">#CCCCCC</property>

            <property name="borderLeftStyle">solid</property>

            <property name="borderLeftWidth">1pt</property>

            <property name="borderRightColor">#CCCCCC</property>

            <property name="borderRightStyle">solid</property>

            <property name="borderRightWidth">1pt</property>

            <property name="borderTopColor">#CCCCCC</property>

            <property name="borderTopStyle">solid</property>

            <property name="borderTopWidth">1pt</property>

        </style>

    </styles>

    <page-setup>

        <simple-master-page name="Simple MasterPage" id="2">

            <page-footer>

                <text id="3">

                    <property name="contentType">html</property>

                    <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>

                </text>

            </page-footer>

        </simple-master-page>

    </page-setup>

    <body>

        <list id="10">

            <property name="dataSet">logbook</property>

            <list-property name="boundDataColumns">

                <structure>

                    <property name="name">id</property>

                    <text-property name="displayName">id</text-property>

                    <expression name="expression" type="javascript">dataSetRow["id"]</expression>

                    <property name="dataType">string</property>

                </structure>

                <structure>

                    <property name="name">objname</property>

                    <text-property name="displayName">objname</text-property>

                    <expression name="expression" type="javascript">dataSetRow["objname"]</expression>

                    <property name="dataType">string</property>

                </structure>

                <structure>

                    <property name="name">logdescription</property>

                    <text-property name="displayName">logdescription</text-property>

                    <expression name="expression" type="javascript">dataSetRow["logdescription"]</expression>

                    <property name="dataType">string</property>

                </structure>

            </list-property>

            <detail>

                <data id="11">

                    <property name="marginTop">10pt</property>

                    <property name="resultSetColumn">objname</property>

                </data>

                <data id="12">

                    <property name="resultSetColumn">logdescription</property>

                </data>

                <list id="30">

                    <property name="dataSet">logtriplog</property>

                    <list-property name="paramBindings">

                        <structure>

                            <property name="paramName">logbook</property>

                            <simple-property-list name="expression">

                                <value type="javascript">row["id"]</value>

                            </simple-property-list>

                        </structure>

                    </list-property>

                    <list-property name="boundDataColumns">

                        <structure>

                            <property name="name">objname</property>

                            <text-property name="displayName">objname</text-property>

                            <expression name="expression" type="javascript">dataSetRow["objname"]</expression>

                            <property name="dataType">string</property>

                        </structure>

                        <structure>

                            <property name="name">trlfrom</property>

                            <text-property name="displayName">trlfrom</text-property>

                            <expression name="expression" type="javascript">dataSetRow["trlfrom"]</expression>

                            <property name="dataType">string</property>

                        </structure>

                        <structure>

                            <property name="name">trluntil</property>

                            <text-property name="displayName">trluntil</text-property>

                            <expression name="expression" type="javascript">dataSetRow["trluntil"]</expression>

                            <property name="dataType">string</property>

                        </structure>

                        <structure>

                            <property name="name">trlmiles</property>

                            <text-property name="displayName">trlmiles</text-property>

                            <expression name="expression" type="javascript">dataSetRow["trlmiles"]</expression>

                            <property name="dataType">string</property>

                        </structure>

                    </list-property>

                    <detail>

                        <grid id="31">

                            <property name="marginBottom">0pt</property>

                            <column id="32"/>

                            <column id="33"/>

                            <column id="34"/>

                            <row id="35">

                                <cell id="36">

                                    <data id="39">

                                        <property name="resultSetColumn">trlfrom</property>

                                    </data>

                                </cell>

                                <cell id="37">

                                    <data id="40">

                                        <property name="resultSetColumn">trluntil</property>

                                    </data>

                                </cell>

                                <cell id="38">

                                    <data id="41">

                                        <property name="resultSetColumn">trlmiles</property>

                                    </data>

                                </cell>

                            </row>

                        </grid>

                    </detail>

                </list>

            </detail>

        </list>

    </body>

</report>