Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Alternate color of row in crosstable
Alternate color of row in crosstable [message #365349] Mon, 29 September 2008 15:27 Go to next message
Eclipse UserFriend
Originally posted by: moi.toto.com

Do you know how to alternate the color in row of crosstable ?

Regards,
Blured.

Report message to a moderator

Re: Alternate color of row in crosstable [message #365350 is a reply to message #365349] Mon, 29 September 2008 15:41 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: moi.toto.com

moi a écrit :
> Do you know how to alternate the color in row of crosstable ?
>
> Regards,
> Blured.

I try in the highlight of the cell to put :
row.__rownum%2==0 however this test always return false, it works
currently on table which are not crosstable.

Regards,
Moi.

Report message to a moderator

Re: Alternate color of row in crosstable [message #365352 is a reply to message #365350] Mon, 29 September 2008 17:29 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

You should be able to do this with a hidden element in the last column.
Take a look at this example.

Jason

<?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.v20080606 Build &lt;2.3.0.v20080618-0630></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 &lt;&lt;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">Customer Cube.Data Set.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">Customer Cube.Data Set.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
</list-property>
<property name="Customer Cube.Data Set.x">235</property>
<property name="Customer Cube.Data Set.y">105</property>
<method name="beforeFactory"><![CDATA[importPackage(
Packages.java.lang );
rwc1 = new Integer(1);
reportContext.setPersistentGlobalVariable("rwc", rwc1);]]></method>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="6">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="DataForCube" id="30">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">REQUIREDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SHIPPEDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">STATUS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">COMMENTS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CUSTOMERNUMBER_8</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">ORDERNUMBER_21</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">PRODUCTCODE_26</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">PRODUCTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">PRODUCTLINE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">PRODUCTSCALE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">30</property>
<property name="name">PRODUCTVENDOR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">31</property>
<property name="name">PRODUCTDESCRIPTION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">32</property>
<property name="name">QUANTITYINSTOCK</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">33</property>
<property name="name">BUYPRICE</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">34</property>
<property name="name">MSRP</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERDATE</property>
<property name="nativeName">ORDERDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">REQUIREDDATE</property>
<property name="nativeName">REQUIREDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SHIPPEDDATE</property>
<property name="nativeName">SHIPPEDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">STATUS</property>
<property name="nativeName">STATUS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">COMMENTS</property>
<property name="nativeName">COMMENTS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CUSTOMERNUMBER_8</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">CUSTOMERNAME</property>
<property name="nativeName">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">CONTACTLASTNAME</property>
<property name="nativeName">CONTACTLASTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="nativeName">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">PHONE</property>
<property name="nativeName">PHONE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">ADDRESSLINE1</property>
<property name="nativeName">ADDRESSLINE1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">ADDRESSLINE2</property>
<property name="nativeName">ADDRESSLINE2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">CITY</property>
<property name="nativeName">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">POSTALCODE</property>
<property name="nativeName">POSTALCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">COUNTRY</property>
<property name="nativeName">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property
name="nativeName">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">CREDITLIMIT</property>
<property name="nativeName">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">ORDERNUMBER_21</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">PRODUCTCODE</property>
<property name="nativeName">PRODUCTCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">QUANTITYORDERED</property>
<property name="nativeName">QUANTITYORDERED</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">PRICEEACH</property>
<property name="nativeName">PRICEEACH</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">ORDERLINENUMBER</property>
<property name="nativeName">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">PRODUCTCODE_26</property>
<property name="nativeName">PRODUCTCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">PRODUCTNAME</property>
<property name="nativeName">PRODUCTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">PRODUCTLINE</property>
<property name="nativeName">PRODUCTLINE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">PRODUCTSCALE</property>
<property name="nativeName">PRODUCTSCALE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">30</property>
<property name="name">PRODUCTVENDOR</property>
<property name="nativeName">PRODUCTVENDOR</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">31</property>
<property name="name">PRODUCTDESCRIPTION</property>
<property
name="nativeName">PRODUCTDESCRIPTION</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">32</property>
<property name="name">QUANTITYINSTOCK</property>
<property name="nativeName">QUANTITYINSTOCK</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">33</property>
<property name="name">BUYPRICE</property>
<property name="nativeName">BUYPRICE</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">34</property>
<property name="name">MSRP</property>
<property name="nativeName">MSRP</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">select *
from
CLASSICMODELS.ORDERS,
CLASSICMODELS.CUSTOMERS,
CLASSICMODELS.ORDERDETAILS,
CLASSICMODELS.PRODUCTS
where
CLASSICMODELS.ORDERS.ORDERNUMBER=CLASSICMODELS.ORDERDETAILS. ORDERNUMBER
and
CLASSICMODELS.ORDERDETAILS.PRODUCTCODE=CLASSICMODELS.PRODUCT S.PRODUCTCODE
and
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER=CLASSICMODELS.ORDERS. CUSTOMERNUMBER
and
CLASSICMODELS.ORDERS.STATUS = 'Shipped'</property>
</oda-data-set>
</data-sets>
<cubes>
<tabular-cube name="salesbydate" id="61">
<property name="defaultMeasureGroup">Summary Field1</property>
<property name="dimensions">
<tabular-dimension name="Group2" id="63">
<property
name="defaultHierarchy">NewTabularHierarchy2</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy2"
id="64">
<property name="levels">
<tabular-level name="PRODUCTLINE" id="65">
<property
name="dataType">string</property>
<property
name="columnName">PRODUCTLINE</property>
</tabular-level>
</property>
<property name="dataSet">DataForCube</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Group3" id="67">
<property name="isTimeType">true</property>
<property
name="defaultHierarchy">NewTabularHierarchy3</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy3"
id="68">
<property name="levels">
<tabular-level name="year" id="69">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">year</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="quarter" id="70">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">quarter</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="month" id="71">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">month</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="week-of-month"
id="72">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">week-of-month</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="week-of-year" id="73">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">week-of-year</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="day-of-week" id="74">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">day-of-week</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="day-of-month" id="75">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">day-of-month</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="day-of-year" id="76">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">day-of-year</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="hour" id="77">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">hour</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="minute" id="78">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">minute</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
<tabular-level name="second" id="79">
<property
name="dataType">integer</property>
<property
name="dateTimeLevelType">second</property>
<property
name="columnName">SHIPPEDDATE</property>
</tabular-level>
</property>
<property name="dataSet">DataForCube</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="Summary Field1" id="62">
<property name="measures">
<tabular-measure name="revenue" id="66">
<property name="function">sum</property>
<expression
name="measureExpression">dataSetRow["QUANTITYORDERED"]*dataSetRow[ "PRICEEACH"]</expression>
<property name="dataType">float</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">DataForCube</property>
</tabular-cube>
</cubes>
<styles>
<style name="crosstab" id="4">
<property name="backgroundColor">#FFFFFF</property>
<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="5">
<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="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="80">
<property name="measures">
<extended-item extensionName="MeasureView" id="91">
<property name="measure">revenue</property>
<property name="detail">
<extended-item extensionName="AggregationCell"
id="119">
<property
name="backgroundColor">#E1FABC</property>
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<expression
name="testExpr">importPackage( Packages.java.lang );
var trwctmp = reportContext.getPersistentGlobalVariable("rwc").intValue();
trwctmp % 2</expression>
<simple-property-list name="value1">
<value>0</value>
</simple-property-list>
<property
name="backgroundColor">#FFFFFF</property>
</structure>
</list-property>
<property name="content">
<data name="revenue" id="94">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">$#,##0</property>
</structure>
<property
name="textAlign">right</property>
<property
name="resultSetColumn">revenue</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell"
id="101">
<property
name="aggregationOnRow">Group3/year</property>
<property
name="aggregationOnColumn">Group2/PRODUCTLINE</property>
<property
name="backgroundColor">#E1FABC</property>
<property name="content">
<data id="102">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">$#,##0</property>
</structure>
<property
name="textAlign">right</property>
<property
name="resultSetColumn">revenue_Group3/year_Group2/PRODUCTLINE </property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell"
id="105">
<property
name="aggregationOnColumn">Group2/PRODUCTLINE</property>
<property
name="backgroundColor">#E1FABC</property>
<property name="content">
<data id="106">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">$#,##0</property>
</structure>
<property
name="textAlign">right</property>
<property
name="resultSetColumn">revenue_Group2/PRODUCTLINE</property >
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell"
id="109">
<property
name="aggregationOnRow">Group3/year</property>
<property
name="backgroundColor">#E1FABC</property>
<property name="content">
<data id="110">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">$#,##0</property>
</structure>
<property
name="textAlign">right</property>
<property
name="resultSetColumn">revenue_Group3/year</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell"
id="111">
<property
name="aggregationOnRow">Group3/quarter</property>
<property
name="backgroundColor">#E1FABC</property>
<property name="content">
<data id="112">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">$#,##0</property>
</structure>
<property
name="textAlign">right</property>
<property
name="resultSetColumn">revenue_Group3/quarter</property>
</data>
<data id="117">
<list-property name="visibility">
<structure>
<property
name="format">all</property>
<expression
name="valueExpr">true</expression>
</structure>
</list-property>
<property
name="resultSetColumn">dummy</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell"
id="113">
<property
name="backgroundColor">#E1FABC</property>
<property name="content">
<data id="114">
<property
name="fontWeight">bold</property>
<property
name="borderBottomColor">#000000</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">1px</property>
<property
name="borderLeftColor">#000000</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">1px</property>
<property
name="borderRightColor">#000000</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">1px</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property
name="borderTopWidth">1px</property>
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">$#,##0</property>
</structure>
<property
name="textAlign">right</property>
<property
name="resultSetColumn">revenue_1</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell"
id="93">
<property
name="backgroundColor">#808000</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item extensionName="CrosstabView" id="86">
<property name="grandTotal">
<extended-item extensionName="CrosstabCell"
id="104">
<property name="content">
<label id="107">
<property
name="backgroundColor">#808000</property>
<property
name="fontSize">10pt</property>
<property
name="fontWeight">bold</property>
<property
name="color">#FFFFFF</property>
<property
name="borderBottomColor">#000000</property>
<property
name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">2px</property>
<property
name="borderLeftColor">#000000</property>
<property
name="borderLeftStyle">solid</property>
<property
name="borderLeftWidth">2px</property>
<property
name="borderRightColor">#000000</property>
<property
name="borderRightStyle">solid</property>
<property
name="borderRightWidth">2px</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property
name="borderTopWidth">2px</property>
<text-property name="text">Grand
Total</text-property>
</label>
</property>
</extended-item>
</property>
<property name="views">
<extended-item extensionName="DimensionView"
id="87">
<property name="dimension">Group3</property>
<property name="levels">
<extended-item
extensionName="LevelView" name="NewLevel View3" id="88">
<property
name="level">Group3/year</property>
<property name="member">
<extended-item
extensionName="CrosstabCell" id="89">
<property name="content">
<label id="99">

Report message to a moderator

Re: Alternate color of row in crosstable [message #365362 is a reply to message #365352] Tue, 30 September 2008 09:14 Go to previous message
Eclipse UserFriend
Originally posted by: moi.toto.com

Nice it is well working.

Regards,
Moi.

Jason Weathersby a écrit :
> You should be able to do this with a hidden element in the last column.
> Take a look at this example.
>
> Jason
>
> <?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.v20080606 Build &lt;2.3.0.v20080618-0630></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2006 &lt;&lt;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">Customer Cube.Data Set.x</property>
> <property name="type">integer</property>
> <property name="isVisible">false</property>
> </structure>
> <structure>
> <property name="name">Customer Cube.Data Set.y</property>
> <property name="type">integer</property>
> <property name="isVisible">false</property>
> </structure>
> </list-property>
> <property name="Customer Cube.Data Set.x">235</property>
> <property name="Customer Cube.Data Set.y">105</property>
> <method name="beforeFactory"><![CDATA[importPackage(
> Packages.java.lang );
> rwc1 = new Integer(1);
> reportContext.setPersistentGlobalVariable("rwc", rwc1);]]></method>
> <text-property name="displayName">Blank Report</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="6">
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="DataForCube" id="30">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">ORDERDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">REQUIREDDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">STATUS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">COMMENTS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">CUSTOMERNUMBER_8</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">CUSTOMERNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">CONTACTLASTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">CONTACTFIRSTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">PHONE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">ADDRESSLINE1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">ADDRESSLINE2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">CITY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">STATE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">POSTALCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">COUNTRY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property
> name="name">SALESREPEMPLOYEENUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">20</property>
> <property name="name">CREDITLIMIT</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">21</property>
> <property name="name">ORDERNUMBER_21</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">22</property>
> <property name="name">PRODUCTCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">23</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">24</property>
> <property name="name">PRICEEACH</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">25</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">26</property>
> <property name="name">PRODUCTCODE_26</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">27</property>
> <property name="name">PRODUCTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">28</property>
> <property name="name">PRODUCTLINE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">29</property>
> <property name="name">PRODUCTSCALE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">30</property>
> <property name="name">PRODUCTVENDOR</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">31</property>
> <property name="name">PRODUCTDESCRIPTION</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">32</property>
> <property name="name">QUANTITYINSTOCK</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">33</property>
> <property name="name">BUYPRICE</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">34</property>
> <property name="name">MSRP</property>
> <property name="dataType">float</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">ORDERDATE</property>
> <property name="nativeName">ORDERDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">REQUIREDDATE</property>
> <property name="nativeName">REQUIREDDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="nativeName">SHIPPEDDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">STATUS</property>
> <property name="nativeName">STATUS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">COMMENTS</property>
> <property name="nativeName">COMMENTS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="nativeName">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">CUSTOMERNUMBER_8</property>
> <property name="nativeName">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">CUSTOMERNAME</property>
> <property name="nativeName">CUSTOMERNAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">CONTACTLASTNAME</property>
> <property name="nativeName">CONTACTLASTNAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">CONTACTFIRSTNAME</property>
> <property name="nativeName">CONTACTFIRSTNAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">PHONE</property>
> <property name="nativeName">PHONE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">ADDRESSLINE1</property>
> <property name="nativeName">ADDRESSLINE1</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">ADDRESSLINE2</property>
> <property name="nativeName">ADDRESSLINE2</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">CITY</property>
> <property name="nativeName">CITY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">STATE</property>
> <property name="nativeName">STATE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">POSTALCODE</property>
> <property name="nativeName">POSTALCODE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">COUNTRY</property>
> <property name="nativeName">COUNTRY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">SALESREPEMPLOYEENUMBER</property>
> <property
> name="nativeName">SALESREPEMPLOYEENUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">20</property>
> <property name="name">CREDITLIMIT</property>
> <property name="nativeName">CREDITLIMIT</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> <structure>
> <property name="position">21</property>
> <property name="name">ORDERNUMBER_21</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">22</property>
> <property name="name">PRODUCTCODE</property>
> <property name="nativeName">PRODUCTCODE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">23</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="nativeName">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">24</property>
> <property name="name">PRICEEACH</property>
> <property name="nativeName">PRICEEACH</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> <structure>
> <property name="position">25</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="nativeName">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">5</property>
> </structure>
> <structure>
> <property name="position">26</property>
> <property name="name">PRODUCTCODE_26</property>
> <property name="nativeName">PRODUCTCODE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">27</property>
> <property name="name">PRODUCTNAME</property>
> <property name="nativeName">PRODUCTNAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">28</property>
> <property name="name">PRODUCTLINE</property>
> <property name="nativeName">PRODUCTLINE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">29</property>
> <property name="name">PRODUCTSCALE</property>
> <property name="nativeName">PRODUCTSCALE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">30</property>
> <property name="name">PRODUCTVENDOR</property>
> <property name="nativeName">PRODUCTVENDOR</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">31</property>
> <property name="name">PRODUCTDESCRIPTION</property>
> <property
> name="nativeName">PRODUCTDESCRIPTION</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">32</property>
> <property name="name">QUANTITYINSTOCK</property>
> <property name="nativeName">QUANTITYINSTOCK</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">33</property>
> <property name="name">BUYPRICE</property>
> <property name="nativeName">BUYPRICE</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> <structure>
> <property name="position">34</property>
> <property name="name">MSRP</property>
> <property name="nativeName">MSRP</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> </list-property>
> <property name="queryText">select *
> from
> CLASSICMODELS.ORDERS,
> CLASSICMODELS.CUSTOMERS,
> CLASSICMODELS.ORDERDETAILS,
> CLASSICMODELS.PRODUCTS
> where
> CLASSICMODELS.ORDERS.ORDERNUMBER=CLASSICMODELS.ORDERDETAILS. ORDERNUMBER
> and
> CLASSICMODELS.ORDERDETAILS.PRODUCTCODE=CLASSICMODELS.PRODUCT S.PRODUCTCODE
> and
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER=CLASSICMODELS.ORDERS. CUSTOMERNUMBER
> and
> CLASSICMODELS.ORDERS.STATUS = 'Shipped'</property>
> </oda-data-set>
> </data-sets>
> <cubes>
> <tabular-cube name="salesbydate" id="61">
> <property name="defaultMeasureGroup">Summary Field1</property>
> <property name="dimensions">
> <tabular-dimension name="Group2" id="63">
> <property
> name="defaultHierarchy">NewTabularHierarchy2</property>
> <property name="hierarchies">
> <tabular-hierarchy name="NewTabularHierarchy2"
> id="64">
> <property name="levels">
> <tabular-level name="PRODUCTLINE" id="65">
> <property
> name="dataType">string</property>
> <property
> name="columnName">PRODUCTLINE</property>
> </tabular-level>
> </property>
> <property name="dataSet">DataForCube</property>
> </tabular-hierarchy>
> </property>
> </tabular-dimension>
> <tabular-dimension name="Group3" id="67">
> <property name="isTimeType">true</property>
> <property
> name="defaultHierarchy">NewTabularHierarchy3</property>
> <property name="hierarchies">
> <tabular-hierarchy name="NewTabularHierarchy3"
> id="68">
> <property name="levels">
> <tabular-level name="year" id="69">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">year</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="quarter" id="70">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">quarter</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="month" id="71">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">month</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="week-of-month"
> id="72">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">week-of-month</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="week-of-year" id="73">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">week-of-year</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="day-of-week" id="74">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">day-of-week</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="day-of-month" id="75">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">day-of-month</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="day-of-year" id="76">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">day-of-year</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="hour" id="77">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">hour</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="minute" id="78">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">minute</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> <tabular-level name="second" id="79">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">second</property>
> <property
> name="columnName">SHIPPEDDATE</property>
> </tabular-level>
> </property>
> <property name="dataSet">DataForCube</property>
> </tabular-hierarchy>
> </property>
> </tabular-dimension>
> </property>
> <property name="measureGroups">
> <tabular-measure-group name="Summary Field1" id="62">
> <property name="measures">
> <tabular-measure name="revenue" id="66">
> <property name="function">sum</property>
> <expression
> name="measureExpression">dataSetRow["QUANTITYORDERED"]*dataSetRow[ "PRICEEACH"]</expression>
>
> <property name="dataType">float</property>
> </tabular-measure>
> </property>
> </tabular-measure-group>
> </property>
> <property name="dataSet">DataForCube</property>
> </tabular-cube>
> </cubes>
> <styles>
> <style name="crosstab" id="4">
> <property name="backgroundColor">#FFFFFF</property>
> <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="5">
> <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="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="80">
> <property name="measures">
> <extended-item extensionName="MeasureView" id="91">
> <property name="measure">revenue</property>
> <property name="detail">
> <extended-item extensionName="AggregationCell"
> id="119">
> <property
> name="backgroundColor">#E1FABC</property>
> <list-property name="highlightRules">
> <structure>
> <property name="operator">eq</property>
> <expression
> name="testExpr">importPackage( Packages.java.lang );
> var trwctmp = reportContext.getPersistentGlobalVariable("rwc").intValue();
> trwctmp % 2</expression>
> <simple-property-list name="value1">
> <value>0</value>
> </simple-property-list>
> <property
> name="backgroundColor">#FFFFFF</property>
> </structure>
> </list-property>
> <property name="content">
> <data name="revenue" id="94">
> <structure name="numberFormat">
> <property
> name="category">Currency</property>
> <property
> name="pattern">$#,##0</property>
> </structure>
> <property
> name="textAlign">right</property>
> <property
> name="resultSetColumn">revenue</property>
> </data>
> </property>
> </extended-item>
> </property>
> <property name="aggregations">
> <extended-item extensionName="AggregationCell"
> id="101">
> <property
> name="aggregationOnRow">Group3/year</property>
> <property
> name="aggregationOnColumn">Group2/PRODUCTLINE</property>
> <property
> name="backgroundColor">#E1FABC</property>
> <property name="content">
> <data id="102">
> <structure name="numberFormat">
> <property
> name="category">Currency</property>
> <property
> name="pattern">$#,##0</property>
> </structure>
> <property
> name="textAlign">right</property>
> <property
> name="resultSetColumn">revenue_Group3/year_Group2/PRODUCTLINE </property>
> </data>
> </property>
> </extended-item>
> <extended-item extensionName="AggregationCell"
> id="105">
> <property
> name="aggregationOnColumn">Group2/PRODUCTLINE</property>
> <property
> name="backgroundColor">#E1FABC</property>
> <property name="content">
> <data id="106">
> <structure name="numberFormat">
> <property
> name="category">Currency</property>
> <property
> name="pattern">$#,##0</property>
> </structure>
> <property
> name="textAlign">right</property>
> <property
> name="resultSetColumn">revenue_Group2/PRODUCTLINE</property >
> </data>
> </property>
> </extended-item>
> <extended-item extensionName="AggregationCell"
> id="109">
> <property
> name="aggregationOnRow">Group3/year</property>
> <property
> name="backgroundColor">#E1FABC</property>
> <property name="content">
> <data id="110">
> <structure name="numberFormat">
> <property
> name="category">Currency</property>
> <property
> name="pattern">$#,##0</property>
> </structure>
> <property
> name="textAlign">right</property>
> <property
> name="resultSetColumn">revenue_Group3/year</property>
> </data>
> </property>
> </extended-item>
> <extended-item extensionName="AggregationCell"
> id="111">
> <property
> name="aggregationOnRow">Group3/quarter</property>
> <property
> name="backgroundColor">#E1FABC</property>
> <property name="content">
> <data id="112">
> <structure name="numberFormat">
> <property
> name="category">Currency</property>
> <property
> name="pattern">$#,##0</property>
> </structure>
> <property
> name="textAlign">right</property>
> <property
> name="resultSetColumn">revenue_Group3/quarter</property>
> </data>
> <data id="117">
> <list-property name="visibility">
> <structure>
> <property
> name="format">all</property>
> <expression
> name="valueExpr">true</expression>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">dummy</property>
> </data>
> </property>
> </extended-item>
> <extended-item extensionName="AggregationCell"
> id="113">
> <property
> name="backgroundColor">#E1FABC</property>
> <property name="content">
> <data id="114">
> <property
> name="fontWeight">bold</property>
> <property
> name="borderBottomColor">#000000</property>
> <property
> name="borderBottomStyle">solid</property>
> <property
> name="borderBottomWidth">1px</property>
> <property
> name="borderLeftColor">#000000</property>
> <property
> name="borderLeftStyle">solid</property>
> <property
> name="borderLeftWidth">1px</property>
> <property
> name="borderRightColor">#000000</property>
> <property
> name="borderRightStyle">solid</property>
> <property
> name="borderRightWidth">1px</property>
> <property
> name="borderTopColor">#000000</property>
> <property
> name="borderTopStyle">solid</property>
> <property
> name="borderTopWidth">1px</property>
> <structure name="numberFormat">
> <property
> name="category">Currency</property>
> <property
> name="pattern">$#,##0</property>
> </structure>
> <property
> name="textAlign">right</property>
> <property
> name="resultSetColumn">revenue_1</property>
> </data>
> </property>
> </extended-item>
> </property>
> <property name="header">
> <extended-item extensionName="CrosstabCell"
> id="93">
> <property
> name="backgroundColor">#808000</property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> <property name="rows">
> <extended-item extensionName="CrosstabView" id="86">

Report message to a moderator

Previous Topic:Dataset parameters
Next Topic:Event handler with RCP Report Designer ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 12:45:31 GMT 2024

Powered by FUDForum. Page generated in 0.03390 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