Download
Getting Started
Members
Projects
Community
Marketplace
Events
Planet Eclipse
Newsletter
Videos
Participate
Report a Bug
Forums
Mailing Lists
Wiki
IRC
How to Contribute
Working Groups
Automotive
Internet of Things
LocationTech
Long-Term Support
PolarSys
Science
OpenMDM
More
Community
Marketplace
Events
Planet Eclipse
Newsletter
Videos
Participate
Report a Bug
Forums
Mailing Lists
Wiki
IRC
How to Contribute
Working Groups
Automotive
Internet of Things
LocationTech
Long-Term Support
PolarSys
Science
OpenMDM
Toggle navigation
Bugzilla – Attachment 97423 Details for
Bug 228645
Thai3.4:Run As DOC render different font and different size for currency field
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Requests
|
Help
|
Log In
[x]
|
Terms of Use
|
Copyright Agent
Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read
this important communication.
Report design
Test_Report_CrossTab.rptdesign (text/plain), 32.27 KB, created by
Nattapong Sirilappanich
on 2008-04-24 06:56:55 EDT
(
hide
)
Description:
Report design
Filename:
MIME Type:
Creator:
Nattapong Sirilappanich
Created:
2008-04-24 06:56:55 EDT
Size:
32.27 KB
patch
obsolete
><?xml version="1.0" encoding="UTF-8"?> ><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.16" id="1"> > <property name="createdBy">Eclipse BIRT Designer Version 2.3.0.v20080328 Build <2.3.0.v20080403-1020></property> > <property name="units">in</property> > <property name="comments">Copyright (c) 2006 <<Your Company Name here>></property> > <html-property name="description">Creates a blank report with no predefined content.</html-property> > <list-property name="userProperties"> > <structure> > <property name="name">สีà¹à¹à¸«à¸¥à¸µà¹à¸¢à¸¡à¸à¸±à¸à¸¸à¸£à¸±à¸ª.CrossTabDataset.x</property> > <property name="type">integer</property> > <property name="isVisible">false</property> > </structure> > <structure> > <property name="name">สีà¹à¹à¸«à¸¥à¸µà¹à¸¢à¸¡à¸à¸±à¸à¸¸à¸£à¸±à¸ª.CrossTabDataset.y</property> > <property name="type">integer</property> > <property name="isVisible">false</property> > </structure> > </list-property> > <property name="สีà¹à¹à¸«à¸¥à¸µà¹à¸¢à¸¡à¸à¸±à¸à¸¸à¸£à¸±à¸ª.CrossTabDataset.x">135</property> > <property name="สีà¹à¹à¸«à¸¥à¸µà¹à¸¢à¸¡à¸à¸±à¸à¸¸à¸£à¸±à¸ª.CrossTabDataset.y">80</property> > <text-property name="displayName">Blank Report</text-property> > <property name="iconFile">/templates/blank_report.gif</property> > <data-sources> > <oda-data-source extensionID="org.eclipse.datatools.connectivity.oda.flatfile" name="CrossTabDatasource" id="4"> > <property name="HOME">C:\Temp</property> > <property name="DELIMTYPE">COMMA</property> > <property name="CHARSET">UTF-8</property> > <property name="INCLCOLUMNNAME">YES</property> > <property name="INCLTYPELINE">YES</property> > </oda-data-source> > </data-sources> > <data-sets> > <oda-data-set extensionID="org.eclipse.datatools.connectivity.oda.flatfile.dataSet" name="CrossTabDataset" id="5"> > <structure name="cachedMetaData"> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">SALES_ID</property> > <property name="dataType">integer</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">CUSTOMERID</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">CUSTOMER_SEX</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">CUSTOMER_REGION</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">PRODUCTID</property> > <property name="dataType">integer</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">PRODUCT_NAME</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">PRODUCT_TYPE</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">SOLD_DATE</property> > <property name="dataType">any</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">QUANTITY_PRICE</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">10</property> > <property name="name">QUANTITY</property> > <property name="dataType">float</property> > </structure> > </list-property> > </structure> > <property name="dataSource">CrossTabDatasource</property> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">SALES_ID</property> > <property name="nativeName">SALES_ID</property> > <property name="dataType">integer</property> > <property name="nativeDataType">4</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">CUSTOMERID</property> > <property name="nativeName">CUSTOMERID</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">CUSTOMER_SEX</property> > <property name="nativeName">CUSTOMER_SEX</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">CUSTOMER_REGION</property> > <property name="nativeName">CUSTOMER_REGION</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">PRODUCTID</property> > <property name="nativeName">PRODUCTID</property> > <property name="dataType">integer</property> > <property name="nativeDataType">4</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">PRODUCT_NAME</property> > <property name="nativeName">PRODUCT_NAME</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">PRODUCT_TYPE</property> > <property name="nativeName">PRODUCT_TYPE</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">SOLD_DATE</property> > <property name="nativeName">SOLD_DATE</property> > <property name="dataType">any</property> > <property name="nativeDataType">91</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">QUANTITY_PRICE</property> > <property name="nativeName">QUANTITY_PRICE</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">10</property> > <property name="name">QUANTITY</property> > <property name="nativeName">QUANTITY</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > </list-property> > <property name="queryText">select "SALES_ID", "CUSTOMERID", "CUSTOMER_SEX", "CUSTOMER_REGION", "PRODUCTID", "PRODUCT_NAME", "PRODUCT_TYPE", "SOLD_DATE", "QUANTITY_PRICE", "QUANTITY" from exportdata.csv : {"SALES_ID","SALES_ID",INT;"CUSTOMERID","CUSTOMERID",STRING;"CUSTOMER_SEX","CUSTOMER_SEX",STRING;"CUSTOMER_REGION","CUSTOMER_REGION",STRING;"PRODUCTID","PRODUCTID",INT;"PRODUCT_NAME","PRODUCT_NAME",STRING;"PRODUCT_TYPE","PRODUCT_TYPE",STRING;"SOLD_DATE","SOLD_DATE",DATE;"QUANTITY_PRICE","QUANTITY_PRICE",DOUBLE;"QUANTITY","QUANTITY",DOUBLE}</property> > <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?> ><model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel"> > <Version>1.0</Version> > <design:ResultSets derivedMetaData="true"> > <design:resultSetDefinitions> > <design:resultSetColumns> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>SALES_ID</design:name> > <design:position>1</design:position> > <design:nativeDataTypeCode>4</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>SALES_ID</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>CUSTOMERID</design:name> > <design:position>2</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>CUSTOMERID</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>CUSTOMER_SEX</design:name> > <design:position>3</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>CUSTOMER_SEX</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>CUSTOMER_REGION</design:name> > <design:position>4</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>CUSTOMER_REGION</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>PRODUCTID</design:name> > <design:position>5</design:position> > <design:nativeDataTypeCode>4</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>PRODUCTID</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>PRODUCT_NAME</design:name> > <design:position>6</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>PRODUCT_NAME</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>PRODUCT_TYPE</design:name> > <design:position>7</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>PRODUCT_TYPE</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>SOLD_DATE</design:name> > <design:position>8</design:position> > <design:nativeDataTypeCode>91</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>SOLD_DATE</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>QUANTITY_PRICE</design:name> > <design:position>9</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>QUANTITY_PRICE</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>QUANTITY</design:name> > <design:position>10</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>-1</design:precision> > <design:scale>-1</design:scale> > <design:nullability>Unknown</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>QUANTITY</design:label> > <design:formattingHints/> > </design:usageHints> > </design:resultColumnDefinitions> > </design:resultSetColumns> > </design:resultSetDefinitions> > </design:ResultSets> ></model:DesignValues>]]></xml-property> > </oda-data-set> > </data-sets> > <cubes> > <tabular-cube name="สีà¹à¹à¸«à¸¥à¸µà¹à¸¢à¸¡à¸à¸±à¸à¸¸à¸£à¸±à¸ª" id="6"> > <property name="defaultMeasureGroup">MeasureGroup</property> > <property name="dimensions"> > <tabular-dimension name="REGION" id="8"> > <property name="defaultHierarchy">NewTabularHierarchy</property> > <property name="hierarchies"> > <tabular-hierarchy name="NewTabularHierarchy" id="9"> > <property name="levels"> > <tabular-level name="à¸à¸·à¹à¸à¸à¸µà¹à¸¥à¸¹à¸à¸à¹à¸²" id="10"> > <property name="dataType">string</property> > <property name="levelType">dynamic</property> > <property name="columnName">CUSTOMER_REGION</property> > </tabular-level> > </property> > <property name="dataSet">CrossTabDataset</property> > </tabular-hierarchy> > </property> > </tabular-dimension> > <tabular-dimension name="SEX" id="11"> > <property name="defaultHierarchy">NewTabularHierarchy1</property> > <property name="hierarchies"> > <tabular-hierarchy name="NewTabularHierarchy1" id="12"> > <property name="levels"> > <tabular-level name="CUSTOMER_SEX" id="13"> > <property name="dataType">string</property> > <property name="columnName">CUSTOMER_SEX</property> > </tabular-level> > </property> > <property name="dataSet">CrossTabDataset</property> > </tabular-hierarchy> > </property> > </tabular-dimension> > <tabular-dimension name="PRODUCT" id="14"> > <property name="defaultHierarchy">NewTabularHierarchy2</property> > <property name="hierarchies"> > <tabular-hierarchy name="NewTabularHierarchy2" id="15"> > <property name="levels"> > <tabular-level name="PRODUCT_TYPE" id="16"> > <property name="dataType">string</property> > <property name="columnName">PRODUCT_TYPE</property> > </tabular-level> > <tabular-level name="PRODUCT_NAME" id="17"> > <property name="dataType">string</property> > <property name="interval">none</property> > <property name="levelType">dynamic</property> > <list-property name="attributes"> > <structure> > <property name="name">PRODUCTID</property> > <property name="dataType">integer</property> > </structure> > </list-property> > <property name="columnName">PRODUCT_NAME</property> > </tabular-level> > </property> > <property name="dataSet">CrossTabDataset</property> > </tabular-hierarchy> > </property> > </tabular-dimension> > </property> > <property name="measureGroups"> > <tabular-measure-group name="MeasureGroup" id="7"> > <property name="measures"> > <tabular-measure name="ราà¸à¸² (รวม)" id="18"> > <property name="function">sum</property> > <expression name="measureExpression">dataSetRow["QUANTITY_PRICE"]</expression> > <property name="dataType">float</property> > </tabular-measure> > <tabular-measure name="QUANTITY" id="19"> > <expression name="measureExpression">dataSetRow["QUANTITY"]</expression> > </tabular-measure> > </property> > </tabular-measure-group> > </property> > <property name="dataSet">CrossTabDataset</property> > </tabular-cube> > </cubes> > <styles> > <style name="crosstab-cell" id="45"> > <property name="borderBottomColor">#8080FF</property> > <property name="borderBottomStyle">solid</property> > <property name="borderBottomWidth">thin</property> > <property name="borderLeftColor">#8080FF</property> > <property name="borderLeftStyle">solid</property> > <property name="borderLeftWidth">thin</property> > <property name="borderRightColor">#8080FF</property> > <property name="borderRightStyle">solid</property> > <property name="borderRightWidth">thin</property> > <property name="borderTopColor">#8080FF</property> > <property name="borderTopStyle">solid</property> > <property name="borderTopWidth">thin</property> > </style> > <style name="rowdimension" id="49"> > <property name="backgroundColor">#8080FF</property> > </style> > <style name="dimension2" id="50"> > <property name="backgroundColor">#8080C0</property> > </style> > <style name="Columndimension" id="51"> > <property name="backgroundColor">#FF8080</property> > <structure name="dateTimeFormat"> > <property name="category">Short Date</property> > </structure> > </style> > <style name="dimension" id="52"> > <property name="backgroundColor">#FF8040</property> > </style> > </styles> > <page-setup> > <simple-master-page name="Simple MasterPage" id="2"> > <page-footer> > <text id="3"> > <property name="contentType">html</property> > <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> > </text> > </page-footer> > </simple-master-page> > </page-setup> > <body> > <extended-item extensionName="Crosstab" extensionVersion="2.3.0" id="20"> > <property name="measures"> > <extended-item extensionName="MeasureView" id="35"> > <property name="measure">ราà¸à¸² (รวม)</property> > <property name="detail"> > <extended-item extensionName="AggregationCell" id="54"> > <property name="paddingTop">1pt</property> > <property name="content"> > <data name="QUANTITY_PRICE" id="38"> > <structure name="dateTimeFormat"> > <property name="category">Custom</property> > </structure> > <structure name="numberFormat"> > <property name="category">Currency</property> > <property name="pattern">฿#,##0.00</property> > </structure> > <property name="resultSetColumn">QUANTITY_PRICE</property> > </data> > </property> > </extended-item> > </property> > <property name="header"> > <extended-item extensionName="CrosstabCell" id="37"> > <property name="content"> > <label id="39"> > <text-property name="text">QUANTITY_PRICE</text-property> > </label> > </property> > </extended-item> > </property> > </extended-item> > <extended-item extensionName="MeasureView" id="40"> > <property name="measure">QUANTITY</property> > <property name="detail"> > <extended-item extensionName="AggregationCell" id="55"> > <property name="content"> > <data name="QUANTITY" id="43"> > <property name="resultSetColumn">QUANTITY</property> > </data> > </property> > </extended-item> > </property> > <property name="header"> > <extended-item extensionName="CrosstabCell" id="42"> > <property name="content"> > <label id="44"> > <text-property name="text">QUANTITY</text-property> > </label> > </property> > </extended-item> > </property> > </extended-item> > </property> > <property name="rows"> > <extended-item extensionName="CrosstabView" id="21"> > <property name="views"> > <extended-item extensionName="DimensionView" id="22"> > <property name="dimension">SEX</property> > <property name="levels"> > <extended-item extensionName="LevelView" name="NewLevel View" id="23"> > <property name="level">SEX/CUSTOMER_SEX</property> > <property name="member"> > <extended-item extensionName="CrosstabCell" id="24"> > <property name="content"> > <data name="CUSTOMER_SEX" id="25"> > <property name="style">rowdimension</property> > <property name="resultSetColumn">CUSTOMER_SEX</property> > </data> > </property> > </extended-item> > </property> > </extended-item> > </property> > </extended-item> > <extended-item extensionName="DimensionView" id="26"> > <property name="dimension">REGION</property> > <property name="levels"> > <extended-item extensionName="LevelView" name="NewLevel View1" id="27"> > <property name="level">REGION/à¸à¸·à¹à¸à¸à¸µà¹à¸¥à¸¹à¸à¸à¹à¸²</property> > <property name="member"> > <extended-item extensionName="CrosstabCell" id="28"> > <property name="content"> > <data name="CUSTOMER_REGION" id="29"> > <property name="style">dimension2</property> > <property name="resultSetColumn">CUSTOMER_REGION</property> > </data> > </property> > </extended-item> > </property> > </extended-item> > </property> > </extended-item> > </property> > </extended-item> > </property> > <property name="columns"> > <extended-item extensionName="CrosstabView" id="30"> > <property name="views"> > <extended-item extensionName="DimensionView" id="31"> > <property name="dimension">PRODUCT</property> > <property name="levels"> > <extended-item extensionName="LevelView" name="NewLevel View2" id="32"> > <property name="level">PRODUCT/PRODUCT_TYPE</property> > <property name="member"> > <extended-item extensionName="CrosstabCell" id="33"> > <property name="content"> > <data name="PRODUCT_TYPE" id="34"> > <property name="style">Columndimension</property> > <property name="resultSetColumn">PRODUCT_TYPE</property> > </data> > </property> > </extended-item> > </property> > </extended-item> > <extended-item extensionName="LevelView" name="NewLevel View3" id="46"> > <property name="level">PRODUCT/PRODUCT_NAME</property> > <property name="member"> > <extended-item extensionName="CrosstabCell" id="47"> > <property name="content"> > <data name="PRODUCT_NAME" id="48"> > <property name="style">dimension</property> > <property name="resultSetColumn">PRODUCT_NAME</property> > </data> > </property> > </extended-item> > </property> > </extended-item> > </property> > </extended-item> > </property> > </extended-item> > </property> > <property name="header"> > <extended-item extensionName="CrosstabCell" id="53"/> > </property> > <property name="cube">สีà¹à¹à¸«à¸¥à¸µà¹à¸¢à¸¡à¸à¸±à¸à¸¸à¸£à¸±à¸ª</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">CUSTOMER_SEX</property> > <expression name="expression">dimension["SEX"]["CUSTOMER_SEX"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">CUSTOMER_REGION</property> > <expression name="expression">dimension["REGION"]["à¸à¸·à¹à¸à¸à¸µà¹à¸¥à¸¹à¸à¸à¹à¸²"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">PRODUCT_TYPE</property> > <expression name="expression">dimension["PRODUCT"]["PRODUCT_TYPE"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">QUANTITY_PRICE</property> > <expression name="expression">measure["ราà¸à¸² (รวม)"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">QUANTITY</property> > <expression name="expression">measure["QUANTITY"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">PRODUCT_NAME</property> > <expression name="expression">dimension["PRODUCT"]["PRODUCT_NAME"]</expression> > <property name="dataType">any</property> > </structure> > </list-property> > </extended-item> > </body> ></report>
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 228645
:
97422
| 97423