Eclipse Community Forums: BIRT » Export Birt report in Excel

Messages: 6
Registered: January 2011

Junior Member

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 #649283 is a reply to message #649278]

Tue, 18 January 2011 15:13

Richard A. Polunsky

Messages: 212
Registered: July 2009
Location: Houston TX

Senior Member

In order to figure out how to get everything to align, the export logic looks at all visible tables and resolves their column widths to create the minimum number of Excel columns needed. Then in each output table, columns are merged as needed to add up to the correct width.

If you want to avoid merged columns, you need to set your visibility so that only one object (table or grid, for example) is visible in the report. Then the export logic will only see that object and will only generate the columns implied by its sizing.

Re: Export Birt report in Excel [message #649289 is a reply to message #649278]

Tue, 18 January 2011 15:41

Messages: 9167
Registered: July 2009

Senior Member

Can you reproduce this with the sample db and post your sample here?

Jason

On 1/18/2011 9:43 AM, Nolo wrote:
> 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 #649432 is a reply to message #649283]

Wed, 19 January 2011 08:55

Messages: 6
Registered: January 2011

Junior Member

Richard A. Polunsky wrote on Tue, 18 January 2011 10:13

Where do i set the visibility?

Re: Export Birt report in Excel [message #649436 is a reply to message #649289]

Wed, 19 January 2011 08:58

Messages: 6
Registered: January 2011

Junior Member

Jason Weathersby wrote on Tue, 18 January 2011 10:41

Can you reproduce this with the sample db and post your sample here?

Jason

I don't know how to attach a file here.

Re: Export Birt report in Excel [message #649505 is a reply to message #649278]

Wed, 19 January 2011 14:02

Messages: 6
Registered: January 2011

Junior Member

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 17:42

Messages: 9167
Registered: July 2009

Senior Member

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

Re: Export Birt report in Excel [message #649652 is a reply to message #649563]

Thu, 20 January 2011 06:09

Messages: 6
Registered: January 2011

Junior Member

The only option that i get when i click on visibility is 'Hide Element' and if i click that it hides the whole table.

Re: Export Birt report in Excel [message #649816 is a reply to message #649652]

Thu, 20 January 2011 16:15

Messages: 9167
Registered: July 2009

Senior Member

Does the report only contain one table? Can you try to email it to me
at jasonweathersby at windstream dot net?

Jason

On 1/20/2011 1:09 AM, Nolo wrote:
> The only option that i get when i click on visibility is 'Hide Element'
> and if i click that it hides the whole table.

Re: Export Birt report in Excel [message #727513 is a reply to message #649816]

Wed, 21 September 2011 13:40

Missing name Mising name

Messages: 4
Registered: January 2011

Junior Member

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

Attachment: SV_Summary_TN_Range.rptdesign
(Size: 85.07KB, Downloaded 872 times)
Attachment: rptimage.png
(Size: 33.98KB, Downloaded 602 times)

(no subject) [message #727568 is a reply to message #649816]

Wed, 21 September 2011 13:40

Missing name Mising name

Messages: 4
Registered: January 2011

Junior Member

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`@*2!["@EW:&5R94-L875S92`]("(@04Y$(%1.(#T@
M)R(@*R!T;E)A;F=E("L@(B<B.PI]"F5L<V4@:68@*"!L96X@/3T@,34@*2![
M"@EW:&5R94-L875S92`]("(@04Y$(%1.(#X]("<B("L@=&Y286YG92YS=6)S
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

Re: Export Birt report in Excel [message #727634 is a reply to message #727568]

Wed, 21 September 2011 17:59

Messages: 9167
Registered: July 2009

Senior Member

I responded to your email.
I believe this may because of nested grids in the list. Try using a
table instead.

Jason

On 9/21/2011 9:40 AM, agl.vijay wrote:
> 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

Re: Export Birt report in Excel [message #830818 is a reply to message #727634]

Wed, 28 March 2012 04:55

Gopishankar H

Messages: 1
Registered: March 2012

Junior Member

Hi jason

Do u mean by adding a table with the grid?? i couldnt add a table in the masterpage. Is this a bug?? if so how can i solve??

Regards

Gopishankar

Re: Export Birt report in Excel [message #832164 is a reply to message #830818]

Thu, 29 March 2012 21:16

Messages: 9167
Registered: July 2009

Senior Member

No I meant the grids for the headers. Can you reproduce with the sample
db and post that report? BTW tables are not allowed on the master page.

Jason

Hi jason
>
> Do u mean by adding a table with the grid?? i couldnt add a table in the
> masterpage. Is this a bug?? if so how can i solve??
>
> Regards
>
> Gopishankar

Re: Export Birt report in Excel [message #1017475 is a reply to message #832164]

Mon, 11 March 2013 22:27

A R

Messages: 104
Registered: April 2012

Senior Member

Hi Jason,

I am also facing the same issue. Different coulmns are missing at every export, not same column is missing all times.

I am using BIRT 2.6.1. However I am not able to reproduce the same issue.

Please suggest.

Thanks
AR