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