<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
    <property name="comments">IBM Confidential

OCO Source Materials

5724-M19

(C) COPYRIGHT IBM CORP. 2006

The source code for this program is not published or otherwise
divested of its trade secrets, irrespective of what has been
deposited with the U.S. Copyright Office.

09-19764@000</property>
    <property name="createdBy">Eclipse BIRT Designer Version 4.3.1.v201309091055 Build &lt;4.3.1.v20130917-1035></property>
    <html-property name="description">This template will create a report with one or more subreports, each having different data fields.</html-property>
    <property name="units">in</property>
    <method name="initialize"><![CDATA[importPackage(Packages.com.ibm.tivoli.maximo.report.script);

mxReportScriptContext = MXReportScriptContext.initialize(reportContext);]]></method>
    <method name="beforeFactory"><![CDATA[// Remove page break intervals from PDF output
if ( (reportContext.getParameterValue("usepagebreaks") == "false")|| reportContext.getOutputFormat() == "pdf" ) {
	// Give each table in the report a name, and add the names to the list below, e.g. ["mainTable", "childTable1"]
	var tableListing = ["mainTable", "childTable1", "childTable2"];
	for each(var tableName in tableListing) {
		var table = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement(tableName)
		if (table != null)
		{
			table.setProperty("pageBreakInterval", 0);
		}
	}
}]]></method>
    <method name="afterFactory"><![CDATA[MXReportScriptContext.close();]]></method>
    <property name="theme">MaximoSystemLibrary.maximoTheme</property>
    <text-property name="displayName">Tivoli Maximo Subreport Template</text-property>
    <property name="layoutPreference">auto layout</property>
    <list-property name="libraries">
        <structure>
            <property name="fileName">MaximoSystemLibrary.rptlibrary</property>
            <property name="namespace">MaximoSystemLibrary</property>
        </structure>
    </list-property>
    <template-parameter-definitions>
        <template-parameter-definition name="NewTemplateParameterDefinition" id="71">
            <property name="allowedType">Label</property>
            <text-property name="description">Double-click to enter the report title.</text-property>
            <default>
                <label id="72">
                    <text-property name="text">Report Title</text-property>
                </label>
            </default>
        </template-parameter-definition>
    </template-parameter-definitions>
    <parameters>
        <scalar-parameter name="where" id="25">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <simple-property-list name="defaultValue">
                <value type="constant">1=1</value>
            </simple-property-list>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="appname" id="731">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="paramdelimiter" id="733">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="paramstring" id="732">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="usepagebreaks" id="829">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">true</value>
            </simple-property-list>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <script-data-source name="maximoDataSource" id="64" extends="MaximoSystemLibrary.maximoDataSource"/>
    </data-sources>
    <data-sets>
        <script-data-set name="mainDataSet" id="5">
            <structure name="cachedMetaData"/>
            <property name="dataSource">maximoDataSource</property>
            <method name="open"><![CDATA[maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
maximoDataSet.open();

var sqlText = new String();

// Add query to sqlText variable.
sqlText = "select textfield, datefield from table"
// Include the Maximo where clause
+ " where " + params["where"]
;

maximoDataSet.setQuery(sqlText);]]></method>
            <method name="fetch"><![CDATA[if (!maximoDataSet.fetch())
	return (false);

// Add a line for each output column
// The specific get method should match the data type of the output column.
row["textfield"] = maximoDataSet.getString("textfield");	
row["datefield"] = maximoDataSet.getTimestamp("datefield");	

return (true);]]></method>
        </script-data-set>
        <script-data-set name="subDataSet" id="239">
            <structure name="cachedMetaData"/>
            <property name="dataSource">maximoDataSource</property>
            <method name="open"><![CDATA[subDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
subDataSet.open();

var sqlText = new String();

// Add query to sqlText variable.
sqlText = "select textfield, datefield from table"
// Include the Maximo where clause
+ " where " + params["where"]
;

subDataSet.setQuery(sqlText);]]></method>
            <method name="fetch"><![CDATA[if (!subDataSet.fetch())
	return (false);

// Add a line for each output column
// The specific get method should match the data type of the output column.
row["textfield"] = subDataSet.getString("textfield");	
row["datefield"] = subDataSet.getTimestamp("datefield");	


return (true);]]></method>
        </script-data-set>
    </data-sets>
    <page-setup>
        <simple-master-page name="maximoLandscape" id="47" extends="MaximoSystemLibrary.maximoLandscape">
            <overridden-values>
                <ref-entry baseId="304" name="NewGrid2" id="304"/>
                <ref-entry baseId="305" id="305"/>
                <ref-entry baseId="306" id="306"/>
                <ref-entry baseId="307" id="307"/>
                <ref-entry baseId="308" id="308"/>
                <ref-entry baseId="309" id="309"/>
                <ref-entry baseId="310" name="NewImage" id="310"/>
                <ref-entry baseId="322" name="NewGrid" id="322"/>
                <ref-entry baseId="323" id="323"/>
                <ref-entry baseId="324" id="324"/>
                <ref-entry baseId="325" id="325"/>
                <ref-entry baseId="326" id="326"/>
                <ref-entry baseId="328" name="NewText" id="328"/>
                <ref-entry baseId="327" id="327"/>
                <ref-entry baseId="329" name="NewGrid1" id="329"/>
                <ref-entry baseId="330" id="330"/>
                <ref-entry baseId="331" id="331"/>
                <ref-entry baseId="332" id="332"/>
                <ref-entry baseId="333" id="333"/>
                <ref-entry baseId="334" id="334"/>
                <ref-entry baseId="335" name="NewAutoText" id="335"/>
                <ref-entry baseId="336" id="336"/>
                <ref-entry baseId="337" name="NewText1" id="337"/>
                <ref-entry baseId="338" id="338"/>
                <ref-entry baseId="339" name="NewAutoText1" id="339"/>
            </overridden-values>
        </simple-master-page>
    </page-setup>
    <body>
        <table name="mainTable" id="7">
            <property name="width">100%</property>
            <property name="dataSet">mainDataSet</property>
            <property name="pageBreakInterval">50</property>
            <column id="83"/>
            <column id="79"/>
            <column id="91"/>
            <column id="87"/>
            <column id="17"/>
            <column id="18"/>
            <header>
                <row id="209">
                    <property name="style">title</property>
                    <cell id="210">
                        <property name="colSpan">6</property>
                        <property name="rowSpan">1</property>
                        <template-report-item id="130">
                            <property name="refTemplateParameter">NewTemplateParameterDefinition</property>
                        </template-report-item>
                    </cell>
                </row>
                <row id="202">
                    <cell id="203">
                        <property name="colSpan">6</property>
                        <property name="rowSpan">1</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <grid id="109">
                            <property name="width">100%</property>
                            <column id="110">
                                <property name="style">reportheaderlabel</property>
                                <property name="width">1in</property>
                            </column>
                            <column id="111">
                                <property name="style">reportheaderdata</property>
                                <property name="width">8.875in</property>
                            </column>
                            <row id="112">
                                <cell id="113">
                                    <label id="118">
                                        <text-property name="text">Parameter 1:</text-property>
                                    </label>
                                </cell>
                                <cell id="114">
                                    <property name="paddingLeft">2px</property>
                                </cell>
                            </row>
                            <row id="115">
                                <cell id="116">
                                    <label id="119">
                                        <text-property name="text">Parameter 2:</text-property>
                                    </label>
                                </cell>
                                <cell id="117">
                                    <property name="paddingLeft">2px</property>
                                </cell>
                            </row>
                        </grid>
                    </cell>
                </row>
            </header>
            <group id="828">
                <property name="groupName">tableGroup</property>
                <property name="interval">none</property>
                <property name="sortDirection">asc</property>
                <property name="repeatHeader">true</property>
                <property name="hideDetail">false</property>
                <property name="pageBreakAfter">always-excluding-last</property>
                <property name="pageBreakBefore">auto</property>
            </group>
            <detail>
                <row id="615">
                    <cell id="616">
                        <property name="colSpan">6</property>
                        <property name="rowSpan">1</property>
                        <grid id="653">
                            <property name="width">100%</property>
                            <column id="654">
                                <property name="style">reportheaderlabel</property>
                                <property name="width">1in</property>
                            </column>
                            <column id="655">
                                <property name="style">reportheaderdata</property>
                            </column>
                            <row id="659">
                                <cell id="660">
                                    <label id="671"/>
                                </cell>
                                <cell id="662">
                                    <property name="paddingLeft">2px</property>
                                </cell>
                            </row>
                            <row id="664">
                                <cell id="665">
                                    <label id="673"/>
                                </cell>
                                <cell id="667">
                                    <property name="paddingLeft">2px</property>
                                </cell>
                            </row>
                        </grid>
                    </cell>
                </row>
                <row id="539">
                    <cell id="540">
                        <property name="colSpan">6</property>
                        <property name="rowSpan">1</property>
                        <table name="childTable1" id="546">
                            <property name="comments">09-19764@000</property>
                            <property name="width">100%</property>
                            <property name="pageBreakInterval">50</property>
                            <column id="568"/>
                            <column id="569"/>
                            <column id="570"/>
                            <column id="571"/>
                            <column id="572"/>
                            <column id="573"/>
                            <header>
                                <row id="675">
                                    <property name="style">tableheaderrow</property>
                                    <cell id="676">
                                        <property name="colSpan">2</property>
                                        <property name="rowSpan">1</property>
                                        <property name="style">tableheaderlabel</property>
                                        <label id="684"/>
                                    </cell>
                                    <cell id="678"/>
                                    <cell id="679"/>
                                    <cell id="680"/>
                                    <cell id="681"/>
                                </row>
                                <row id="547">
                                    <property name="style">tabledetailslabel</property>
                                    <cell id="548">
                                        <property name="style">tabledetailslabelcell</property>
                                        <label id="575"/>
                                    </cell>
                                    <cell id="549">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                    <cell id="550">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                    <cell id="551">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                    <cell id="552">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                    <cell id="553">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                </row>
                            </header>
                            <detail>
                                <row id="554">
                                    <property name="style">tabledetailsdatarow</property>
                                    <cell id="555">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="556">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="557">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="558">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="559">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="560">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                </row>
                            </detail>
                        </table>
                        <table name="childTable2" id="777">
                            <property name="comments">09-19764@000</property>
                            <property name="width">100%</property>
                            <property name="pageBreakInterval">50</property>
                            <column id="806"/>
                            <column id="807"/>
                            <column id="808"/>
                            <column id="809"/>
                            <column id="810"/>
                            <column id="811"/>
                            <header>
                                <row id="780">
                                    <property name="style">tableheaderrow</property>
                                    <cell id="781">
                                        <property name="colSpan">2</property>
                                        <property name="rowSpan">1</property>
                                        <property name="style">tableheaderlabel</property>
                                        <label id="782"/>
                                    </cell>
                                    <cell id="784"/>
                                    <cell id="785"/>
                                    <cell id="786"/>
                                    <cell id="787"/>
                                </row>
                                <row id="788">
                                    <property name="style">tabledetailslabel</property>
                                    <cell id="789">
                                        <property name="style">tabledetailslabelcell</property>
                                        <label id="790"/>
                                    </cell>
                                    <cell id="791">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                    <cell id="792">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                    <cell id="793">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                    <cell id="794">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                    <cell id="795">
                                        <property name="style">tabledetailslabelcell</property>
                                    </cell>
                                </row>
                            </header>
                            <detail>
                                <row id="796">
                                    <property name="style">tabledetailsdatarow</property>
                                    <cell id="797">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="799">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="800">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="801">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="802">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                    <cell id="803">
                                        <property name="style">tabledetailsdatacell</property>
                                    </cell>
                                </row>
                            </detail>
                        </table>
                    </cell>
                </row>
            </detail>
        </table>
    </body>
</report>
