Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Export Birt report in Excel(Export Birt report in Excel)
Export Birt report in Excel [message #649278] Tue, 18 January 2011 09:43 Go to next message
Nolo  is currently offline Nolo
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 10:13 Go to previous messageGo to next message
Richard A. Polunsky is currently offline Richard A. Polunsky
Messages: 197
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 10:41 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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.


Jason Weathersby

BIRT Exchange
Re: Export Birt report in Excel [message #649432 is a reply to message #649283] Wed, 19 January 2011 03:55 Go to previous messageGo to next message
Nolo  is currently offline Nolo
Messages: 6
Registered: January 2011
Junior Member
Richard A. Polunsky wrote on Tue, 18 January 2011 10:13
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.

Where do i set the visibility?
Re: Export Birt report in Excel [message #649436 is a reply to message #649289] Wed, 19 January 2011 03:58 Go to previous messageGo to next message
Nolo  is currently offline Nolo
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 09:02 Go to previous messageGo to next message
Nolo  is currently offline Nolo
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 &lt;2.3.2.v20090218-0730></property>
<property name="units">in</property>
<property name="comments">IBM Confidential

OCO Source Materials

5724-M19

(C) COPYRIGHT IBM CORP. 2006

The source code for this program is not published or otherwise
divested of its trade secrets, irrespective of what has been
deposited with the U.S. Copyright Office.</property>
<html-property name="description">This template will create a report having a single header with multiple rows of data.</html-property>
<method name="initialize">< ![CDATA[importPackage(Packages.com.ibm.tivoli.maximo.report. script);

mxReportScriptContext = MXReportScriptContext.initialize(reportContext);]]></method >
<method name="afterFactory"><![CDATA[MXReportScriptContext.close();]] ></method>
<property name="theme">MaximoSystemLibrary.maximoTheme</property>
<text-property name="displayName">Tivoli Maximo List Template</text-property>
<property name="bidiLayoutOrientation">ltr</property>
<list-property name="libraries">
<structure>
<property name="fileName">MaximoSystemLibrary.rptlibrary</property>
<property name="namespace">MaximoSystemLibrary</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="where" id="25">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">1=1</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="appname" id="200">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="paramdelimiter" id="202">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="paramstring" id="201">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="startdate" id="504">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">10-11-01</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="enddate" id="505">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">11-01-07</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="siteid" id="506">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">=CENTRAL</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="CostCentre" id="507">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">text-box</property>
<property name="defaultValue">561401</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<script-data-source name="maximoDataSource" id="64" extends="MaximoSystemLibrary.maximoDataSource"/>
</data-sources>
<data-sets>
<script-data-set name="dataSet1" id="415">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">costcentre</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">uniqueno</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">empname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">refwo</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">activity</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">StartDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">finishdate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">allowtype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">worklocation</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">Approved</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">months</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">dates</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">timefrom</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">timeto</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">hours</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">ErrorReport</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Reversal</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">ErrorMessage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">Recordid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">enterby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">n_authorisedby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">Capture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">today</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">ldesc</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">costcentre</property>
</structure>
<structure>
<property name="columnName">uniqueno</property>
</structure>
<structure>
<property name="columnName">empname</property>
</structure>
<structure>
<property name="columnName">refwo</property>
</structure>
<structure>
<property name="columnName">activity</property>
</structure>
<structure>
<property name="columnName">StartDate</property>
</structure>
<structure>
<property name="columnName">finishdate</property>
</structure>
<structure>
<property name="columnName">allowtype</property>
</structure>
<structure>
<property name="columnName">worklocation</property>
</structure>
<structure>
<property name="columnName">Approved</property>
</structure>
<structure>
<property name="columnName">months</property>
</structure>
<structure>
<property name="columnName">dates</property>
</structure>
<structure>
<property name="columnName">timefrom</property>
</structure>
<structure>
<property name="columnName">timeto</property>
</structure>
<structure>
<property name="columnName">hours</property>
</structure>
<structure>
<property name="columnName">ErrorReport</property>
</structure>
<structure>
<property name="columnName">Reversal</property>
</structure>
<structure>
<property name="columnName">ErrorMessage</property>
</structure>
<structure>
<property name="columnName">Recordid</property>
</structure>
<structure>
<property name="columnName">enterby</property>
</structure>
<structure>
<property name="columnName">n_authorisedby</property>
</structure>
<structure>
<property name="columnName">Capture</property>
</structure>
<structure>
<property name="columnName">today</property>
</structure>
<structure>
<property name="columnName">ldesc</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">costcentre</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">uniqueno</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">empname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">refwo</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">activity</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">StartDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">finishdate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">allowtype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">worklocation</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">Approved</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">months</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">dates</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">timefrom</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">timeto</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">hours</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">ErrorReport</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Reversal</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">ErrorMessage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">Recordid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">enterby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">n_authorisedby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">Capture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">today</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">ldesc</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">maximoDataSource</property>
<method name="open"><![CDATA[maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName( ), this.getName());
maximoDataSet.open();

var sqlText = new String();

// Add query to sqlText variable.
sqlText = " SELECT laborcraftrate.CONTROLACCOUNT costcentre, "
+ "lb.laborcode uniqueno, "
+ "p.displayname empname,labtrans.refwo, "
+ "labtrans.transtype activity, "
+ "labtrans.startdate StartDate, "
+ "labtrans.finishdate, "
+ "labtrans.n_overtimetype allowtype, lb.worklocation, "
+ "case when labtrans.genapprservreceipt = 1 then 'Y' else 'N' end Approved, "
+ "TO_CHAR (labtrans.startdate, 'yyyymm') months, TO_CHAR (labtrans.startdate, 'dd/mm/yyyy') dates, "
+ "TO_CHAR (labtrans.starttime, 'hh24:mi:ss') timefrom, TO_CHAR (labtrans.finishtime, 'hh24:mi:ss') timeto, "
+ "labtrans.regularhrs hours, labtrans.N_ERRORCODE ErrorReport, "
+ "case when labtrans.REGULARHRS < 0 then 'Y' else 'N' end Reversal, "
+ "labtrans.N_ERRORDESC ErrorMessage, "
+ "labtrans.N_RECORDID Recordid, "
+ "labtrans.enterby, "
+ "labtrans.n_authorisedby, "
+ "labtrans.n_capindnorrev Capture, "
+ " (select sysdate from dual)today, "
+ "l.description ldesc "
+ "FROM labor lb,person p,labtrans ,LABORCRAFTRATE, locations l "
+ "WHERE labtrans.laborcode = lb.laborcode "
+ "and l.location = lB.worklocation "
+ "AND (labtrans.n_overtimetype IS NOT NULL) "
+ "AND p.personid = lb.personid and lb.LABORCODE = laborcraftrate.LABORCODE "
+ "and laborcraftrate.controlaccount like (SELECT CASE WHEN '" + params["CostCentre"] + "' = '*' THEN '%' WHEN '" + params["CostCentre"] + "' is null THEN '%' "
+ "WHEN '" + params["CostCentre"] + "' = '%' THEN '%' else '" + params["CostCentre"] + "' end from dual) "
+ "and laborcraftrate.DEFAULTCRAFT = 1 "
+ "and labtrans.STARTDATE >= to_date('" + params["startdate"]+"'" + ",'yy-mm-dd') "
+ "and labtrans.STARTDATE < to_date('" + params["enddate"]+"'" + ",'yy-mm-dd')+1 and "
+ MXReportSqlFormat.createParamWhereClause("lb.worksite", params["siteid"])
+ "ORDER BY lb.laborcode,labtrans.startdate, labtrans.starttime "
;

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

// Add a line for each output column
// The specific get method should match the data type of the output column.
row["costcentre"] = maximoDataSet.getString("costcentre");
row["uniqueno"] = maximoDataSet.getString("uniqueno");
row["empname"] = maximoDataSet.getString("empname");
row["refwo"] = maximoDataSet.getString("refwo");
row["activity"] = maximoDataSet.getString("activity");
row["StartDate"] = maximoDataSet.getString("StartDate");
row["finishdate"] = maximoDataSet.getString("finishdate");
row["allowtype"] = maximoDataSet.getString("allowtype");
row["worklocation"] = maximoDataSet.getString("worklocation");
row["Approved"] = maximoDataSet.getString("Approved");
row["months"] = maximoDataSet.getString("months");
row["dates"] = maximoDataSet.getString("dates");
row["timefrom"] = maximoDataSet.getString("timefrom");
row["timeto"] = maximoDataSet.getString("timeto");
row["hours"] = maximoDataSet.getString("hours");
row["ErrorReport"] = maximoDataSet.getString("ErrorReport");
row["Reversal"] = maximoDataSet.getString("Reversal");
row["ErrorMessage"] = maximoDataSet.getString("ErrorMessage");
row["Recordid"] = maximoDataSet.getString("Recordid");
row["enterby"] = maximoDataSet.getString("enterby");
row["n_authorisedby"] = maximoDataSet.getString("n_authorisedby");
row["Capture"] = maximoDataSet.getString("Capture");
row["today"] = maximoDataSet.getString("today");
row["ldesc"] = maximoDataSet.getString("ldesc");






return (true);]]></method>
</script-data-set>
<script-data-set name="dataSet2" id="1118">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">costcentre</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">uniqueno</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">empname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">allowtype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">months</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">dates</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">timefrom</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">timeto</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ErrorReport</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ErrorMessage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">Recordid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">worklocation</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">StartDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Capture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">enterby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">n_authorisedby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">n_approvalind</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">costcentre</property>
</structure>
<structure>
<property name="columnName">uniqueno</property>
</structure>
<structure>
<property name="columnName">empname</property>
</structure>
<structure>
<property name="columnName">allowtype</property>
</structure>
<structure>
<property name="columnName">description</property>
</structure>
<structure>
<property name="columnName">months</property>
</structure>
<structure>
<property name="columnName">dates</property>
</structure>
<structure>
<property name="columnName">timefrom</property>
</structure>
<structure>
<property name="columnName">timeto</property>
</structure>
<structure>
<property name="columnName">ErrorReport</property>
</structure>
<structure>
<property name="columnName">ErrorMessage</property>
</structure>
<structure>
<property name="columnName">Recordid</property>
</structure>
<structure>
<property name="columnName">worklocation</property>
</structure>
<structure>
<property name="columnName">StartDate</property>
</structure>
<structure>
<property name="columnName">Capture</property>
</structure>
<structure>
<property name="columnName">enterby</property>
</structure>
<structure>
<property name="columnName">n_authorisedby</property>
</structure>
<structure>
<property name="columnName">n_approvalind</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">costcentre</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">uniqueno</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">empname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">allowtype</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">months</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">dates</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">timefrom</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">timeto</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ErrorReport</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ErrorMessage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">Recordid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">worklocation</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">StartDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Capture</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">enterby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">n_authorisedby</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">n_approvalind</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">maximoDataSource</property>
<method name="open"><![CDATA[maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName( ), this.getName());
maximoDataSet.open();

var sqlText = new String();

// Add query to sqlText variable.
sqlText = " SELECT laborcraftrate.CONTROLACCOUNT costcentre, "
+ "lb.laborcode uniqueno, p.displayname empname, "
+ "a.n_allowancecode allowtype, "
+ "v.DESCRIPTION description, "
+ "TO_CHAR (a.startdate, 'yyyymm') months, "
+ "TO_CHAR (a.startdate, 'dd/mm/yyyy') dates, "
+ "TO_CHAR (a.starttime, 'hh24:mi:ss') timefrom, "
+ "TO_CHAR (a.finishtime, 'hh24:mi:ss') timeto, "
+ "a.N_ERRORCODE ErrorReport, "
+ "a.N_ERRORDESC ErrorMessage, "
+ "a.N_RECORDID Recordid, "
//+ "case when a.n_allowancecode in ('4400','4420','4410','3700','3800','4000','4010','4020','41 00','4110','4120','4130','4140','4150','4160','GO','GO1','GO 2','HV','HW','HR1','HR2','HR3','KJ','KK','KL','K3','K4','K5' ,'K6')then count(a.n_allowancecode) else 0 end Allowcount, "
+ "lb.worklocation, "
+ " a.startdate StartDate, "
+ "a.n_capindnorrev Capture, "
+ " a.enterby, "
+ " a.n_authorisedby, "
+ " case when a.n_approvalind = 1 then 'Y' else 'N' end n_approvalind "
+ "FROM labor lb,person p ,LABORCRAFTRATE , attendance a ,synonymdomain v "
+ "where p.personid = lb.personid "
+ "and lb.LABORCODE = laborcraftrate.LABORCODE "
+ "and laborcraftrate.DEFAULTCRAFT = 1 "
+ "and laborcraftrate.controlaccount like (SELECT CASE WHEN '" + params["CostCentre"] + "' = '*' THEN '%' WHEN '" + params["CostCentre"] + "' is null THEN '%' "
+ "WHEN '" + params["CostCentre"] + "' = '%' THEN '%' else '" + params["CostCentre"] + "' end from dual) "
+ "and a.laborcode = lb.laborcode "
+ " and a.STARTDATE >= to_date('" + params["startdate"]+"'" + ",'yy-mm-dd') "
+ " and a.STARTDATE < to_date('" + params["enddate"]+"'" + ",'yy-mm-dd')+1 and "
+ MXReportSqlFormat.createParamWhereClause("lb.worksite", params["siteid"])
+ "AND v.VALUE(+) = a.n_allowancecode "
+ "and v.DOMAINID = 'ALLOWANCES' "
+ " ORDER BY lb.laborcode,a.startdate "
/*+ "group by laborcraftrate.CONTROLACCOUNT , "
+ "lb.laborcode , p.displayname , "
+ "a.n_allowancecode , "
+ "v.DESCRIPTION , "
+ "a.startdate, "
+ "a.starttime, "
+ "a.finishtime, "
+ "a.N_ERRORCODE , "
+ "a.N_ERRORDESC , "
+ "a.N_RECORDID "*/

;

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

// Add a line for each output column
// The specific get method should match the data type of the output column.
row["costcentre"] = maximoDataSet.getString("costcentre");
row["uniqueno"] = maximoDataSet.getString("uniqueno");
row["empname"] = maximoDataSet.getString("empname");
row["allowtype"] = maximoDataSet.getString("allowtype");
row["description"] = maximoDataSet.getString("description");
row["months"] = maximoDataSet.getString("months");
row["dates"] = maximoDataSet.getString("dates");
row["timefrom"] = maximoDataSet.getString("timefrom");
row["timeto"] = maximoDataSet.getString("timeto");
row["ErrorReport"] = maximoDataSet.getString("ErrorReport");
row["ErrorMessage"] = maximoDataSet.getString("ErrorMessage");
row["Recordid"] = maximoDataSet.getString("Recordid");
//row["Allowcount"] = maximoDataSet.getString("Allowcount");
row["worklocation"] = maximoDataSet.getString("worklocation");
row["StartDate"] = maximoDataSet.getString("StartDate");
row["Capture"] = maximoDataSet.getString("Capture");
row["enterby"] = maximoDataSet.getString("enterby");
row["n_authorisedby"] = maximoDataSet.getString("n_authorisedby");
row["n_approvalind"] = maximoDataSet.getString("n_approvalind");


return (true);]]></method>
</script-data-set>
</data-sets>
<styles>
<style name="crosstab" id="341">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="342">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="maximoLandscape" id="47" extends="MaximoSystemLibrary.maximoLandscape">
<property name="type">custom</property>
<property name="height">10in</property>
<property name="width">19in</property>
<overridden-values>
<ref-entry baseId="304" name="NewGrid2" id="304"/>
<ref-entry baseId="305" id="305"/>
<ref-entry baseId="306" id="306"/>
<ref-entry baseId="307" id="307"/>
<ref-entry baseId="308" id="308"/>
<ref-entry baseId="340" name="NewImage1" id="340">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr">true</expression>
</structure>
</list-property>
</ref-entry>
<ref-entry baseId="309" id="309"/>
<ref-entry baseId="310" name="NewImage" id="310">
<property name="source">file</property>
<expression name="uri">"eskom.gif"</expression>
<property name="height">10mm</property>
<property name="width">35mm</property>
</ref-entry>
<ref-entry baseId="322" name="NewGrid" id="322"/>
<ref-entry baseId="323" id="323"/>
<ref-entry baseId="324" id="324"/>
<ref-entry baseId="325" id="325"/>
<ref-entry baseId="326" id="326"/>
<ref-entry baseId="328" name="NewText" id="328"/>
<ref-entry baseId="327" id="327"/>
<ref-entry baseId="329" name="NewGrid1" id="329"/>
<ref-entry baseId="330" id="330"/>
<ref-entry baseId="331" id="331"/>
<ref-entry baseId="332" id="332"/>
<ref-entry baseId="333" id="333"/>
<ref-entry baseId="334" id="334"/>
<ref-entry baseId="335" name="NewAutoText" id="335"/>
<ref-entry baseId="336" id="336"/>
<ref-entry baseId="337" name="NewText1" id="337"/>
<ref-entry baseId="338" id="338"/>
<ref-entry baseId="339" name="NewAutoText1" id="339"/>
</overridden-values>
<property name="headerHeight">0.5in</property&g
Re: Export Birt report in Excel [message #649563 is a reply to message #649505] Wed, 19 January 2011 12:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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


Jason Weathersby

BIRT Exchange
Re: Export Birt report in Excel [message #649652 is a reply to message #649563] Thu, 20 January 2011 01:09 Go to previous messageGo to next message
Nolo  is currently offline Nolo
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 11:15 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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.


Jason Weathersby

BIRT Exchange
Re: Export Birt report in Excel [message #727513 is a reply to message #649816] Wed, 21 September 2011 09:40 Go to previous messageGo to next message
agl.vijay is currently offline agl.vijay
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
(no subject) [message #727568 is a reply to message #649816] Wed, 21 September 2011 09:40 Go to previous messageGo to next message
agl.vijay is currently offline agl.vijay
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 13:59 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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


Jason Weathersby

BIRT Exchange
Re: Export Birt report in Excel [message #830818 is a reply to message #727634] Wed, 28 March 2012 00:55 Go to previous messageGo to next message
Gopishankar H is currently offline 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 17:16 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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


Jason Weathersby

BIRT Exchange
Re: Export Birt report in Excel [message #1017475 is a reply to message #832164] Mon, 11 March 2013 18:27 Go to previous messageGo to next message
A R is currently offline 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
Re: Export Birt report in Excel [message #1018274 is a reply to message #1017475] Wed, 13 March 2013 10:44 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Is it only with one report? Can you post the report?

Jason


Jason Weathersby

BIRT Exchange
Previous Topic:RenderTask - Failed to load class "org.eclipse.emf.oda.ecore.impl.ResultSet$JavaObject"
Next Topic:problem with visibility settings
Goto Forum:
  


Current Time: Wed Apr 16 00:25:05 EDT 2014

Powered by FUDForum. Page generated in 0.05830 seconds