Home » Archived » BIRT » Export Birt report in Excel(Export Birt report in Excel)
Export Birt report in Excel [message #649278] |
Tue, 18 January 2011 09:43  |
Eclipse User |
|
|
|
I need your help with one the reports that i have. It has got many columns, about 21. When I export it to excel it merges some of the columns. How do i fix this problem in birt.
|
|
| | | | |
Re: Export Birt report in Excel [message #649505 is a reply to message #649278] |
Wed, 19 January 2011 09:02   |
Eclipse User |
|
|
|
This is it. Please help
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build <2.3.2.v20090218-0730></property>
<property name="units">in</property>
<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.</property>
<html-property name="description">This template will create a report having a single header with multiple rows of data.</html-property>
<method name="initialize">< ![CDATA[importPackage(Packages.com.ibm.tivoli.maximo.report. script);
mxReportScriptContext = MXReportScriptContext.initialize(reportContext);]]></method >
<method name="afterFactory"><![CDATA[MXReportScriptContext.close();]] ></method>
<property name="theme">MaximoSystemLibrary.maximoTheme</property>
<text-property name="displayName">Tivoli Maximo List Template</text-property>
<property name="bidiLayoutOrientation">ltr</property>
<list-property name="libraries">
<structure>
<property name="fileName">MaximoSystemLibrary.rptlibrary</property>
<property name="namespace">MaximoSystemLibrary</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="where" id="25">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">1=1</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="appname" id="200">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="paramdelimiter" id="202">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="paramstring" id="201">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="startdate" id="504">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">10-11-01</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="enddate" id="505">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">11-01-07</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="siteid" id="506">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">=CENTRAL</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="CostCentre" id="507">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">561401</property>
<property name="distinct">true</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="dataSet1" id="415">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">costcentre</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">uniqueno</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">empname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">refwo</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">activity</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">StartDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">finishdate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">allowtype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">worklocation</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">Approved</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">months</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">dates</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">timefrom</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">timeto</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">hours</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">ErrorReport</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Reversal</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">ErrorMessage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">Recordid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">enterby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">n_authorisedby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">Capture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">today</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">ldesc</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">costcentre</property>
</structure>
<structure>
<property name="columnName">uniqueno</property>
</structure>
<structure>
<property name="columnName">empname</property>
</structure>
<structure>
<property name="columnName">refwo</property>
</structure>
<structure>
<property name="columnName">activity</property>
</structure>
<structure>
<property name="columnName">StartDate</property>
</structure>
<structure>
<property name="columnName">finishdate</property>
</structure>
<structure>
<property name="columnName">allowtype</property>
</structure>
<structure>
<property name="columnName">worklocation</property>
</structure>
<structure>
<property name="columnName">Approved</property>
</structure>
<structure>
<property name="columnName">months</property>
</structure>
<structure>
<property name="columnName">dates</property>
</structure>
<structure>
<property name="columnName">timefrom</property>
</structure>
<structure>
<property name="columnName">timeto</property>
</structure>
<structure>
<property name="columnName">hours</property>
</structure>
<structure>
<property name="columnName">ErrorReport</property>
</structure>
<structure>
<property name="columnName">Reversal</property>
</structure>
<structure>
<property name="columnName">ErrorMessage</property>
</structure>
<structure>
<property name="columnName">Recordid</property>
</structure>
<structure>
<property name="columnName">enterby</property>
</structure>
<structure>
<property name="columnName">n_authorisedby</property>
</structure>
<structure>
<property name="columnName">Capture</property>
</structure>
<structure>
<property name="columnName">today</property>
</structure>
<structure>
<property name="columnName">ldesc</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">costcentre</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">uniqueno</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">empname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">refwo</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">activity</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">StartDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">finishdate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">allowtype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">worklocation</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">Approved</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">months</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">dates</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">timefrom</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">timeto</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">hours</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">ErrorReport</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Reversal</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">ErrorMessage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">Recordid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">enterby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">n_authorisedby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">Capture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">today</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">ldesc</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<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 laborcraftrate.CONTROLACCOUNT costcentre, "
+ "lb.laborcode uniqueno, "
+ "p.displayname empname,labtrans.refwo, "
+ "labtrans.transtype activity, "
+ "labtrans.startdate StartDate, "
+ "labtrans.finishdate, "
+ "labtrans.n_overtimetype allowtype, lb.worklocation, "
+ "case when labtrans.genapprservreceipt = 1 then 'Y' else 'N' end Approved, "
+ "TO_CHAR (labtrans.startdate, 'yyyymm') months, TO_CHAR (labtrans.startdate, 'dd/mm/yyyy') dates, "
+ "TO_CHAR (labtrans.starttime, 'hh24:mi:ss') timefrom, TO_CHAR (labtrans.finishtime, 'hh24:mi:ss') timeto, "
+ "labtrans.regularhrs hours, labtrans.N_ERRORCODE ErrorReport, "
+ "case when labtrans.REGULARHRS < 0 then 'Y' else 'N' end Reversal, "
+ "labtrans.N_ERRORDESC ErrorMessage, "
+ "labtrans.N_RECORDID Recordid, "
+ "labtrans.enterby, "
+ "labtrans.n_authorisedby, "
+ "labtrans.n_capindnorrev Capture, "
+ " (select sysdate from dual)today, "
+ "l.description ldesc "
+ "FROM labor lb,person p,labtrans ,LABORCRAFTRATE, locations l "
+ "WHERE labtrans.laborcode = lb.laborcode "
+ "and l.location = lB.worklocation "
+ "AND (labtrans.n_overtimetype IS NOT NULL) "
+ "AND p.personid = lb.personid and lb.LABORCODE = laborcraftrate.LABORCODE "
+ "and laborcraftrate.controlaccount like (SELECT CASE WHEN '" + params["CostCentre"] + "' = '*' THEN '%' WHEN '" + params["CostCentre"] + "' is null THEN '%' "
+ "WHEN '" + params["CostCentre"] + "' = '%' THEN '%' else '" + params["CostCentre"] + "' end from dual) "
+ "and laborcraftrate.DEFAULTCRAFT = 1 "
+ "and labtrans.STARTDATE >= to_date('" + params["startdate"]+"'" + ",'yy-mm-dd') "
+ "and labtrans.STARTDATE < to_date('" + params["enddate"]+"'" + ",'yy-mm-dd')+1 and "
+ MXReportSqlFormat.createParamWhereClause("lb.worksite", params["siteid"])
+ "ORDER BY lb.laborcode,labtrans.startdate, labtrans.starttime "
;
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["costcentre"] = maximoDataSet.getString("costcentre");
row["uniqueno"] = maximoDataSet.getString("uniqueno");
row["empname"] = maximoDataSet.getString("empname");
row["refwo"] = maximoDataSet.getString("refwo");
row["activity"] = maximoDataSet.getString("activity");
row["StartDate"] = maximoDataSet.getString("StartDate");
row["finishdate"] = maximoDataSet.getString("finishdate");
row["allowtype"] = maximoDataSet.getString("allowtype");
row["worklocation"] = maximoDataSet.getString("worklocation");
row["Approved"] = maximoDataSet.getString("Approved");
row["months"] = maximoDataSet.getString("months");
row["dates"] = maximoDataSet.getString("dates");
row["timefrom"] = maximoDataSet.getString("timefrom");
row["timeto"] = maximoDataSet.getString("timeto");
row["hours"] = maximoDataSet.getString("hours");
row["ErrorReport"] = maximoDataSet.getString("ErrorReport");
row["Reversal"] = maximoDataSet.getString("Reversal");
row["ErrorMessage"] = maximoDataSet.getString("ErrorMessage");
row["Recordid"] = maximoDataSet.getString("Recordid");
row["enterby"] = maximoDataSet.getString("enterby");
row["n_authorisedby"] = maximoDataSet.getString("n_authorisedby");
row["Capture"] = maximoDataSet.getString("Capture");
row["today"] = maximoDataSet.getString("today");
row["ldesc"] = maximoDataSet.getString("ldesc");
return (true);]]></method>
</script-data-set>
<script-data-set name="dataSet2" id="1118">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">costcentre</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">uniqueno</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">empname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">allowtype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">months</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">dates</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">timefrom</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">timeto</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ErrorReport</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ErrorMessage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">Recordid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">worklocation</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">StartDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Capture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">enterby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">n_authorisedby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">n_approvalind</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">costcentre</property>
</structure>
<structure>
<property name="columnName">uniqueno</property>
</structure>
<structure>
<property name="columnName">empname</property>
</structure>
<structure>
<property name="columnName">allowtype</property>
</structure>
<structure>
<property name="columnName">description</property>
</structure>
<structure>
<property name="columnName">months</property>
</structure>
<structure>
<property name="columnName">dates</property>
</structure>
<structure>
<property name="columnName">timefrom</property>
</structure>
<structure>
<property name="columnName">timeto</property>
</structure>
<structure>
<property name="columnName">ErrorReport</property>
</structure>
<structure>
<property name="columnName">ErrorMessage</property>
</structure>
<structure>
<property name="columnName">Recordid</property>
</structure>
<structure>
<property name="columnName">worklocation</property>
</structure>
<structure>
<property name="columnName">StartDate</property>
</structure>
<structure>
<property name="columnName">Capture</property>
</structure>
<structure>
<property name="columnName">enterby</property>
</structure>
<structure>
<property name="columnName">n_authorisedby</property>
</structure>
<structure>
<property name="columnName">n_approvalind</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">costcentre</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">uniqueno</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">empname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">allowtype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">months</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">dates</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">timefrom</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">timeto</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ErrorReport</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ErrorMessage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">Recordid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">worklocation</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">StartDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Capture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">enterby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">n_authorisedby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">n_approvalind</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<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 laborcraftrate.CONTROLACCOUNT costcentre, "
+ "lb.laborcode uniqueno, p.displayname empname, "
+ "a.n_allowancecode allowtype, "
+ "v.DESCRIPTION description, "
+ "TO_CHAR (a.startdate, 'yyyymm') months, "
+ "TO_CHAR (a.startdate, 'dd/mm/yyyy') dates, "
+ "TO_CHAR (a.starttime, 'hh24:mi:ss') timefrom, "
+ "TO_CHAR (a.finishtime, 'hh24:mi:ss') timeto, "
+ "a.N_ERRORCODE ErrorReport, "
+ "a.N_ERRORDESC ErrorMessage, "
+ "a.N_RECORDID Recordid, "
//+ "case when a.n_allowancecode in ('4400','4420','4410','3700','3800','4000','4010','4020','41 00','4110','4120','4130','4140','4150','4160','GO','GO1','GO 2','HV','HW','HR1','HR2','HR3','KJ','KK','KL','K3','K4','K5' ,'K6')then count(a.n_allowancecode) else 0 end Allowcount, "
+ "lb.worklocation, "
+ " a.startdate StartDate, "
+ "a.n_capindnorrev Capture, "
+ " a.enterby, "
+ " a.n_authorisedby, "
+ " case when a.n_approvalind = 1 then 'Y' else 'N' end n_approvalind "
+ "FROM labor lb,person p ,LABORCRAFTRATE , attendance a ,synonymdomain v "
+ "where p.personid = lb.personid "
+ "and lb.LABORCODE = laborcraftrate.LABORCODE "
+ "and laborcraftrate.DEFAULTCRAFT = 1 "
+ "and laborcraftrate.controlaccount like (SELECT CASE WHEN '" + params["CostCentre"] + "' = '*' THEN '%' WHEN '" + params["CostCentre"] + "' is null THEN '%' "
+ "WHEN '" + params["CostCentre"] + "' = '%' THEN '%' else '" + params["CostCentre"] + "' end from dual) "
+ "and a.laborcode = lb.laborcode "
+ " and a.STARTDATE >= to_date('" + params["startdate"]+"'" + ",'yy-mm-dd') "
+ " and a.STARTDATE < to_date('" + params["enddate"]+"'" + ",'yy-mm-dd')+1 and "
+ MXReportSqlFormat.createParamWhereClause("lb.worksite", params["siteid"])
+ "AND v.VALUE(+) = a.n_allowancecode "
+ "and v.DOMAINID = 'ALLOWANCES' "
+ " ORDER BY lb.laborcode,a.startdate "
/*+ "group by laborcraftrate.CONTROLACCOUNT , "
+ "lb.laborcode , p.displayname , "
+ "a.n_allowancecode , "
+ "v.DESCRIPTION , "
+ "a.startdate, "
+ "a.starttime, "
+ "a.finishtime, "
+ "a.N_ERRORCODE , "
+ "a.N_ERRORDESC , "
+ "a.N_RECORDID "*/
;
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["costcentre"] = maximoDataSet.getString("costcentre");
row["uniqueno"] = maximoDataSet.getString("uniqueno");
row["empname"] = maximoDataSet.getString("empname");
row["allowtype"] = maximoDataSet.getString("allowtype");
row["description"] = maximoDataSet.getString("description");
row["months"] = maximoDataSet.getString("months");
row["dates"] = maximoDataSet.getString("dates");
row["timefrom"] = maximoDataSet.getString("timefrom");
row["timeto"] = maximoDataSet.getString("timeto");
row["ErrorReport"] = maximoDataSet.getString("ErrorReport");
row["ErrorMessage"] = maximoDataSet.getString("ErrorMessage");
row["Recordid"] = maximoDataSet.getString("Recordid");
//row["Allowcount"] = maximoDataSet.getString("Allowcount");
row["worklocation"] = maximoDataSet.getString("worklocation");
row["StartDate"] = maximoDataSet.getString("StartDate");
row["Capture"] = maximoDataSet.getString("Capture");
row["enterby"] = maximoDataSet.getString("enterby");
row["n_authorisedby"] = maximoDataSet.getString("n_authorisedby");
row["n_approvalind"] = maximoDataSet.getString("n_approvalind");
return (true);]]></method>
</script-data-set>
</data-sets>
<styles>
<style name="crosstab" id="341">
<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-cell" id="342">
<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="maximoLandscape" id="47" extends="MaximoSystemLibrary.maximoLandscape">
<property name="type">custom</property>
<property name="height">10in</property>
<property name="width">19in</property>
<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="340" name="NewImage1" id="340">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr">true</expression>
</structure>
</list-property>
</ref-entry>
<ref-entry baseId="309" id="309"/>
<ref-entry baseId="310" name="NewImage" id="310">
<property name="source">file</property>
<expression name="uri">"eskom.gif"</expression>
<property name="height">10mm</property>
<property name="width">35mm</property>
</ref-entry>
<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>
<property name="headerHeight">0.5in</property&g
|
|
|
Re: Export Birt report in Excel [message #649563 is a reply to message #649505] |
Wed, 19 January 2011 12:42   |
Eclipse User |
|
|
|
Nolo
for some reason the whole report did not come through. If you have
multiple tables you need to use Richards approach. The visibility
expression is available in the properties below the report canvas when
you select the table.
Jason
On 1/19/2011 9:02 AM, Nolo wrote:
> This is it. Please help
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.3.2.r232_20090202 Build <2.3.2.v20090218-0730></property>
> <property name="units">in</property>
> <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.</property>
> <html-property name="description">This template will create a report
> having a single header with multiple rows of data.</html-property>
> <method name="initialize"><
> ![CDATA[importPackage(Packages.com.ibm.tivoli.maximo.report. script);
>
> mxReportScriptContext =
> MXReportScriptContext.initialize(reportContext);]]></method >
> <method name="afterFactory"><![CDATA[MXReportScriptContext.close();]]
> ></method>
> <property name="theme">MaximoSystemLibrary.maximoTheme</property>
> <text-property name="displayName">Tivoli Maximo List
> Template</text-property>
> <property name="bidiLayoutOrientation">ltr</property>
> <list-property name="libraries">
> <structure>
> <property name="fileName">MaximoSystemLibrary.rptlibrary</property>
> <property name="namespace">MaximoSystemLibrary</property>
> </structure>
> </list-property>
> <parameters>
> <scalar-parameter name="where" id="25">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">1=1</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="appname" id="200">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="paramdelimiter" id="202">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="paramstring" id="201">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="startdate" id="504">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">10-11-01</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="enddate" id="505">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">11-01-07</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="siteid" id="506">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">=CENTRAL</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="CostCentre" id="507">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">561401</property>
> <property name="distinct">true</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="dataSet1" id="415">
> <list-property name="resultSetHints">
> <structure>
> <property name="position">1</property>
> <property name="name">costcentre</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">uniqueno</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">empname</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">refwo</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">activity</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">StartDate</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">finishdate</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">allowtype</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">worklocation</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">Approved</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">months</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">dates</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">timefrom</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">timeto</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">hours</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">ErrorReport</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">Reversal</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">ErrorMessage</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">Recordid</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">20</property>
> <property name="name">enterby</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">21</property>
> <property name="name">n_authorisedby</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">22</property>
> <property name="name">Capture</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">23</property>
> <property name="name">today</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">24</property>
> <property name="name">ldesc</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">costcentre</property>
> </structure>
> <structure>
> <property name="columnName">uniqueno</property>
> </structure>
> <structure>
> <property name="columnName">empname</property>
> </structure>
> <structure>
> <property name="columnName">refwo</property>
> </structure>
> <structure>
> <property name="columnName">activity</property>
> </structure>
> <structure>
> <property name="columnName">StartDate</property>
> </structure>
> <structure>
> <property name="columnName">finishdate</property>
> </structure>
> <structure>
> <property name="columnName">allowtype</property>
> </structure>
> <structure>
> <property name="columnName">worklocation</property>
> </structure>
> <structure>
> <property name="columnName">Approved</property>
> </structure>
> <structure>
> <property name="columnName">months</property>
> </structure>
> <structure>
> <property name="columnName">dates</property>
> </structure>
> <structure>
> <property name="columnName">timefrom</property>
> </structure>
> <structure>
> <property name="columnName">timeto</property>
> </structure>
> <structure>
> <property name="columnName">hours</property>
> </structure>
> <structure>
> <property name="columnName">ErrorReport</property>
> </structure>
> <structure>
> <property name="columnName">Reversal</property>
> </structure>
> <structure>
> <property name="columnName">ErrorMessage</property>
> </structure>
> <structure>
> <property name="columnName">Recordid</property>
> </structure>
> <structure>
> <property name="columnName">enterby</property>
> </structure>
> <structure>
> <property name="columnName">n_authorisedby</property>
> </structure>
> <structure>
> <property name="columnName">Capture</property>
> </structure>
> <structure>
> <property name="columnName">today</property>
> </structure>
> <structure>
> <property name="columnName">ldesc</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">costcentre</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">uniqueno</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">empname</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">refwo</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">activity</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">StartDate</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">finishdate</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">allowtype</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">worklocation</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">Approved</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">months</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">dates</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">timefrom</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">timeto</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">hours</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">ErrorReport</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">Reversal</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">ErrorMessage</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">Recordid</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">20</property>
> <property name="name">enterby</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">21</property>
> <property name="name">n_authorisedby</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">22</property>
> <property name="name">Capture</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">23</property>
> <property name="name">today</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">24</property>
> <property name="name">ldesc</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <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 laborcraftrate.CONTROLACCOUNT costcentre, "
> + "lb.laborcode uniqueno, "
> + "p.displayname empname,labtrans.refwo, "
> + "labtrans.transtype activity, "
> + "labtrans.startdate StartDate, "
> + "labtrans.finishdate, "
> + "labtrans.n_overtimetype allowtype, lb.worklocation, "
> + "case when labtrans.genapprservreceipt = 1 then 'Y' else 'N' end
> Approved, "
> + "TO_CHAR (labtrans.startdate, 'yyyymm') months, TO_CHAR
> (labtrans.startdate, 'dd/mm/yyyy') dates, "
> + "TO_CHAR (labtrans.starttime, 'hh24:mi:ss') timefrom, TO_CHAR
> (labtrans.finishtime, 'hh24:mi:ss') timeto, "
> + "labtrans.regularhrs hours, labtrans.N_ERRORCODE ErrorReport, "
> + "case when labtrans.REGULARHRS < 0 then 'Y' else 'N' end Reversal, "
> + "labtrans.N_ERRORDESC ErrorMessage, "
> + "labtrans.N_RECORDID Recordid, "
> + "labtrans.enterby, "
> + "labtrans.n_authorisedby, "
> + "labtrans.n_capindnorrev Capture, "
> + " (select sysdate from dual)today, "
> + "l.description ldesc "
> + "FROM labor lb,person p,labtrans ,LABORCRAFTRATE, locations l "
> + "WHERE labtrans.laborcode = lb.laborcode "
> + "and l.location = lB.worklocation "
> + "AND (labtrans.n_overtimetype IS NOT NULL) "
> + "AND p.personid = lb.personid and lb.LABORCODE =
> laborcraftrate.LABORCODE "
> + "and laborcraftrate.controlaccount like (SELECT CASE WHEN '" +
> params["CostCentre"] + "' = '*' THEN '%' WHEN '" + params["CostCentre"]
> + "' is null THEN '%' "
> + "WHEN '" + params["CostCentre"] + "' = '%' THEN '%' else '" +
> params["CostCentre"] + "' end from dual) "
> + "and laborcraftrate.DEFAULTCRAFT = 1 "
> + "and labtrans.STARTDATE >= to_date('" + params["startdate"]+"'" +
> ",'yy-mm-dd') "
> + "and labtrans.STARTDATE < to_date('" + params["enddate"]+"'" +
> ",'yy-mm-dd')+1 and "
> + MXReportSqlFormat.createParamWhereClause("lb.worksite",
> params["siteid"]) + "ORDER BY lb.laborcode,labtrans.startdate,
> labtrans.starttime "
> ;
>
> 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["costcentre"] = maximoDataSet.getString("costcentre");
> row["uniqueno"] = maximoDataSet.getString("uniqueno");
> row["empname"] = maximoDataSet.getString("empname");
> row["refwo"] = maximoDataSet.getString("refwo");
> row["activity"] = maximoDataSet.getString("activity");
> row["StartDate"] = maximoDataSet.getString("StartDate");
> row["finishdate"] = maximoDataSet.getString("finishdate");
> row["allowtype"] = maximoDataSet.getString("allowtype");
> row["worklocation"] = maximoDataSet.getString("worklocation");
> row["Approved"] = maximoDataSet.getString("Approved");
> row["months"] = maximoDataSet.getString("months");
> row["dates"] = maximoDataSet.getString("dates");
> row["timefrom"] = maximoDataSet.getString("timefrom");
> row["timeto"] = maximoDataSet.getString("timeto");
> row["hours"] = maximoDataSet.getString("hours");
> row["ErrorReport"] = maximoDataSet.getString("ErrorReport");
> row["Reversal"] = maximoDataSet.getString("Reversal");
> row["ErrorMessage"] = maximoDataSet.getString("ErrorMessage");
> row["Recordid"] = maximoDataSet.getString("Recordid");
> row["enterby"] = maximoDataSet.getString("enterby");
> row["n_authorisedby"] = maximoDataSet.getString("n_authorisedby");
> row["Capture"] = maximoDataSet.getString("Capture");
> row["today"] = maximoDataSet.getString("today");
> row["ldesc"] = maximoDataSet.getString("ldesc");
>
>
>
>
>
>
> return (true);]]></method>
> </script-data-set>
> <script-data-set name="dataSet2" id="1118">
> <list-property name="resultSetHints">
> <structure>
> <property name="position">1</property>
> <property name="name">costcentre</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">uniqueno</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">empname</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">allowtype</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">description</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">months</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">dates</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">timefrom</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">timeto</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">ErrorReport</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">ErrorMessage</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">Recordid</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">worklocation</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">StartDate</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">Capture</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">enterby</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">n_authorisedby</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">n_approvalind</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">costcentre</property>
> </structure>
> <structure>
> <property name="columnName">uniqueno</property>
> </structure>
> <structure>
> <property name="columnName">empname</property>
> </structure>
> <structure>
> <property name="columnName">allowtype</property>
> </structure>
> <structure>
> <property name="columnName">description</property>
> </structure>
> <structure>
> <property name="columnName">months</property>
> </structure>
> <structure>
> <property name="columnName">dates</property>
> </structure>
> <structure>
> <property name="columnName">timefrom</property>
> </structure>
> <structure>
> <property name="columnName">timeto</property>
> </structure>
> <structure>
> <property name="columnName">ErrorReport</property>
> </structure>
> <structure>
> <property name="columnName">ErrorMessage</property>
> </structure>
> <structure>
> <property name="columnName">Recordid</property>
> </structure>
> <structure>
> <property name="columnName">worklocation</property>
> </structure>
> <structure>
> <property name="columnName">StartDate</property>
> </structure>
> <structure>
> <property name="columnName">Capture</property>
> </structure>
> <structure>
> <property name="columnName">enterby</property>
> </structure>
> <structure>
> <property name="columnName">n_authorisedby</property>
> </structure>
> <structure>
> <property name="columnName">n_approvalind</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">costcentre</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">uniqueno</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">empname</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">allowtype</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">description</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">months</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">dates</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">timefrom</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">timeto</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">ErrorReport</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">ErrorMessage</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">Recordid</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">worklocation</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">StartDate</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">Capture</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">enterby</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">n_authorisedby</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">n_approvalind</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <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 laborcraftrate.CONTROLACCOUNT costcentre, "
> + "lb.laborcode uniqueno, p.displayname empname, "
> + "a.n_allowancecode allowtype, "
> + "v.DESCRIPTION description, "
> + "TO_CHAR (a.startdate, 'yyyymm') months, "
> + "TO_CHAR (a.startdate, 'dd/mm/yyyy') dates, "
> + "TO_CHAR (a.starttime, 'hh24:mi:ss') timefrom, "
> + "TO_CHAR (a.finishtime, 'hh24:mi:ss') timeto, "
> + "a.N_ERRORCODE ErrorReport, "
> + "a.N_ERRORDESC ErrorMessage, "
> + "a.N_RECORDID Recordid, "
> //+ "case when a.n_allowancecode in
> ('4400','4420','4410','3700','3800','4000','4010','4020','41
> 00','4110','4120','4130','4140','4150','4160','GO','GO1','GO
> 2','HV','HW','HR1','HR2','HR3','KJ','KK','KL','K3','K4','K5' ,'K6')then
> count(a.n_allowancecode) else 0 end Allowcount, "
> + "lb.worklocation, "
> + " a.startdate StartDate, "
> + "a.n_capindnorrev Capture, "
> + " a.enterby, "
> + " a.n_authorisedby, "
> + " case when a.n_approvalind = 1 then 'Y' else 'N' end n_approvalind "
> + "FROM labor lb,person p ,LABORCRAFTRATE , attendance a ,synonymdomain v "
> + "where p.personid = lb.personid "
> + "and lb.LABORCODE = laborcraftrate.LABORCODE "
> + "and laborcraftrate.DEFAULTCRAFT = 1 "
> + "and laborcraftrate.controlaccount like (SELECT CASE WHEN '" +
> params["CostCentre"] + "' = '*' THEN '%' WHEN '" + params["CostCentre"]
> + "' is null THEN '%' "
> + "WHEN '" + params["CostCentre"] + "' = '%' THEN '%' else '" +
> params["CostCentre"] + "' end from dual) "
> + "and a.laborcode = lb.laborcode "
> + " and a.STARTDATE >= to_date('" + params["startdate"]+"'" +
> ",'yy-mm-dd') "
> + " and a.STARTDATE < to_date('" + params["enddate"]+"'" +
> ",'yy-mm-dd')+1 and "
> + MXReportSqlFormat.createParamWhereClause("lb.worksite",
> params["siteid"]) + "AND v.VALUE(+) = a.n_allowancecode "
> + "and v.DOMAINID = 'ALLOWANCES' "
> + " ORDER BY lb.laborcode,a.startdate "
> /*+ "group by laborcraftrate.CONTROLACCOUNT , "
> + "lb.laborcode , p.displayname , "
> + "a.n_allowancecode , "
> + "v.DESCRIPTION , "
> + "a.startdate, "
> + "a.starttime, "
> + "a.finishtime, "
> + "a.N_ERRORCODE , " + "a.N_ERRORDESC , "
> + "a.N_RECORDID "*/
>
> ;
>
> 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["costcentre"] = maximoDataSet.getString("costcentre");
> row["uniqueno"] = maximoDataSet.getString("uniqueno");
> row["empname"] = maximoDataSet.getString("empname");
> row["allowtype"] = maximoDataSet.getString("allowtype");
> row["description"] = maximoDataSet.getString("description");
> row["months"] = maximoDataSet.getString("months");
> row["dates"] = maximoDataSet.getString("dates");
> row["timefrom"] = maximoDataSet.getString("timefrom");
> row["timeto"] = maximoDataSet.getString("timeto");
> row["ErrorReport"] = maximoDataSet.getString("ErrorReport");
> row["ErrorMessage"] = maximoDataSet.getString("ErrorMessage");
> row["Recordid"] = maximoDataSet.getString("Recordid");
> //row["Allowcount"] = maximoDataSet.getString("Allowcount");
> row["worklocation"] = maximoDataSet.getString("worklocation");
> row["StartDate"] = maximoDataSet.getString("StartDate");
> row["Capture"] = maximoDataSet.getString("Capture");
> row["enterby"] = maximoDataSet.getString("enterby");
> row["n_authorisedby"] = maximoDataSet.getString("n_authorisedby");
> row["n_approvalind"] = maximoDataSet.getString("n_approvalind");
>
>
> return (true);]]></method>
> </script-data-set>
> </data-sets>
> <styles>
> <style name="crosstab" id="341">
> <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-cell" id="342">
> <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="maximoLandscape" id="47"
> extends="MaximoSystemLibrary.maximoLandscape">
> <property name="type">custom</property>
> <property name="height">10in</property>
> <property name="width">19in</property>
> <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="340" name="NewImage1" id="340">
> <list-property name="visibility">
> <structure>
> <property name="format">all</property>
> <expression name="valueExpr">true</expression>
> </structure>
> </list-property>
> </ref-entry>
> <ref-entry baseId="309" id="309"/>
> <ref-entry baseId="310" name="NewImage" id="310">
> <property name="source">file</property>
> <expression name="uri">"eskom.gif"</expression>
> <property name="height">10mm</property>
> <property name="width">35mm</property>
> </ref-entry>
> <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>
> <property name="headerHeight">0.5in</property&g
|
|
| | | |
(no subject) [message #727568 is a reply to message #649816] |
Wed, 21 September 2011 09:40   |
Eclipse User |
|
|
|
Hi Jason,
I have the same problem , i have sent my report and sample output to your mail id.
please advise.
Same is attached here too.
Thanks,
Vijay
begin 644 SV_Summary_TN_Range.rptdesign
M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB551&+3@B/SX*/')E<&]R
M="!X;6QN<STB:'1T<#HO+W=W=RYE8VQI<'-E+F]R9R]B:7)T+S(P,#4O9&5S
M:6=N(B!V97)S:6]N/2(S+C(N,C$B(&ED/2(Q(CX*("`@(#QP<F]P97)T>2!N
M86UE/2)C<F5A=&5D0GDB/D5C;&EP<V4@0DE25"!$97-I9VYE<B!697)S:6]N
M(#(N-2XR+G8R,#$P,#(P."!"=6EL9"`F;'0[,BXU+C(N=C(P,3`P,C$P+3`V
M,S`^/"]P<F]P97)T>3X*("`@(#QT97AT+7!R;W!E<G1Y(&YA;64](G1I=&QE
M(CY3=6)S8W)I<'1I;VX@5F5R<VEO;B!3=6UM87)Y(%)E<&]R="`H0GD@5$X@
M4F%N9V4L(%-T871U<R!A;F0@4&]R="!4>7!E*3PO=&5X="UP<F]P97)T>3X*
M("`@(#QP<F]P97)T>2!N86UE/2)U;FET<R(^:6X\+W!R;W!E<G1Y/@H@("`@
M/&UE=&AO9"!N86UE/2)I;FET:6%L:7IE(CX\(5M#1$%405MI;7!O<G1086-K
M86=E*%!A8VMA9V5S+FIA=F$N;&%N9RD["@I":7)T3&]G9V5R(#T@;W)G+F%P
M86-H92YL;V<T:BY,;V=G97(N9V5T3&]G9V5R*")"25)4(BD["D)I<G1,;V=G
M97(N9&5B=6<@*")35B!297!O<G0@8GD@5$X@4F%N9V4Z($EN:71I86QI>F4B
M*3L*"F5R<F]R8V]D92`](#`["@HO+U1H:7,@;&]G:6,@:&%S('1O(&)E(&ME
M<'0@:6X@86QL(')E<&]R=',@9F]R(&UO<F4@9G5N8W1I;VYA;&ET>2!35$%2
M5"`M+2T*=F%R('-/=71P=70@/2`B(CL*<T]U='!U=#TB(CL*=F%R('!A<F%M
M971E<D%R<F%Y(#T@<F5P;W)T0V]N=&5X="YG971$97-I9VY(86YD;&4H*2YG
M971!;&Q087)A;65T97)S*"D[.PIV87(@<&%R86UA=&5R0V]U;G0@/2!P87)A
M;65T97)!<G)A>2YS:7IE*"D["@IF;W(H('9A<B!I(#T@,#L@:2`\('!A<F%M
M871E<D-O=6YT.R!I*RL@*0I["@EV87(@<U!A<DYA;64@/2!P87)A;65T97)!
M<G)A>2YG970H:2DN9V5T1G5L;$YA;64H*3L)"@EI9B@@<&%R86UE=&5R07)R
M87DN9V5T*&DI+F=E=$-L87-S*"DN=&]3=')I;F<H*2`]/2`B8VQA<W,@;W)G
M+F5C;&EP<V4N8FER="YR97!O<G0N;6]D96PN87!I+E-C86QA<E!A<F%M971E
M<DAA;F1L92(I>PH)"79A<B!S4&%R5F%L(#T@<F5P;W)T0V]N=&5X="YG9710
M87)A;65T97)686QU92@@<U!A<DYA;64@*3L@"@D)<U!A<DYA;64@/2!S4&%R
M3F%M92YR97!L86-E*"(@(BPB*R(I.PH)"6EF*"!":7)T0V]M<"YE<75A;%1O
M*'-087).86UE+")?7W)E<&]R="(I*2!["@D)"2!S3W5T<'5T(#T@<T]U='!U
M="`K("(_(B`K('-087).86UE("L@(CTB("L@<U!A<E9A;#L*"0E]"@D)96QS
M92!I9B@@0FER=$-O;7`N97%U86Q4;RAS4&%R3F%M92PB;6%X7W)O=VYU;2(I
M('Q\("!":7)T0V]M<"YE<75A;%1O*'-087).86UE+")M:6Y?<F]W;G5M(BDI
M>PH)"0D@+R\@<VMI<"!M:6Y?<F]W;G5M(&%N9"!M87A?<F]W;B`Z('1H97-E
M('=I;&P@8F4@861D960@8GD@<V-R:7!T"@D)"2!":7)T3&]G9V5R+F1E8G5G
M("@B4U8@4F5P;W)T(&)Y(%1.(%)A;F=E.B!);FET:6%L('9A;'5E("T@(B`K
M('-087).86UE("L@(CTB("L@<U!A<E9A;"D["@D)?0H)"65L<V4@:68H($)I
M<G1#;VUP+F5Q=6%L5&\H<U!A<DYA;64L(E-67U-405154R(I*0E["@D)"4)I
M<G1,;V=G97(N9&5B=6<@*")35B!297!O<G0@8GD@5$X@4F%N9V4Z($EN:71I
M86P@=F%L=64@+2`B("L@<U!A<DYA;64@*R`B/2(@*R!S4&%R5F%L*3L*"0D)
M"@D)"79A<B!S=&%T=7-686P@/2`B(CL*"0D)+R\@4U8@4W1A='5S(&-R:71E
M<FEA"@D)"79A<B!P87)M8V]U;G0@/2!P87)A;7-;(E-67U-405154R)=+G9A
M;'5E+FQE;F=T:#L*"0D)9F]R("@@=F%R(&H],#L@:B`\('!A<FUC;W5N=#L@
M:BLK("E["@D)"0EI9B`H('!A<F%M<ULB4U9?4U1!5%53(ETN=F%L=65;:ET@
M(3T@+3$@*2!["@D)"0D):68H(&H@/3T@,"`I>PH)"0D)"0ES=&%T=7-686P@
M*ST@<&%R86US6R)35E]35$%455,B72YV86QU95MJ73L*"0D)"0E](`H)"0D)
M"65L<V4@>PH)"0D)"0ES=&%T=7-686P@/2!S=&%T=7-686P@*R`B+"(@*R!P
M87)A;7-;(E-67U-405154R)=+G9A;'5E6VI=.R`*"0D)"0E]"@D)"0E]"@D)
M"0EE;'-E('L*"0D)"0ES=&%T=7-686P@/2`B+3$B.PH)"0D)"6)R96%K.PH)
M"0D)?0H)"0E]"@D)"6EF("@@<W1A='5S5F%L("$]("(B("D@>PH)"0D)<T]U
M='!U="`]('-/=71P=70@*R`B)F%M<#LB("L@<U!A<DYA;64@*R`B/2(@*R!S
M=&%T=7-686P["@D)"7T*"0E]"@D)96QS92!["@D)"6EF("@@<U!A<E9A;"`A
M/2`B(B`I('L*"0D)"7-/=71P=70@/2!S3W5T<'5T("L@(B9A;7`[(B`K('-0
M87).86UE("L@(CTB("L@<U!A<E9A;#L@"@D)"7T*"0E]"@E]"GT*"G)E<&]R
M=$-O;G1E>'0N<V5T1VQO8F%L5F%R:6%B;&4H(E]P87)A;4QI<W0B+'-/=71P
M=70I.PI":7)T3&]G9V5R+FEN9F\@*")35B!297!O<G0@8GD@5$X@4F%N9V4Z
M(%!A<F%M971E<B!,:7-T("T@(B`K('-/=71P=70I.PH*+R\@5&AI<R!L;V=I
M8R!H87,@=&\@8F4@:V5P="!I;B!A;&P@<F5P;W)T<R!F;W(@;6]R92!F=6YC
M=&EO;F%L:71Y("TM+2!%3D1=73X\+VUE=&AO9#X*("`@(#QM971H;V0@;F%M
M93TB8F5F;W)E1F%C=&]R>2(^/"%;0T1!5$%;:6UP;W)T4&%C:V%G92A086-K
M86=E<RYJ879A+FQA;F<I.PH*0FER=$QO9V=E<BYD96)U9R`H(E-6(%)E<&]R
M="!B>2!43B!286YG93H@8F5F;W)E1F%C=&]R>2(I.PH*<')E=CT@<&%R86US
M6R)M:6Y?<F]W;G5M(ETN=F%L=64["FYE>'0]('!A<F%M<ULB;6%X7W)O=VYU
M;2)=+G9A;'5E.PH*=F%R('-T<E1N4F%N9V4@/2!P87)A;7-;(E1.7U)!3D=%
M(ETN=F%L=64["G9A<B!L96X@/2!S=')4;E)A;F=E+FQE;F=T:"@I.PH*=F%R
M($5R<F]R37-G(#T@(E9A;&ED871I;VX@9F]R(&EN<'5T('!A<F%M=&5R(%1.
M7U)!3D=%(#T@(B`K('-T<E1N4F%N9V4@*R`B("A,14Y'5$@@/2`B("L@;&5N
M("L@(BD@(CL*"FEF("@@;&5N(#P](#$P("D@>PH):68@*"!L96X@/"`S("D@
M>PH)"45R<F]R37-G("L](")&86EL960N($%T(&QE87-T(&$@,R!D:6=I="!.
M4$$@:7,@<F5Q=6ER960N(CL*"0EE<G)O<F-O9&4@/2`Q,#`Q.PH)?0H*"6EF
M("@@;&5N(#P](#`@*2!["@D)17)R;W)-<V<@*ST@(D9A:6QE9"X@5$X@4F%N
M9V4@:7,@82!R97%U:7)E9"!I;G!U="!P87)A;65T97(N(CL*"0EE<G)O<F-O
M9&4@/2`Q,#`T.PH)?0H)"@DO+R!686QI9&%T:6]N(&9O<B!N=6UE<FEC('9A
M;'5E"@EI9B`H(&5R<F]R8V]D92`]/2`P("D@>PH)"69O<B`H:2`](#`[(&D@
M/"!L96X[(&DK*RD*"0E["@D)"7-T<D-H87(@/2!S=')4;E)A;F=E+F-H87)!
M="AI*3L*"0D):68@*"!S=')#:&%R(#P@-#@@?'P@<W1R0VAA<B`^(#4W("D@
M>PH)"0D)17)R;W)-<V<@*ST@(D9A:6QE9"X@5$X@4F%N9V4@<&%R86UE=&5R
M(&-O;G1A:6YS(&YO;BUN=6UE<FEC('9A;'5E+B(["@D)"0EE<G)O<F-O9&4@
M/2`Q,#`R.PH)"0D)8G)E86L["@D)"7T*"0E]"@E]"GT*96QS92!["@EI9B`H
M(&QE;B`A/2`Q-2`I('L*"0E%<G)O<DUS9R`K/2`B1F%I;&5D+B!43B!286YG
M92!S:&]U;&0@8V]N=&%I;B`Q-2!C:&%R86-T97)S("A#;W)R96-T($9O<FUA
M=#H@3E!!3EA84U-34RU34U-3*2XB.PH)"65R<F]R8V]D92`](#$P,#,["0H)
M?0H)+R]686QI9&%T:6]N(&9O<B!F;W)M870@;G!A;GAX<W-S<RUS<W-S"@EF
M;W(@*&D@/2`P.R!I(#P@;&5N.R!I*RLI"@E["@D)<W1R0VAA<B`]('-T<E1N
M4F%N9V4N8VAA<D%T*&DI.PH)"0H)"6EF("@@:2`\(#$P("D@>PH)"0EI9B`H
M('-T<D-H87(@/"`T."!\?"!S=')#:&%R(#X@-3<@*2!["@D)"0E%<G)O<DUS
M9R`K/2`B1F%I;&5D+B!43B!286YG92!P87)A;65T97(@8V]N=&%I;G,@;F]N
M+6YU;65R:6,@=F%L=64N(CL*"0D)"65R<F]R8V]D92`](#$P,#(["@D)"0EB
M<F5A:SL*"0D)?0H)"7T*"0EE;'-E(&EF("@@:2`]/2`Q,"`I('L*"0D):68@
M*"!S=')#:&%R("$](#0U("D@>R`O+R`T-2!I;F1I8V%T97,@)RTG"@D)"0E%
M<G)O<DUS9R`K/2`B1F%I;&5D+B!43B!286YG92!P<F]V:61E9"!I<R!I;G9A
M;&ED("A#;W)R96-T($9O<FUA=#H@3E!!3EA86%A86"U965E9*2XB.PH)"0D)
M97)R;W)C;V1E(#T@,3`P,SL*"0D)?0H)"7T*"0EE;'-E(&EF("@@:2`^(#$P
M("9A;7`[)F%M<#L@:2`\(#$U("D@>PH)"0EI9B`H('-T<D-H87(@/"`T."!\
M?"!S=')#:&%R(#X@-3<@*2!["@D)"0E%<G)O<DUS9R`K/2`B1F%I;&5D+B!4
M3B!286YG92!P87)A;65T97(@8V]N=&%I;G,@;F]N+6YU;65R:6,@=F%L=64N
M(CL*"0D)"65R<F]R8V]D92`](#$P,#(["@D)"0EB<F5A:SL*"0D)?0H)"7T*
M"7T*?0H*<F5P;W)T0V]N=&5X="YS971';&]B86Q687)I86)L92@B17)R;W)#
M;V1E(BQE<G)O<F-O9&4I.PII9B@@97)R;W)C;V1E("$](#`@*2!["@ER97!O
M<G1#;VYT97AT+F=E=$1E<VEG;DAA;F1L92@I+F9I;F1%;&5M96YT*")35E)E
M<&]R=$)Y5$XB*2YD<F]P*"D["GT*96QS92!["@E%<G)O<DUS9R`K/2`B4&%S
M<V5D+B(["GT*"D)I<G1,;V=G97(N:6YF;R`H(E-6(%)E<&]R="!B>2!43B!2
M86YG93H@(B`K($5R<F]R37-G*3M=73X\+VUE=&AO9#X*("`@(#QP<F]P97)T
M>2!N86UE/2)T:&5M92(^8V]M;6]N7V1B+D1E9F%U;'0@5&AE;64@+3$\+W!R
M;W!E<G1Y/@H@("`@/'!R;W!E<G1Y(&YA;64](FEC;VY&:6QE(CXO=&5M<&QA
M=&5S+V)L86YK7W)E<&]R="YG:68\+W!R;W!E<G1Y/@H@("`@/'!R;W!E<G1Y
M(&YA;64](FQA>6]U=%!R969E<F5N8V4B/F9I>&5D(&QA>6]U=#PO<')O<&5R
M='D^"B`@("`\<')O<&5R='D@;F%M93TB8FED:4QA>6]U=$]R:65N=&%T:6]N
M(CYL='(\+W!R;W!E<G1Y/@H@("`@/'!R;W!E<G1Y(&YA;64](FEM86=E1%!)
M(CXY-CPO<')O<&5R='D^"B`@("`\;&ES="UP<F]P97)T>2!N86UE/2)L:6)R
M87)I97,B/@H@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@(#QP<F]P
M97)T>2!N86UE/2)F:6QE3F%M92(^8V]M;6]N7V1B+G)P=&QI8G)A<GD\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%M97-P86-E
M(CYC;VUM;VY?9&(\+W!R;W!E<G1Y/@H@("`@("`@(#PO<W1R=6-T=7)E/@H@
M("`@/"]L:7-T+7!R;W!E<G1Y/@H@("`@/'!A<F%M971E<G,^"B`@("`@("`@
M/'-C86QA<BUP87)A;65T97(@;F%M93TB7U]R97!O<G0B(&ED/2(T,C`B(&5X
M=&5N9',](F-O;6UO;E]D8BY?7W)E<&]R="(O/@H@("`@("`@(#QS8V%L87(M
M<&%R86UE=&5R(&YA;64](E1.7U)!3D=%(B!I9#TB,3<Y(CX*("`@("`@("`@
M("`@/'1E>'0M<')O<&5R='D@;F%M93TB:&5L<%1E>'0B/E-I;F=L92!43B!O
M<B!A(%1.(%)A;F=E+B!.4$$@:7,@;6%N9&%T;W)Y/"]T97AT+7!R;W!E<G1Y
M/@H@("`@("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE/2)P<F]M<'1497AT
M(CY43B!286YG92`H1F]R;6%T.B!.4$%.6%A34U-3+5-34U,I/"]T97AT+7!R
M;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB=F%L=654>7!E
M(CYS=&%T:6,\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M
M93TB9&%T851Y<&4B/G-T<FEN9SPO<')O<&5R='D^"B`@("`@("`@("`@(#QP
M<F]P97)T>2!N86UE/2)D:7-T:6YC="(^=')U93PO<')O<&5R='D^"B`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)P87)A;51Y<&4B/G-I;7!L93PO<')O
M<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)C;VYT<F]L5'EP
M92(^=&5X="UB;W@\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<W1R=6-T=7)E
M(&YA;64](F9O<FUA="(^"B`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M
M93TB8V%T96=O<GDB/E5N9F]R;6%T=&5D/"]P<F]P97)T>3X*("`@("`@("`@
M("`@/"]S=')U8W1U<F4^"B`@("`@("`@/"]S8V%L87(M<&%R86UE=&5R/@H@
M("`@("`@(#QS8V%L87(M<&%R86UE=&5R(&YA;64](E-67U-405154R(@:60]
M(C$U-R(^"B`@("`@("`@("`@(#QT97AT+7!R;W!E<G1Y(&YA;64](FAE;'!4
M97AT(CY3=6)S8W)I<'1I;VX@5F5R<VEO;B!3=&%T=7,\+W1E>'0M<')O<&5R
M='D^"B`@("`@("`@("`@(#QT97AT+7!R;W!E<G1Y(&YA;64](G!R;VUP=%1E
M>'0B/E-U8G-C<FEP=&EO;B!3=&%T=7,\+W1E>'0M<')O<&5R='D^"B`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)V86QU951Y<&4B/G-T871I8SPO<')O
M<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^
M<W1R:6YG/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64]
M(F1I<W1I;F-T(CYT<G5E/"]P<F]P97)T>3X*("`@("`@("`@("`@/'-I;7!L
M92UP<F]P97)T>2UL:7-T(&YA;64](F1E9F%U;'1686QU92(^"B`@("`@("`@
M("`@("`@("`\=F%L=64@='EP93TB8V]N<W1A;G0B/BTQ/"]V86QU93X*("`@
M("`@("`@("`@/"]S:6UP;&4M<')O<&5R='DM;&ES=#X*("`@("`@("`@("`@
M/&QI<W0M<')O<&5R='D@;F%M93TB<V5L96-T:6]N3&ES="(^"B`@("`@("`@
M("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P
M97)T>2!N86UE/2)V86QU92(^+3$\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)L86)E;"(^04Q,/"]P<F]P97)T>3X*
M("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@
M/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M
M93TB=F%L=64B/C`\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP
M<F]P97)T>2!N86UE/2)L86)E;"(^0V]N9FQI8W0\+W!R;W!E<G1Y/@H@("`@
M("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\<W1R
M=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)V
M86QU92(^,3PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](FQA8F5L(CY!8W1I=F4\+W!R;W!E<G1Y/@H@("`@("`@("`@
M("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\<W1R=6-T=7)E
M/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)V86QU92(^
M,CPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](FQA8F5L(CY096YD:6YG/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@
M(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB=F%L=64B/C,\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)L
M86)E;"(^4V5N9&EN9SPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T
M<G5C='5R93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@
M("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E(CXT/"]P<F]P97)T
M>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;&%B96PB
M/D9A:6QE9#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R
M93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E(CXU/"]P<F]P97)T>3X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;&%B96PB/E!A<G1I
M86P@1F%I;'5R93PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C
M='5R93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@
M("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E(CXV/"]P<F]P97)T>3X*
M("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;&%B96PB/D1I
M<V-O;FYE8W0@4&5N9&EN9SPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\
M+W-T<G5C='5R93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@
M("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E(CXW/"]P<F]P
M97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;&%B
M96PB/D]L9#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R
M93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E(CXX/"]P<F]P97)T>3X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;&%B96PB/D-A;F-E
M;&5D/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@
M("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@
M("`\<')O<&5R='D@;F%M93TB=F%L=64B/CD\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)L86)E;"(^0V%N8V5L(%!E
M;F1I;F<\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^
M"B`@("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@
M("`@(#QP<F]P97)T>2!N86UE/2)V86QU92(^,3`\+W!R;W!E<G1Y/@H@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)L86)E;"(^56YD969I
M;F5D/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@
M("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@
M("`\<')O<&5R='D@;F%M93TB=F%L=64B/CDY/"]P<F]P97)T>3X*("`@("`@
M("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;&%B96PB/E9O:60\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@
M("`@(#PO;&ES="UP<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](G!A<F%M5'EP92(^;75L=&DM=F%L=64\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`\<')O<&5R='D@;F%M93TB8V]N=')O;%1Y<&4B/FQI<W0M8F]X/"]P
M<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FUU<W1-871C
M:"(^=')U93PO<')O<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)F:7AE9$]R9&5R(CYT<G5E/"]P<F]P97)T>3X*("`@("`@("`@("`@/'-T
M<G5C='5R92!N86UE/2)F;W)M870B/@H@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](F-A=&5G;W)Y(CY5;F9O<FUA='1E9#PO<')O<&5R='D^"B`@
M("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@(#PO<V-A;&%R+7!A<F%M
M971E<CX*("`@("`@("`\<V-A;&%R+7!A<F%M971E<B!N86UE/2)03U)47U19
M4$4B(&ED/2(Q-C$B/@H@("`@("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE
M/2)H96QP5&5X="(^5'EP92!O9B!,3E`@<&]R="`H3$E34"P@3%-04"!O<B!0
M;V]L*3PO=&5X="UP<F]P97)T>3X*("`@("`@("`@("`@/'1E>'0M<')O<&5R
M='D@;F%M93TB<')O;7!T5&5X="(^4&]R="!4>7!E/"]T97AT+7!R;W!E<G1Y
M/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB=F%L=654>7!E(CYS=&%T
M:6,\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB:7-2
M97%U:7)E9"(^=')U93PO<')O<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T
M>2!N86UE/2)D871A5'EP92(^:6YT96=E<CPO<')O<&5R='D^"B`@("`@("`@
M("`@(#QP<F]P97)T>2!N86UE/2)D:7-T:6YC="(^=')U93PO<')O<&5R='D^
M"B`@("`@("`@("`@(#QS:6UP;&4M<')O<&5R='DM;&ES="!N86UE/2)D969A
M=6QT5F%L=64B/@H@("`@("`@("`@("`@("`@/'9A;'5E('1Y<&4](F-O;G-T
M86YT(CXM,3PO=F%L=64^"B`@("`@("`@("`@(#PO<VEM<&QE+7!R;W!E<G1Y
M+6QI<W0^"B`@("`@("`@("`@(#QL:7-T+7!R;W!E<G1Y(&YA;64](G-E;&5C
M=&EO;DQI<W0B/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@
M("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB=F%L=64B/BTQ/"]P<F]P
M97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;&%B
M96PB/D%,3#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R
M93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E(CXP/"]P<F]P97)T>3X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;&%B96PB/DQ34%`\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@
M("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP
M<F]P97)T>2!N86UE/2)V86QU92(^,3PO<')O<&5R='D^"B`@("`@("`@("`@
M("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FQA8F5L(CY,25-0/"]P<F]P97)T
M>3X*("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@
M("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@
M;F%M93TB=F%L=64B/C(\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@
M(#QP<F]P97)T>2!N86UE/2)L86)E;"(^4$]/3#PO<')O<&5R='D^"B`@("`@
M("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@("`@/"]L:7-T+7!R
M;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB<&%R86U4>7!E
M(CYS:6UP;&4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M
M93TB8V]N=')O;%1Y<&4B/FQI<W0M8F]X/"]P<F]P97)T>3X*("`@("`@("`@
M("`@/'!R;W!E<G1Y(&YA;64](FUU<W1-871C:"(^=')U93PO<')O<&5R='D^
M"B`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)F:7AE9$]R9&5R(CYT<G5E
M/"]P<F]P97)T>3X*("`@("`@("`@("`@/'-T<G5C='5R92!N86UE/2)F;W)M
M870B/@H@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F-A=&5G;W)Y
M(CY5;F9O<FUA='1E9#PO<')O<&5R='D^"B`@("`@("`@("`@(#PO<W1R=6-T
M=7)E/@H@("`@("`@(#PO<V-A;&%R+7!A<F%M971E<CX*("`@("`@("`\<V-A
M;&%R+7!A<F%M971E<B!N86UE/2).15=?4U!)1"(@:60](C(P,2(^"B`@("`@
M("`@("`@(#QT97AT+7!R;W!E<G1Y(&YA;64](FAE;'!497AT(CY.97<@4V5R
M=FEC92!0<F]V:61E<B!)1#PO=&5X="UP<F]P97)T>3X*("`@("`@("`@("`@
M/'1E>'0M<')O<&5R='D@;F%M93TB<')O;7!T5&5X="(^3F5W(%-0/"]T97AT
M+7!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB=F%L=654
M>7!E(CYD>6YA;6EC/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y
M(&YA;64](FES4F5Q=6ER960B/G1R=64\+W!R;W!E<G1Y/@H@("`@("`@("`@
M("`\<')O<&5R='D@;F%M93TB9&%T85-E=$YA;64B/D137U-0241?3$E35#PO
M<')O<&5R='D^"B`@("`@("`@("`@(#QE>'!R97-S:6]N(&YA;64](G9A;'5E
M17AP<B(@='EP93TB:F%V87-C<FEP="(^9&%T85-E=%)O=ULB4U!)1")=/"]E
M>'!R97-S:6]N/@H@("`@("`@("`@("`\97AP<F5S<VEO;B!N86UE/2)L86)E
M;$5X<'(B('1Y<&4](FIA=F%S8W)I<'0B/F1A=&%39712;W=;(E-0240B73PO
M97AP<F5S<VEO;CX*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F1A=&%4
M>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@
M;F%M93TB9&ES=&EN8W0B/G1R=64\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\
M<VEM<&QE+7!R;W!E<G1Y+6QI<W0@;F%M93TB9&5F875L=%9A;'5E(CX*("`@
M("`@("`@("`@("`@(#QV86QU92!T>7!E/2)C;VYS=&%N="(^04Q,/"]V86QU
M93X*("`@("`@("`@("`@/"]S:6UP;&4M<')O<&5R='DM;&ES=#X*("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](G!A<F%M5'EP92(^<VEM<&QE/"]P<F]P
M97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F-O;G1R;VQ4>7!E
M(CYL:7-T+6)O>#PO<')O<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T>2!N
M86UE/2)M=7-T36%T8V@B/G1R=64\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\
M<')O<&5R='D@;F%M93TB9FEX961/<F1E<B(^=')U93PO<')O<&5R='D^"B`@
M("`@("`@("`@(#QS=')U8W1U<F4@;F%M93TB9F]R;6%T(CX*("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)C871E9V]R>2(^56YF;W)M871T960\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`\
M+W-C86QA<BUP87)A;65T97(^"B`@("`@("`@/'-C86QA<BUP87)A;65T97(@
M;F%M93TB3TQ$7U-0240B(&ED/2(R,#(B/@H@("`@("`@("`@("`\=&5X="UP
M<F]P97)T>2!N86UE/2)H96QP5&5X="(^3VQD(%-E<G9I8V4@4')O=FED97(@
M240\+W1E>'0M<')O<&5R='D^"B`@("`@("`@("`@(#QT97AT+7!R;W!E<G1Y
M(&YA;64](G!R;VUP=%1E>'0B/D]L9"!34#PO=&5X="UP<F]P97)T>3X*("`@
M("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E5'EP92(^9'EN86UI8SPO
M<')O<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)I<U)E<75I
M<F5D(CYT<G5E/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](F1A=&%3971.86UE(CY$4U]34$E$7TQ)4U0\+W!R;W!E<G1Y/@H@("`@
M("`@("`@("`\97AP<F5S<VEO;B!N86UE/2)V86QU945X<'(B('1Y<&4](FIA
M=F%S8W)I<'0B/F1A=&%39712;W=;(E-0240B73PO97AP<F5S<VEO;CX*("`@
M("`@("`@("`@/&5X<')E<W-I;VX@;F%M93TB;&%B96Q%>'!R(B!T>7!E/2)J
M879A<V-R:7!T(CYD871A4V5T4F]W6R)34$E$(ET\+V5X<')E<W-I;VX^"B`@
M("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^<W1R:6YG/"]P
M<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F1I<W1I;F-T
M(CYT<G5E/"]P<F]P97)T>3X*("`@("`@("`@("`@/'-I;7!L92UP<F]P97)T
M>2UL:7-T(&YA;64](F1E9F%U;'1686QU92(^"B`@("`@("`@("`@("`@("`\
M=F%L=64@='EP93TB8V]N<W1A;G0B/D%,3#PO=F%L=64^"B`@("`@("`@("`@
M(#PO<VEM<&QE+7!R;W!E<G1Y+6QI<W0^"B`@("`@("`@("`@(#QP<F]P97)T
M>2!N86UE/2)P87)A;51Y<&4B/G-I;7!L93PO<')O<&5R='D^"B`@("`@("`@
M("`@(#QP<F]P97)T>2!N86UE/2)C;VYT<F]L5'EP92(^;&ES="UB;W@\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;75S=$UA=&-H
M(CYT<G5E/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64]
M(F9I>&5D3W)D97(B/G1R=64\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<W1R
M=6-T=7)E(&YA;64](F9O<FUA="(^"B`@("`@("`@("`@("`@("`\<')O<&5R
M='D@;F%M93TB8V%T96=O<GDB/E5N9F]R;6%T=&5D/"]P<F]P97)T>3X*("`@
M("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@/"]S8V%L87(M<&%R86UE
M=&5R/@H@("`@("`@(#QS8V%L87(M<&%R86UE=&5R(&YA;64](FUI;E]R;W=N
M=6TB(&ED/2(T,C<B(&5X=&5N9',](F-O;6UO;E]D8BYM:6Y?<F]W;G5M(B\^
M"B`@("`@("`@/'-C86QA<BUP87)A;65T97(@;F%M93TB;6%X7W)O=VYU;2(@
M:60](C0R."(@97AT96YD<STB8V]M;6]N7V1B+FUA>%]R;W=N=6TB+SX*("`@
M("`@("`\<V-A;&%R+7!A<F%M971E<B!N86UE/2)33U)47T)9(B!I9#TB-#<Q
M(CX*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FAI9&1E;B(^9F%L<V4\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE/2)H
M96QP5&5X="(^4V]R="!B>2!&:65L9#PO=&5X="UP<F]P97)T>3X*("`@("`@
M("`@("`@/'1E>'0M<')O<&5R='D@;F%M93TB<')O;7!T5&5X="(^4V]R=#PO
M=&5X="UP<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G9A
M;'5E5'EP92(^<W1A=&EC/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](F1A=&%4>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`\<')O<&5R='D@;F%M93TB9&ES=&EN8W0B/G1R=64\+W!R;W!E<G1Y
M/@H@("`@("`@("`@("`\<VEM<&QE+7!R;W!E<G1Y+6QI<W0@;F%M93TB9&5F
M875L=%9A;'5E(CX*("`@("`@("`@("`@("`@(#QV86QU92!T>7!E/2)C;VYS
M=&%N="(^5$X\+W9A;'5E/@H@("`@("`@("`@("`\+W-I;7!L92UP<F]P97)T
M>2UL:7-T/@H@("`@("`@("`@("`\;&ES="UP<F]P97)T>2!N86UE/2)S96QE
M8W1I;VY,:7-T(CX*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@
M("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E(CY43CPO<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FQA
M8F5L(CY43CPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R
M93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](G9A;'5E(CY35E])1#PO<')O<&5R='D^
M"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FQA8F5L(CY3
M5BU)1#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R93X*
M("`@("`@("`@("`@/"]L:7-T+7!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O
M<&5R='D@;F%M93TB<&%R86U4>7!E(CYS:6UP;&4\+W!R;W!E<G1Y/@H@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB8V]N=')O;%1Y<&4B/FQI<W0M8F]X
M/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FUU<W1-
M871C:"(^=')U93PO<')O<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T>2!N
M86UE/2)F:7AE9$]R9&5R(CYT<G5E/"]P<F]P97)T>3X*("`@("`@("`@("`@
M/'-T<G5C='5R92!N86UE/2)F;W)M870B/@H@("`@("`@("`@("`@("`@/'!R
M;W!E<G1Y(&YA;64](F-A=&5G;W)Y(CY5;F9O<FUA='1E9#PO<')O<&5R='D^
M"B`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@(#PO<V-A;&%R+7!A
M<F%M971E<CX*("`@(#PO<&%R86UE=&5R<SX*("`@(#QD871A+7-O=7)C97,^
M"B`@("`@("`@/&]D82UD871A+7-O=7)C92!E>'1E;G-I;VY)1#TB;W)G+F5C
M;&EP<V4N8FER="YR97!O<G0N9&%T82YO9&$N:F1B8R(@;F%M93TB3$Y07T1A
M=&%3;W5R8V4B(&ED/2(T-S`B"B!E>'1E;F1S/2)C;VUM;VY?9&(N3$Y07T1A
M=&%3;W5R8V4B+SX*("`@(#PO9&%T82US;W5R8V5S/@H@("`@/&1A=&$M<V5T
M<SX*("`@("`@("`\;V1A+61A=&$M<V5T(&5X=&5N<VEO;DE$/2)O<F<N96-L
M:7!S92YB:7)T+G)E<&]R="YD871A+F]D82YJ9&)C+DID8F-396QE8W1$871A
M4V5T(B!N86UE/2)$4U]35E]354U-05)9(B!I9#TB,3`V(CX*("`@("`@("`@
M("`@/&QI<W0M<')O<&5R='D@;F%M93TB8V]L=6UN2&EN=',B/@H@("`@("`@
M("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\<')O
M<&5R='D@;F%M93TB8V]L=6UN3F%M92(^4U9?240\+W!R;W!E<G1Y/@H@("`@
M("`@("`@("`@("`@("`@(#QT97AT+7!R;W!E<G1Y(&YA;64](F1I<W!L87E.
M86UE(CY35E])1#PO=&5X="UP<F]P97)T>3X*("`@("`@("`@("`@("`@(#PO
M<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@
M("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB8V]L=6UN3F%M92(^5$X\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QT97AT+7!R;W!E<G1Y
M(&YA;64](F1I<W!L87E.86UE(CY43CPO=&5X="UP<F]P97)T>3X*("`@("`@
M("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C
M='5R93X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB8V]L
M=6UN3F%M92(^3D577T-54E)%3E1?4U!)1#PO<')O<&5R='D^"B`@("`@("`@
M("`@("`@("`@("`@/'1E>'0M<')O<&5R='D@;F%M93TB9&ES<&QA>4YA;64B
M/DY%5U]#55)214Y47U-0240\+W1E>'0M<')O<&5R='D^"B`@("`@("`@("`@
M("`@("`\+W-T<G5C='5R93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^
M"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F-O;'5M;DYA
M;64B/D],1%]34$E$/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\
M=&5X="UP<F]P97)T>2!N86UE/2)D:7-P;&%Y3F%M92(^3TQ$7U-0240\+W1E
M>'0M<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@
M("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@
M/'!R;W!E<G1Y(&YA;64](F-O;'5M;DYA;64B/DY%5U]34%]$545?1$%413PO
M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'1E>'0M<')O<&5R='D@
M;F%M93TB9&ES<&QA>4YA;64B/DY%5U]34%]$545?1$%413PO=&5X="UP<F]P
M97)T>3X*("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@
M("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R
M='D@;F%M93TB8V]L=6UN3F%M92(^3TQ$7U-07T1515]$051%/"]P<F]P97)T
M>3X*("`@("`@("`@("`@("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE/2)D
M:7-P;&%Y3F%M92(^3TQ$7U-07T1515]$051%/"]T97AT+7!R;W!E<G1Y/@H@
M("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\
M<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)C;VQU;6Y.86UE(CY30TA%1%5,141?04-4259!5$5?1$%413PO<')O<&5R
M='D^"B`@("`@("`@("`@("`@("`@("`@/'1E>'0M<')O<&5R='D@;F%M93TB
M9&ES<&QA>4YA;64B/E-#2$5$54Q%1%]!0U1)5D%415]$051%/"]T97AT+7!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@
M("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P
M97)T>2!N86UE/2)C;VQU;6Y.86UE(CY$7U-405154SPO<')O<&5R='D^"B`@
M("`@("`@("`@("`@("`@("`@/'1E>'0M<')O<&5R='D@;F%M93TB9&ES<&QA
M>4YA;64B/D1?4U1!5%53/"]T97AT+7!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@
M("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)C;VQU;6Y.86UE
M(CY$7U1)34527U194$4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@
M(#QT97AT+7!R;W!E<G1Y(&YA;64](F1I<W!L87E.86UE(CY$7U1)34527U19
M4$4\+W1E>'0M<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R
M93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](F-O;'5M;DYA;64B/E-67U-405154U]#
M2$%.1T5?0T%54T4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QT
M97AT+7!R;W!E<G1Y(&YA;64](F1I<W!L87E.86UE(CY35E]35$%455-?0TA!
M3D=%7T-!55-%/"]T97AT+7!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S
M=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)C;VQU;6Y.86UE(CY/4D1%
M4E].54T\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QT97AT+7!R
M;W!E<G1Y(&YA;64](F1I<W!L87E.86UE(CY/4D1%4E].54T\+W1E>'0M<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@
M("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](F-O;'5M;DYA;64B/DY004-?04-4259!5$E/3E]44SPO<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'1E>'0M<')O<&5R='D@;F%M
M93TB9&ES<&QA>4YA;64B/DY004-?04-4259!5$E/3E]44SPO=&5X="UP<F]P
M97)T>3X*("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@
M("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R
M='D@;F%M93TB8V]L=6UN3F%M92(^4D5'24].7U!+/"]P<F]P97)T>3X*("`@
M("`@("`@("`@("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE/2)D:7-P;&%Y
M3F%M92(^4D5'24].7U!+/"]T97AT+7!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@(#PO;&ES="UP<F]P97)T>3X*
M("`@("`@("`@("`@/'-T<G5C='5R92!N86UE/2)C86-H961-971A1&%T82(^
M"B`@("`@("`@("`@("`@("`\;&ES="UP<F]P97)T>2!N86UE/2)R97-U;'13
M970B/@H@("`@("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)P;W-I=&EO;B(^,3PO
M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N
M86UE/2)N86UE(CY35E])1#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^9&5C:6UA;#PO<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@
M("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](G!O<VET:6]N(CXR/"]P<F]P97)T>3X*
M("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FYA;64B
M/E1./"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](F1A=&%4>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@
M(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T
M>2!N86UE/2)P;W-I=&EO;B(^,SPO<')O<&5R='D^"B`@("`@("`@("`@("`@
M("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY.15=?0U524D5.5%]3
M4$E$/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](F1A=&%4>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@
M(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T
M>2!N86UE/2)P;W-I=&EO;B(^-#PO<')O<&5R='D^"B`@("`@("`@("`@("`@
M("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY/3$1?4U!)1#PO<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)D871A5'EP92(^<W1R:6YG/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@
M("`@("`\+W-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\<W1R=6-T
M=7)E/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB
M<&]S:71I;VXB/C4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@("`@
M("`\<')O<&5R='D@;F%M93TB;F%M92(^3D577U-07T1515]$051%/"]P<F]P
M97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64]
M(F1A=&%4>7!E(CYD871E+71I;64\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QS=')U
M8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)P;W-I=&EO;B(^-CPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@
M("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY/3$1?4U!?1%5%7T1!5$4\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M
M93TB9&%T851Y<&4B/F1A=&4M=&EM93PO<')O<&5R='D^"B`@("`@("`@("`@
M("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@/'-T
M<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](G!O<VET:6]N(CXW/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](FYA;64B/E-#2$5$54Q%1%]!0U1)5D%4
M15]$051%/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R
M;W!E<G1Y(&YA;64](F1A=&%4>7!E(CYD871E+71I;64\+W!R;W!E<G1Y/@H@
M("`@("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@
M("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP
M<F]P97)T>2!N86UE/2)P;W-I=&EO;B(^.#PO<')O<&5R='D^"B`@("`@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY$7U-40515
M4SPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T
M>2!N86UE/2)D871A5'EP92(^<W1R:6YG/"]P<F]P97)T>3X*("`@("`@("`@
M("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\
M<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@
M;F%M93TB<&]S:71I;VXB/CD\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB;F%M92(^1%]424U%4E]465!%/"]P
M<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](F1A=&%4>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QS=')U
M8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)P;W-I=&EO;B(^,3`\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@
M("`@("`\<')O<&5R='D@;F%M93TB;F%M92(^4U9?4U1!5%537T-(04Y'15]#
M055313PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P
M97)T>2!N86UE/2)D871A5'EP92(^9&5C:6UA;#PO<')O<&5R='D^"B`@("`@
M("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@
M("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](G!O<VET:6]N(CXQ,3PO<')O<&5R='D^"B`@("`@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY/4D1%4E].54T\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@
M;F%M93TB9&%T851Y<&4B/G-T<FEN9SPO<')O<&5R='D^"B`@("`@("`@("`@
M("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@/'-T
M<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](G!O<VET:6]N(CXQ,CPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY.4$%#7T%#5$E6051)3TY?
M5%,\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R
M='D@;F%M93TB9&%T851Y<&4B/F1A=&4M=&EM93PO<')O<&5R='D^"B`@("`@
M("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@
M("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](G!O<VET:6]N(CXQ,SPO<')O<&5R='D^"B`@("`@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY214=)3TY?4$L\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@
M;F%M93TB9&%T851Y<&4B/F1E8VEM86P\+W!R;W!E<G1Y/@H@("`@("`@("`@
M("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/"]L:7-T
M+7!R;W!E<G1Y/@H@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@
M("`@/'!R;W!E<G1Y(&YA;64](G)O=T9E=&-H3&EM:70B/C`\+W!R;W!E<G1Y
M/@H@("`@("`@("`@("`\;65T:&]D(&YA;64](F)E9F]R94]P96XB/CPA6T-$
M051!6VEM<&]R=%!A8VMA9V4@*%!A8VMA9V5S+FIA=F$N;&%N9RD["FEM<&]R
M=%!A8VMA9V4@*%!A8VMA9V5S+FIA=F$N:6\I.PH*0FER=$QO9V=E<BYD96)U
M9R`H(E-6(%)E<&]R="!B>2!43B!286YG93H@8F5F;W)E3W!E;B(I.PH*=F%R
M(&-O;'5M;G,@/2`B(CL*8V]L=6UN<R`K/2`B(%-67TE$+"!43BP@;F5W7V-U
M<G)E;G1?<W!I9"P@;VQD7W-P:60L(&YE=U]S<%]D=65?9&%T92P@;VQD7W-P
M7V1U95]D871E+"(["F-O;'5M;G,@*ST@(B!S8VAE9'5L961?86-T:79A=&5?
M9&%T92P@<W1A='5S+"`B.PIC;VQU;6YS("L]("(@9&5C;V1E*%-6+E-40515
M4RPG,"<L)T-O;F9L:6-T)RPG,2<L)T%C=&EV92<L("<R)RPG4&5N9&EN9R<L
M("<S)RPG4V5N9&EN9R<L)S0G+"=&86EL960G+"`G-2<L)U!A<G1I86PM1F%I
M;&5D)RP@)S8G+"=$:7-C;VYN96-T+5!E;F1I;F<G+"`G-R<L)T]L9"<L("<X
M)RPG0V%N8V5L960G+"`G.2<L)T-A;F-E;"U096YD:6YG)RPG,3`G+"=5;F1E
M9FEN960G+"<Y.2<L)U9O:60G*2!$7U-405154RP@(CL*8V]L=6UN<R`K/2`B
M(&1E8V]D92`H<W9?875X+G1I;65R7W1Y<&4L("<P)RPG3&]N9R<L)S$G+"=3
M:&]R="<L)S(G+"=-961I=6TG*2!$7U1)34527U194$4L("(["F-O;'5M;G,@
M*ST@(B!35E]35$%455-?0TA!3D=%7T-!55-%+"!O<F1E<E]N=6TL($Y004-?
M04-4259!5$E/3E]44RP@4D5'24].7U!+("(["@IV87(@9&5F875L=%%U97)Y
M(#T@(E-%3$5#5"`O*BL@1DE24U1?4D]74R!/4D1%4D5$(%5315].3"AS=E]G
M='0I($E.1$58*'-V+$E87U-67U1.*2`J+R!23U=?3E5-0D52*"D@3U9%4B`H
M($]21$52($)9(%1.("D@<E]N=6TL("(@*R`@8V]L=6UN<R`K("(@9G)O;2!3
M5BP@4U9?0558('=H97)E(%-6+E-67U!+(#T@4U9?0558+E-67U!+("(["0IV
M87(@=VAE<F5#;&%U<V4@/2`B(CL*"G9A<B!O<F1E<D)Y(#T@(B(["FEF("@@
M<&%R86US6R)33U)47T)9(ET@/3T@(E1.(B`I('L*"6]R9&5R0GD@/2`B($]2
M1$52($)9(%1.(CL*?0IE;'-E(&EF("AP87)A;7-;(E-/4E1?0EDB72`]/2`B
M4U9?240B*2!["@EO<F1E<D)Y(#T@(B!/4D1%4B!"62!35E])1"(["GT*"G9A
M<B!T;E)A;F=E(#T@<&%R86US6R)43E]204Y'12)=+G9A;'5E.PIV87(@;&5N
M(#T@=&Y286YG92YL96YG=&@H*3L*"FEF("@@*&QE;B`]/2`S*2!\?"`H(&QE
M;B`^(#,@)F%M<#LF86UP.R!L96X@/"`Q,"`I("D@>PH)=VAE<F5#;&%U<V4@
M/2`B($%.1"!43B!L:6ME("<B("L@=&Y286YG92`K("(E)R`B.PI]"F5L<V4@
M:68@*"!L96X@/3T@,3`@*2R(@*R!T;E)A;F=E("L@(B<B.PI]"F5L<V4@:68@*"!L96X@/3T@,34@*2S
M=')I;F<H,"PQ,"D@*R`B)R`B.PH)=VAE<F5#;&%U<V4@*ST@(B!!3D0@5$X@
M/#T@)R(@*R!T;E)A;F=E+G-U8G-T<FEN9R@P+#8I.PH)=VAE<F5#;&%U<V4@
M*ST@=&Y286YG92YS=6)S=')I;F<H,3$L,34I("L@(B<@(CL*?0H*+R\@4U8@
M4W1A='5S(&-R:71E<FEA"G9A<B!P87)M8V]U;G0@/2!P87)A;7-;(E-67U-4
M05154R)=+G9A;'5E+FQE;F=T:#L*=F%R('-T871U<T-L875S92`]("(B.PH*
M:68@*"!P87)M8V]U;G0@/B`P("9A;7`[)F%M<#L@*'!A<F%M<ULB4U9?4U1!
M5%53(ETN=F%L=64I6S!=("$]("TQ("D@>PH)<W1A='5S0VQA=7-E(#T@(B!!
M3D0@4W1A='5S(&EN("@@(CL*?0IE;'-E('L*"7!A<FUC;W5N="`](#`["GT*
M"F9O<B`H(&D],#L@:2`\('!A<FUC;W5N=#L@:2LK("E["@EI9B@@:2`]/2`P
M("E["@D)<W1A='5S0VQA=7-E(#T@<W1A='5S0VQA=7-E("L@<&%R86US6R)3
M5E]35$%455,B72YV86QU95MI73L*"7T@"@EE;'-E('L*"0ES=&%T=7-#;&%U
M<V4@/2!S=&%T=7-#;&%U<V4@*R`B("P@(B`K('!A<F%M<ULB4U9?4U1!5%53
M(ETN=F%L=65;:5T[(`H)?0I]"@II9B`H('!A<FUC;W5N="`^(#`@*7L*"7=H
M97)E0VQA=7-E("L]('-T871U<T-L875S92`K("(@*2`B.PI]"@HO+R!.97<@
M4U!)1"!C<FET97)I80II9B`H('!A<F%M<ULB3D577U-0240B72YV86QU92`A
M/2`G04Q,)R`I('L*"7=H97)E0VQA=7-E("L]("(@04Y$($Y%5U]#55)214Y4
M7U-0240@24X@*"<B("L@<&%R86US6R).15=?4U!)1")=+G9A;'5E("L@(B<I
M("(["GT*+R\@3VQD(%-0240@8W)I=&5R:6$*:68@*"!P87)A;7-;(D],1%]3
M4$E$(ETN=F%L=64@(3T@)T%,3"<@*2!["@EW:&5R94-L875S92`K/2`B($%.
M1"!/3$1?4U!)1"!)3B`H)R(@*R!P87)A;7-;(D],1%]34$E$(ETN=F%L=64@
M*R`B)RD@(CL*?0H*:68@*"!P87)A;7-;(E!/4E1?5%E012)=+G9A;'5E("$]
M("TQ("D@>PH)=VAE<F5#;&%U<V4@*ST@(B!!3D0@3$Y07U194$4@/2`B("L@
M<&%R86US6R)03U)47U194$4B72YV86QU92`K("(@(CL*?0H*=&AI<RYQ=65R
M>51E>'0@/2!D969A=6QT475E<GD@*R!W:&5R94-L875S92`K("(@04Y$(')O
M=VYU;3P]("(@*R!N97AT("L@;W)D97)">2`["G1H:7,N<75E<GE497AT(#T@
M(G-E;&5C="`J(&9R;VT@*"(@*R`@=&AI<RYQ=65R>51E>'0@*R`B("D@=VAE
M<F4@<E]N=6T@/CTB("L@<')E=B`["@I":7)T3&]G9V5R+F1E8G5G("@B4U8@
M4F5P;W)T(&)Y(%1.(%)A;F=E.B!297!O<G0@475E<GD@+2`B("L@=&AI<RYQ
M=65R>51E>'0I.PI=73X\+VUE=&AO9#X*("`@("`@("`@("`@/'!R;W!E<G1Y
M(&YA;64](F1A=&%3;W5R8V4B/DQ.4%]$871A4V]U<F-E/"]P<F]P97)T>3X*
M("`@("`@("`@("`@/&QI<W0M<')O<&5R='D@;F%M93TB<F5S=6QT4V5T(CX*
M("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@
M("`@/'!R;W!E<G1Y(&YA;64](G!O<VET:6]N(CXQ/"]P<F]P97)T>3X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%M92(^4U9?240\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)N871I=F5.86UE(CY35E])1#PO<')O<&5R='D^"B`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](F1A=&%4>7!E(CYD96-I;6%L/"]P<F]P
M97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T
M:79E1&%T851Y<&4B/C(\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S
M=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)P;W-I=&EO;B(^,CPO<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FYA
M;64B/E1./"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R
M='D@;F%M93TB;F%T:79E3F%M92(^5$X\+W!R;W!E<G1Y/@H@("`@("`@("`@
M("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^<W1R:6YG/"]P
M<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB
M;F%T:79E1&%T851Y<&4B/C$R/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@
M(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB<&]S:71I;VXB/C,\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)N86UE(CY.15=?0U524D5.5%]34$E$/"]P<F]P97)T>3X*("`@("`@("`@
M("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T:79E3F%M92(^3D577T-5
M4E)%3E1?4U!)1#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R
M;W!E<G1Y(&YA;64](F1A=&%4>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N871I=F5$871A5'EP
M92(^,3(\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^
M"B`@("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@
M("`@(#QP<F]P97)T>2!N86UE/2)P;W-I=&EO;B(^-#PO<')O<&5R='D^"B`@
M("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FYA;64B/D],1%]3
M4$E$/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@
M;F%M93TB;F%T:79E3F%M92(^3TQ$7U-0240\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^<W1R:6YG
M/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M
M93TB;F%T:79E1&%T851Y<&4B/C$R/"]P<F]P97)T>3X*("`@("`@("`@("`@
M("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*
M("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB<&]S:71I;VXB
M/C4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N
M86UE/2)N86UE(CY.15=?4U!?1%5%7T1!5$4\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N871I=F5.86UE(CY.15=?
M4U!?1%5%7T1!5$4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP
M<F]P97)T>2!N86UE/2)D871A5'EP92(^9&%T92UT:6UE/"]P<F]P97)T>3X*
M("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T:79E1&%T
M851Y<&4B/CDS/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@(#PO<W1R=6-T
M=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB<&]S:71I;VXB/C8\+W!R;W!E<G1Y
M/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY/
M3$1?4U!?1%5%7T1!5$4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@
M(#QP<F]P97)T>2!N86UE/2)N871I=F5.86UE(CY/3$1?4U!?1%5%7T1!5$4\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)D871A5'EP92(^9&%T92UT:6UE/"]P<F]P97)T>3X*("`@("`@("`@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T:79E1&%T851Y<&4B/CDS/"]P
M<F]P97)T>3X*("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@
M("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\<')O
M<&5R='D@;F%M93TB<&]S:71I;VXB/C<\+W!R;W!E<G1Y/@H@("`@("`@("`@
M("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY30TA%1%5,141?04-4
M259!5$5?1$%413PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R
M;W!E<G1Y(&YA;64](FYA=&EV94YA;64B/E-#2$5$54Q%1%]!0U1)5D%415]$
M051%/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@
M;F%M93TB9&%T851Y<&4B/F1A=&4M=&EM93PO<')O<&5R='D^"B`@("`@("`@
M("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FYA=&EV941A=&%4>7!E(CXY
M,SPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@
M("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@
M/'!R;W!E<G1Y(&YA;64](G!O<VET:6]N(CXX/"]P<F]P97)T>3X*("`@("`@
M("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%M92(^1%]35$%455,\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)N871I=F5.86UE(CY$7U-405154SPO<')O<&5R='D^"B`@("`@("`@("`@
M("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F1A=&%4>7!E(CYS=')I;F<\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N
M871I=F5$871A5'EP92(^,3(\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@
M/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)P;W-I=&EO;B(^.3PO
M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64]
M(FYA;64B/D1?5$E-15)?5%E013PO<')O<&5R='D^"B`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](FYA=&EV94YA;64B/D1?5$E-15)?5%E0
M13PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](F1A=&%4>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)N871I=F5$871A5'EP92(^,3(\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@
M("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P
M97)T>2!N86UE/2)P;W-I=&EO;B(^,3`\+W!R;W!E<G1Y/@H@("`@("`@("`@
M("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY35E]35$%455-?0TA!
M3D=%7T-!55-%/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O
M<&5R='D@;F%M93TB;F%T:79E3F%M92(^4U9?4U1!5%537T-(04Y'15]#0553
M13PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](F1A=&%4>7!E(CYD96-I;6%L/"]P<F]P97)T>3X*("`@("`@("`@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T:79E1&%T851Y<&4B/C(\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@
M("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P
M97)T>2!N86UE/2)P;W-I=&EO;B(^,3$\+W!R;W!E<G1Y/@H@("`@("`@("`@
M("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CY/4D1%4E].54T\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N
M871I=F5.86UE(CY/4D1%4E].54T\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^<W1R:6YG/"]P<F]P
M97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T
M:79E1&%T851
|
|
| | | | | |
Goto Forum:
Current Time: Sat Apr 19 15:02:30 EDT 2025
Powered by FUDForum. Page generated in 0.04298 seconds
|