Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Format Number using a Style
Format Number using a Style [message #368336] Thu, 21 May 2009 19:43 Go to next message
SuperTime is currently offline SuperTimeFriend
Messages: 45
Registered: July 2009
Member
BIRT 2.3.2.1

Took a sample report and see below, and added a new Style Named "Currency
Symbol". Applied that style to field named "MSRP" which is of type float.
When I privew the report in the preivew tab and the birt viewer, the
formatting does not apply.

Note: I applied direct formatting on the field named "(row["MSRP"] -
row["PRICEEACH"]) / row["MSRP"]" by (select field -> properties->format
number) and that works just fine. The issue is the formatting is not being
applied using a style.

Sample Report:
----------------
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17"
id="1">
<property name="author">Paul Clenahan</property>
<property name="createdBy">Eclipse BIRT Designer Version
2.3.2.r232_20090202 Build &lt;2.3.2.v20090304-1357></property>
<property name="units">in</property>
<text-property name="title">Classic Models Sales Invoice
Report</text-property>
<list-property name="configVars">
<structure>
<property name="name">OrderNumber</property>
<property name="value">10201</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="OrderNumber" id="5">
<text-property name="displayName">Order Naumber</text-property>
<text-property name="helpText">Order number for the
invoice</text-property>
<property name="dataType">decimal</property>
<property name="isRequired">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">10100</property>
<structure name="format">
<property name="category">General Number</property>
<property name="pattern">General Number</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.sampledb" name="Classic
Models" id="6"/>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Invoice Data" id="7">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">OFFICE_CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">FIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">ORDERDATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">SHIPPEDDATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">PRODUCTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">MSRP</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Classic Models</property>
<list-property name="parameters">
<structure>
<property name="name">OrderNumber</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<expression name="defaultValue">10100</expression>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<property name="queryText">SELECT
CLASSICMODELS.OFFICES.CITY AS "OFFICE_CITY",
CLASSICMODELS.EMPLOYEES.LASTNAME,
CLASSICMODELS.EMPLOYEES.FIRSTNAME,
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
CLASSICMODELS.CUSTOMERS.CUSTOMERNAME,
CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME,
CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME,
CLASSICMODELS.CUSTOMERS.ADDRESSLINE1,
CLASSICMODELS.CUSTOMERS.ADDRESSLINE2,
CLASSICMODELS.CUSTOMERS.CITY,
CLASSICMODELS.CUSTOMERS.STATE,
CLASSICMODELS.CUSTOMERS.POSTALCODE,
CLASSICMODELS.CUSTOMERS.COUNTRY,
CLASSICMODELS.ORDERS.ORDERNUMBER,
CLASSICMODELS.ORDERS.ORDERDATE,
CLASSICMODELS.ORDERS.SHIPPEDDATE,
CLASSICMODELS.ORDERDETAILS.PRODUCTCODE,
CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED,
CLASSICMODELS.ORDERDETAILS.PRICEEACH,
CLASSICMODELS.PRODUCTS.PRODUCTNAME,
CLASSICMODELS.PRODUCTS.MSRP

FROM
CLASSICMODELS.OFFICES,
CLASSICMODELS.EMPLOYEES,
CLASSICMODELS.CUSTOMERS,
CLASSICMODELS.ORDERS,
CLASSICMODELS.ORDERDETAILS,
CLASSICMODELS.PRODUCTS

WHERE CLASSICMODELS.OFFICES.OFFICECODE = CLASSICMODELS.EMPLOYEES.OFFICECODE
AND CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER =
CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER
AND CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER =
CLASSICMODELS.ORDERS.CUSTOMERNUMBER
AND CLASSICMODELS.ORDERS.ORDERNUMBER =
CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
AND CLASSICMODELS.ORDERDETAILS.PRODUCTCODE =
CLASSICMODELS.PRODUCTS.PRODUCTCODE
AND CLASSICMODELS.ORDERS.ORDERNUMBER = ?

ORDER BY CLASSICMODELS.ORDERS.ORDERNUMBER</property>
</oda-data-set>
</data-sets>
<styles>
<style name="BackgroundLightGray" id="2">
<property name="backgroundColor">#EAEAEA</property>
</style>
<style name="BackgroundBlue" id="3">
<property name="backgroundColor">#4B6987</property>
</style>
<style name="BackgroundYellow" id="4">
<property name="backgroundColor">#FAD764</property>
</style>
<style name="CurrencySymbol" id="139">
<structure name="numberFormat">
<property name="category">Custom</property>
<property name="pattern">€###,##0.00</property>
</structure>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="8">
<page-footer>
<text id="9">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
<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>
<grid id="10">
<property name="width">100%</property>
<column id="11">
<property name="width">2.8in</property>
</column>
<column id="12">
<property name="width">3.2in</property>
</column>
<row id="13">
<property name="style">BackgroundLightGray</property>
<cell id="14">
<property name="style">BackgroundLightGray</property>
<image id="15">
<property
name="borderBottomColor">#808080</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#808080</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#808080</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#808080</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="source">embed</property>
<property name="imageName">C:\Documents and
Settings\pclenahan\My
Documents\ClassicModels\logos\Classic-Models-Full-M.jpg</property >
</image>
</cell>
<cell id="16">
<property name="style">BackgroundLightGray</property>
<property name="verticalAlign">middle</property>
<label id="17">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">20pt</property>
<property name="fontWeight">bold</property>
<property name="color">#000080</property>
<text-property name="text">Classic Models,
Inc.</text-property>
</label>
<text id="18">
<property name="fontFamily">sans-serif</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[701 Gateway
Boulevard,<BR>
San Francisco, CA 94107<BR>
<BR>]]></text-property>
</text>
<label id="19">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">18pt</property>
<property name="fontWeight">bold</property>
<text-property name="text">Sales
Invoice</text-property>
</label>
</cell>
</row>
<row id="20">
<property name="height">0.25in</property>
<cell id="21"/>
<cell id="22"/>
</row>
</grid>
<table id="23">
<property name="width">100%</property>
<property name="dataSet">Invoice Data</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">OrderNumber</property>
<expression
name="expression">params["OrderNumber"]</expression>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">PRODUCTCODE</property>
<expression
name="expression">dataSetRow["PRODUCTCODE"]</expression >
</structure>
<structure>
<property name="name">PRODUCTNAME</property>
<expression
name="expression">dataSetRow["PRODUCTNAME"]</expression >
</structure>
<structure>
<property name="name">QUANTITYORDERED</property>
<expression
name="expression">dataSetRow["QUANTITYORDERED"]</expression >
</structure>
<structure>
<property name="name">MSRP</property>
<expression
name="expression">dataSetRow["MSRP"]</expression>
</structure>
<structure>
<property name="name">PRICEEACH</property>
<expression
name="expression">dataSetRow["PRICEEACH"]</expression>
</structure>
<structure>
<property name="name">(row["MSRP"] - row["PRICEEACH"])
/ row["MSRP"]</property>
<expression name="expression">(row["MSRP"] -
row["PRICEEACH"]) / row["MSRP"]</expression>
</structure>
<structure>
<property name="name">row["QUANTITYORDERED"] *
row["PRICEEACH"]</property>
<expression name="expression">row["QUANTITYORDERED"] *
row["PRICEEACH"]</expression>
</structure>
<structure>
<property name="name">ORDERNUMBER</property>
<expression
name="expression">dataSetRow["ORDERNUMBER"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">row["CONTACTFIRSTNAME"] + " " +
row["CONTACTLASTNAME"]</property>
<expression name="expression">row["CONTACTFIRSTNAME"]
+ " " + row["CONTACTLASTNAME"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">(row["CITY"] + ", " +
row["STATE"] + " " +
row["POSTALCODE"]).replace("null, ", "").replace("null ",
"").replace("null", "")</property>
<expression name="expression">(row["CITY"] + ", " +
row["STATE"] + " " +
row["POSTALCODE"]).replace("null, ", "").replace("null ",
"").replace("null", "")</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">ORDERDATE</property>
<expression
name="expression">dataSetRow["ORDERDATE"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">SHIPPEDDATE</property>
<expression
name="expression">dataSetRow["SHIPPEDDATE"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">OFFICE_CITY</property>
<expression
name="expression">dataSetRow["OFFICE_CITY"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">FIRSTNAME</property>
<expression
name="expression">dataSetRow["FIRSTNAME"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">LASTNAME</property>
<expression
name="expression">dataSetRow["LASTNAME"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">row["FIRSTNAME"] + " " +
row["LASTNAME"]</property>
<expression name="expression">row["FIRSTNAME"] + " " +
row["LASTNAME"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">QUANTITYORDERED_1</property>
<expression
name="expression">dataSetRow["QUANTITYORDERED"]</expression >
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property name="name">PRICEEACH_1</property>
<expression
name="expression">dataSetRow["PRICEEACH"]</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
<structure>
<property
name="name">Total.sum(row["QUANTITYORDERED"]*row["PRICEEACH "])</property>
<expression
name="expression">Total.sum(row["QUANTITYORDERED"]*row["PRICEEACH "])</expression>
<simple-property-list name="aggregateOn">
<value>Order Group</value>
</simple-property-list>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<column id="132"/>
<column id="133"/>
<column id="134"/>
<column id="135"/>
<column id="136"/>
<column id="137"/>
<column id="138"/>
<group id="24">
<property name="groupName">Order Group</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["ORDERNUMBER"]</expression>
<structure name="toc">
<expression
name="expressionValue">row["ORDERNUMBER"]</expression>
</structure>
<header>
<row id="25">
<cell id="26">
<property name="colSpan">7</property>
<property name="rowSpan">1</property>
<grid id="27">
<property name="width">100%</property>
<column id="28">
<property
name="width">2.343in</property>
</column>
<column id="29">
<property
name="width">0.25in</property>
</column>
<column id="30">
<property
name="width">3.312in</property>
</column>
<row id="31">
<cell id="32">
<property
name="style">BackgroundBlue</property>
<label id="33">
<property
name="fontFamily">sans-serif</property>
<property
name="fontSize">large</property>
<property
name="color">#FFFFFF</property>
<text-property
name="text">Customer Details</text-property>
</label>
</cell>
<cell id="34"/>
<cell id="35">
<property
name="style">BackgroundBlue</property>
<label id="36">
<property
name="fontFamily">sans-serif</property>
<property
name="fontSize">large</property>
<property
name="color">#FFFFFF</property>
<text-property
name="text">Order Details</text-property>
</label>
</cell>
</row>
<row id="37">
<cell id="38">
<property
name="style">BackgroundLightGray</property>
<property
name="verticalAlign">top</property>
<data id="39">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">CUSTOMERNAME</property>
</data>
<data id="40">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">row["CONTACTFIRSTNAME"] + " " +
row["CONTACTLASTNAME"]</property>
</data>
<data id="41">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">ADDRESSLINE1</property>
</data>
<data id="42">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">ADDRESSLINE2</property>
</data>
<data id="43">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">(row["CITY"] + ", " + row["STATE"] + " " +
row["POSTALCODE"]).replace("null, ", "").replace("null ",
"").replace("null", "")</property>
</data>
<data id="44">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">COUNTRY</property>
</data>
</cell>
<cell id="45"/>
<cell id="46">
<property
name="style">BackgroundLightGray</property>
<grid id="47">
<property
name="width">100%</property>
<column id="48"/>
<column id="49"/>
<row id="50">
<cell id="51">
<label id="52">
<property
name="fontFamily">sans-serif</property>
<text-property
name="text">Customer Number:</text-property>
</label>
</cell>
<cell id="53">
<data id="54">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">CUSTOMERNUMBER</property>
</data>
</cell>
</row>
<row id="55">
<cell id="56">
<label id="57">
<property
name="fontFamily">sans-serif</property>
<text-property
name="text">Order Number:</text-property>
</label>
</cell>
<cell id="58">
<data id="59">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">ORDERNUMBER</property>
</data>
</cell>
</row>
<row id="60">
<cell id="61">
<label id="62">
<property
name="fontFamily">sans-serif</property>
<text-property
name="text">Order Date:</text-property>
</label>
</cell>
<cell id="63">
<data id="64">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">ORDERDATE</property>
</data>
</cell>
</row>
<row id="65">
<cell id="66">
<label id="67">
<property
name="fontFamily">sans-serif</property>
<text-property
name="text">Ship Date:</text-property>
</label>
</cell>
<cell id="68">
<data id="69">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">SHIPPEDDATE</property>
</data>
</cell>
</row>
<row id="70">
<cell id="71">
<label id="72">
<property
name="fontFamily">sans-serif</property>
<text-property
name="text">Office:</text-property>
</label>
</cell>
<cell id="73">
<data id="74">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">OFFICE_CITY</property>
</data>
</cell>
</row>
<row id="75">
<cell id="76">
<label id="77">
<property
name="fontFamily">sans-serif</property>
<text-property
name="text">Sales Representative:</text-property>
</label>
</cell>
<cell id="78">
<data id="79">
<property
name="fontFamily">sans-serif</property>
<property
name="fontWeight">bold</property>
<property
name="resultSetColumn">row["FIRSTNAME"] + " " + row["LASTNAME"]</property>
</data>
</cell>
</row>
</grid>
</cell>
</row>
<row id="80">
<property
name="height">0.25in</property>
<cell id="81"/>
<cell id="82"/>
<cell id="83"/>
</row>
</grid>
</cell>
</row>
<row id="84">
<property name="style">BackgroundYellow</property>
<cell id="85">
<property
name="style">BackgroundYellow</property>
<property
name="borderBottomColor">#808080</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#808080</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#808080</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#808080</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="paddingTop">3pt</property>
<property name="paddingLeft">3pt</property>
<property name="paddingBottom">3pt</property>
<property name="paddingRight">3pt</property>
<label id="86">
<property
name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Code</text-property>
</label>
</cell>
<cell id="87">
<property
name="style">BackgroundYellow</property>
<property
name="borderBottomColor">#808080</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#808080</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#808080</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#808080</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="paddingTop">3pt</property>
<property name="paddingLeft">3pt</property>
<property name="paddingBottom">3pt</property>
<property name="paddingRight">3pt</property>
<label id="88">
<property
name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Description</text-property>
</label>
</cell>
<cell id="89">
<property
name="style">BackgroundYellow</property>
<property
name="borderBottomColor">#808080</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#808080</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#808080</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#808080</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="paddingTop">3pt</property>
<property name="paddingLeft">3pt</property>
<property name="paddingBottom">3pt</property>
<property name="paddingRight">3pt</property>
<label id="90">
<property
name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="textAlign">right</property>
<text-property
name="text">Quantity</text-property>
</label>
</cell>
<cell id="91">
<property
name="style">BackgroundYellow</property>
<property
name="borderBottomColor">#808080</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">thin</property>
<property
name="borderLeftColor">#808080</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">thin</property>
<property
name="borderRightColor">#808080</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">thin</property>
<property
name="borderTopColor">#808080</property>
<property
name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="paddingTop">3pt</property>
<property name="paddingLeft">3pt</property>
<property name="paddingBottom">3pt</property>
<property name="paddingRight">3pt</property>
<label id="92">
<property
name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="textAlign">right</property>
<text-property name="text">MSRP
($)</text-property>
</label>

Report message to a moderator

Re: Format Number using a Style [message #368344 is a reply to message #368336] Fri, 22 May 2009 14:30 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

Can you log a bug for this?

Jason

SuperTime wrote:
> BIRT 2.3.2.1
>
> Took a sample report and see below, and added a new Style Named
> "Currency Symbol". Applied that style to field named "MSRP" which is of
> type float. When I privew the report in the preivew tab and the birt
> viewer, the formatting does not apply.
> Note: I applied direct formatting on the field named "(row["MSRP"] -
> row["PRICEEACH"]) / row["MSRP"]" by (select field -> properties->format
> number) and that works just fine. The issue is the formatting is not
> being applied using a style.
>
> Sample Report:
> ----------------
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17"
> id="1">
> <property name="author">Paul Clenahan</property>
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.3.2.r232_20090202 Build &lt;2.3.2.v20090304-1357></property>
> <property name="units">in</property>
> <text-property name="title">Classic Models Sales Invoice
> Report</text-property>
> <list-property name="configVars">
> <structure>
> <property name="name">OrderNumber</property>
> <property name="value">10201</property>
> </structure>
> </list-property>
> <parameters>
> <scalar-parameter name="OrderNumber" id="5">
> <text-property name="displayName">Order Naumber</text-property>
> <text-property name="helpText">Order number for the
> invoice</text-property>
> <property name="dataType">decimal</property>
> <property name="isRequired">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">10100</property>
> <structure name="format">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.sampledb" name="Classic
> Models" id="6"/>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Invoice Data" id="7">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">OFFICE_CITY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">LASTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">FIRSTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">CUSTOMERNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">CONTACTLASTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CONTACTFIRSTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">ADDRESSLINE1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">ADDRESSLINE2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">CITY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">STATE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">POSTALCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">COUNTRY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">ORDERDATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">PRODUCTCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">PRICEEACH</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">20</property>
> <property name="name">PRODUCTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">21</property>
> <property name="name">MSRP</property>
> <property name="dataType">float</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Classic Models</property>
> <list-property name="parameters">
> <structure>
> <property name="name">OrderNumber</property>
> <property name="dataType">integer</property>
> <property name="position">1</property>
> <expression name="defaultValue">10100</expression>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> </list-property>
> <property name="queryText">SELECT
> CLASSICMODELS.OFFICES.CITY AS "OFFICE_CITY",
> CLASSICMODELS.EMPLOYEES.LASTNAME,
> CLASSICMODELS.EMPLOYEES.FIRSTNAME,
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
> CLASSICMODELS.CUSTOMERS.CUSTOMERNAME,
> CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME,
> CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME,
> CLASSICMODELS.CUSTOMERS.ADDRESSLINE1,
> CLASSICMODELS.CUSTOMERS.ADDRESSLINE2,
> CLASSICMODELS.CUSTOMERS.CITY,
> CLASSICMODELS.CUSTOMERS.STATE,
> CLASSICMODELS.CUSTOMERS.POSTALCODE,
> CLASSICMODELS.CUSTOMERS.COUNTRY,
> CLASSICMODELS.ORDERS.ORDERNUMBER,
> CLASSICMODELS.ORDERS.ORDERDATE,
> CLASSICMODELS.ORDERS.SHIPPEDDATE,
> CLASSICMODELS.ORDERDETAILS.PRODUCTCODE,
> CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED,
> CLASSICMODELS.ORDERDETAILS.PRICEEACH,
> CLASSICMODELS.PRODUCTS.PRODUCTNAME,
> CLASSICMODELS.PRODUCTS.MSRP
>
> FROM
> CLASSICMODELS.OFFICES,
> CLASSICMODELS.EMPLOYEES,
> CLASSICMODELS.CUSTOMERS,
> CLASSICMODELS.ORDERS,
> CLASSICMODELS.ORDERDETAILS,
> CLASSICMODELS.PRODUCTS
>
> WHERE CLASSICMODELS.OFFICES.OFFICECODE = CLASSICMODELS.EMPLOYEES.OFFICECODE
> AND CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER =
> CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER
> AND CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER =
> CLASSICMODELS.ORDERS.CUSTOMERNUMBER
> AND CLASSICMODELS.ORDERS.ORDERNUMBER =
> CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
> AND CLASSICMODELS.ORDERDETAILS.PRODUCTCODE =
> CLASSICMODELS.PRODUCTS.PRODUCTCODE
> AND CLASSICMODELS.ORDERS.ORDERNUMBER = ?
>
> ORDER BY CLASSICMODELS.ORDERS.ORDERNUMBER</property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="BackgroundLightGray" id="2">
> <property name="backgroundColor">#EAEAEA</property>
> </style>
> <style name="BackgroundBlue" id="3">
> <property name="backgroundColor">#4B6987</property>
> </style>
> <style name="BackgroundYellow" id="4">
> <property name="backgroundColor">#FAD764</property>
> </style>
> <style name="CurrencySymbol" id="139">
> <structure name="numberFormat">
> <property name="category">Custom</property>
> <property name="pattern">€###,##0.00</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="8">
> <page-footer>
> <text id="9">
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">10pt</property>
> <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>
> <grid id="10">
> <property name="width">100%</property>
> <column id="11">
> <property name="width">2.8in</property>
> </column>
> <column id="12">
> <property name="width">3.2in</property>
> </column>
> <row id="13">
> <property name="style">BackgroundLightGray</property>
> <cell id="14">
> <property name="style">BackgroundLightGray</property>
> <image id="15">
> <property
> name="borderBottomColor">#808080</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#808080</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#808080</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#808080</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="source">embed</property>
> <property name="imageName">C:\Documents and
> Settings\pclenahan\My
> Documents\ClassicModels\logos\Classic-Models-Full-M.jpg</property >
> </image>
> </cell>
> <cell id="16">
> <property name="style">BackgroundLightGray</property>
> <property name="verticalAlign">middle</property>
> <label id="17">
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">20pt</property>
> <property name="fontWeight">bold</property>
> <property name="color">#000080</property>
> <text-property name="text">Classic Models,
> Inc.</text-property>
> </label>
> <text id="18">
> <property name="fontFamily">sans-serif</property>
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[701
> Gateway Boulevard,<BR>
> San Francisco, CA 94107<BR>
> <BR>]]></text-property>
> </text>
> <label id="19">
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">18pt</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Sales
> Invoice</text-property>
> </label>
> </cell>
> </row>
> <row id="20">
> <property name="height">0.25in</property>
> <cell id="21"/>
> <cell id="22"/>
> </row>
> </grid>
> <table id="23">
> <property name="width">100%</property>
> <property name="dataSet">Invoice Data</property>
> <list-property name="paramBindings">
> <structure>
> <property name="paramName">OrderNumber</property>
> <expression
> name="expression">params["OrderNumber"]</expression>
> </structure>
> </list-property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">PRODUCTCODE</property>
> <expression
> name="expression">dataSetRow["PRODUCTCODE"]</expression >
> </structure>
> <structure>
> <property name="name">PRODUCTNAME</property>
> <expression
> name="expression">dataSetRow["PRODUCTNAME"]</expression >
> </structure>
> <structure>
> <property name="name">QUANTITYORDERED</property>
> <expression
> name="expression">dataSetRow["QUANTITYORDERED"]</expression >
> </structure>
> <structure>
> <property name="name">MSRP</property>
> <expression
> name="expression">dataSetRow["MSRP"]</expression>
> </structure>
> <structure>
> <property name="name">PRICEEACH</property>
> <expression
> name="expression">dataSetRow["PRICEEACH"]</expression>
> </structure>
> <structure>
> <property name="name">(row["MSRP"] -
> row["PRICEEACH"]) / row["MSRP"]</property>
> <expression name="expression">(row["MSRP"] -
> row["PRICEEACH"]) / row["MSRP"]</expression>
> </structure>
> <structure>
> <property name="name">row["QUANTITYORDERED"] *
> row["PRICEEACH"]</property>
> <expression name="expression">row["QUANTITYORDERED"]
> * row["PRICEEACH"]</expression>
> </structure>
> <structure>
> <property name="name">ORDERNUMBER</property>
> <expression
> name="expression">dataSetRow["ORDERNUMBER"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">CUSTOMERNAME</property>
> <expression
> name="expression">dataSetRow["CUSTOMERNAME"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">CONTACTFIRSTNAME</property>
> <expression
> name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">CONTACTLASTNAME</property>
> <expression
> name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">row["CONTACTFIRSTNAME"] + " " +
> row["CONTACTLASTNAME"]</property>
> <expression name="expression">row["CONTACTFIRSTNAME"]
> + " " + row["CONTACTLASTNAME"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">ADDRESSLINE1</property>
> <expression
> name="expression">dataSetRow["ADDRESSLINE1"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">ADDRESSLINE2</property>
> <expression
> name="expression">dataSetRow["ADDRESSLINE2"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">CITY</property>
> <expression
> name="expression">dataSetRow["CITY"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">STATE</property>
> <expression
> name="expression">dataSetRow["STATE"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">POSTALCODE</property>
> <expression
> name="expression">dataSetRow["POSTALCODE"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">(row["CITY"] + ", " +
> row["STATE"] + " " +
> row["POSTALCODE"]).replace("null, ", "").replace("null ",
> "").replace("null", "")</property>
> <expression name="expression">(row["CITY"] + ", " +
> row["STATE"] + " " +
> row["POSTALCODE"]).replace("null, ", "").replace("null ",
> "").replace("null", "")</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">COUNTRY</property>
> <expression
> name="expression">dataSetRow["COUNTRY"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <expression
> name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">ORDERDATE</property>
> <expression
> name="expression">dataSetRow["ORDERDATE"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">SHIPPEDDATE</property>
> <expression
> name="expression">dataSetRow["SHIPPEDDATE"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">OFFICE_CITY</property>
> <expression
> name="expression">dataSetRow["OFFICE_CITY"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">FIRSTNAME</property>
> <expression
> name="expression">dataSetRow["FIRSTNAME"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">LASTNAME</property>
> <expression
> name="expression">dataSetRow["LASTNAME"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">row["FIRSTNAME"] + " " +
> row["LASTNAME"]</property>
> <expression name="expression">row["FIRSTNAME"] + " "
> + row["LASTNAME"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">QUANTITYORDERED_1</property>
> <expression
> name="expression">dataSetRow["QUANTITYORDERED"]</expression >
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property name="name">PRICEEACH_1</property>
> <expression
> name="expression">dataSetRow["PRICEEACH"]</expression>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> <structure>
> <property
> name="name">Total.sum(row["QUANTITYORDERED"]*row["PRICEEACH "])</property>
> <expression
> name="expression">Total.sum(row["QUANTITYORDERED"]*row["PRICEEACH "])</expression>
>
> <simple-property-list name="aggregateOn">
> <value>Order Group</value>
> </simple-property-list>
> </structure>
> </list-property>
> <property name="pageBreakInterval">50</property>
> <column id="132"/>
> <column id="133"/>
> <column id="134"/>
> <column id="135"/>
> <column id="136"/>
> <column id="137"/>
> <column id="138"/>
> <group id="24">
> <property name="groupName">Order Group</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression name="keyExpr">row["ORDERNUMBER"]</expression>
> <structure name="toc">
> <expression
> name="expressionValue">row["ORDERNUMBER"]</expression>
> </structure>
> <header>
> <row id="25">
> <cell id="26">
> <property name="colSpan">7</property>
> <property name="rowSpan">1</property>
> <grid id="27">
> <property name="width">100%</property>
> <column id="28">
> <property
> name="width">2.343in</property>
> </column>
> <column id="29">
> <property name="width">0.25in</property>
> </column>
> <column id="30">
> <property
> name="width">3.312in</property>
> </column>
> <row id="31">
> <cell id="32">
> <property
> name="style">BackgroundBlue</property>
> <label id="33">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontSize">large</property>
> <property
> name="color">#FFFFFF</property>
> <text-property
> name="text">Customer Details</text-property>
> </label>
> </cell>
> <cell id="34"/>
> <cell id="35">
> <property
> name="style">BackgroundBlue</property>
> <label id="36">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontSize">large</property>
> <property
> name="color">#FFFFFF</property>
> <text-property
> name="text">Order Details</text-property>
> </label>
> </cell>
> </row>
> <row id="37">
> <cell id="38">
> <property
> name="style">BackgroundLightGray</property>
> <property
> name="verticalAlign">top</property>
> <data id="39">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">CUSTOMERNAME</property>
> </data>
> <data id="40">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">row["CONTACTFIRSTNAME"] + " " +
> row["CONTACTLASTNAME"]</property>
> </data>
> <data id="41">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">ADDRESSLINE1</property>
> </data>
> <data id="42">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">ADDRESSLINE2</property>
> </data>
> <data id="43">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">(row["CITY"] + ", " + row["STATE"] + " " +
> row["POSTALCODE"]).replace("null, ", "").replace("null ",
> "").replace("null", "")</property>
> </data>
> <data id="44">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">COUNTRY</property>
> </data>
> </cell>
> <cell id="45"/>
> <cell id="46">
> <property
> name="style">BackgroundLightGray</property>
> <grid id="47">
> <property
> name="width">100%</property>
> <column id="48"/>
> <column id="49"/>
> <row id="50">
> <cell id="51">
> <label id="52">
> <property
> name="fontFamily">sans-serif</property>
> <text-property
> name="text">Customer Number:</text-property>
> </label>
> </cell>
> <cell id="53">
> <data id="54">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">CUSTOMERNUMBER</property>
> </data>
> </cell>
> </row>
> <row id="55">
> <cell id="56">
> <label id="57">
> <property
> name="fontFamily">sans-serif</property>
> <text-property
> name="text">Order Number:</text-property>
> </label>
> </cell>
> <cell id="58">
> <data id="59">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">ORDERNUMBER</property>
> </data>
> </cell>
> </row>
> <row id="60">
> <cell id="61">
> <label id="62">
> <property
> name="fontFamily">sans-serif</property>
> <text-property
> name="text">Order Date:</text-property>
> </label>
> </cell>
> <cell id="63">
> <data id="64">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">ORDERDATE</property>
> </data>
> </cell>
> </row>
> <row id="65">
> <cell id="66">
> <label id="67">
> <property
> name="fontFamily">sans-serif</property>
> <text-property
> name="text">Ship Date:</text-property>
> </label>
> </cell>
> <cell id="68">
> <data id="69">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">SHIPPEDDATE</property>
> </data>
> </cell>
> </row>
> <row id="70">
> <cell id="71">
> <label id="72">
> <property
> name="fontFamily">sans-serif</property>
> <text-property
> name="text">Office:</text-property>
> </label>
> </cell>
> <cell id="73">
> <data id="74">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">OFFICE_CITY</property>
> </data>
> </cell>
> </row>
> <row id="75">
> <cell id="76">
> <label id="77">
> <property
> name="fontFamily">sans-serif</property>
> <text-property
> name="text">Sales Representative:</text-property>
> </label>
> </cell>
> <cell id="78">
> <data id="79">
> <property
> name="fontFamily">sans-serif</property>
> <property
> name="fontWeight">bold</property>
> <property
> name="resultSetColumn">row["FIRSTNAME"] + " " + row["LASTNAME"]</property>
> </data>
> </cell>
> </row>
> </grid>
> </cell>
> </row>
> <row id="80">
> <property
> name="height">0.25in</property>
> <cell id="81"/>
> <cell id="82"/>
> <cell id="83"/>
> </row>
> </grid>
> </cell>
> </row>
> <row id="84">
> <property name="style">BackgroundYellow</property>
> <cell id="85">
> <property
> name="style">BackgroundYellow</property>
> <property
> name="borderBottomColor">#808080</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#808080</property>
> <property
> name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#808080</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#808080</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="paddingTop">3pt</property>
> <property name="paddingLeft">3pt</property>
> <property name="paddingBottom">3pt</property>
> <property name="paddingRight">3pt</property>
> <label id="86">
> <property
> name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property
> name="text">Code</text-property>
> </label>
> </cell>
> <cell id="87">
> <property
> name="style">BackgroundYellow</property>
> <property
> name="borderBottomColor">#808080</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#808080</property>
> <property
> name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#808080</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">thin</property>
> <property
> name="borderTopColor">#808080</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="paddingTop">3pt</property>
> <property name="paddingLeft">3pt</property>
> <property name="paddingBottom">3pt</property>
> <property name="paddingRight">3pt</property>
> <label id="88">
> <property
> name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property
> name="text">Description</text-property>
> </label>
> </cell>
> <cell id="89">
> <property
> name="style">BackgroundYellow</property>
> <property
> name="borderBottomColor">#808080</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">thin</property>
> <property
> name="borderLeftColor">#808080</property>
> <property
> name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property
> name="borderRightColor">#808080</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">

Report message to a moderator

Re: Format Number using a Style [message #368377 is a reply to message #368344] Tue, 26 May 2009 18:02 Go to previous message
SuperTime is currently offline SuperTimeFriend
Messages: 45
Registered: July 2009
Member
Created Bug 277914
https://bugs.eclipse.org/bugs/show_bug.cgi?id=277914

Report message to a moderator

Previous Topic:Rhino warning setting parameter value in parameter task
Next Topic:MySQL Longtext datatype
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:46:06 GMT 2024

Powered by FUDForum. Page generated in 0.05700 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly