Eclipse Community Forums: BIRT

Home » Archived » BIRT » Group Row Number

Wed, 07 February 2007 14:15

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

I am trying to get the group row number so that I can alternate the colors
at the group level. here is my heirarchy

Department - Group1
Account - Group2
Service Code - Group3

At each level there is a layout that I have created that has mulitple rows
that need alternate colors for readablitlity. I am trying to use
Total.runningSum(1,null,1)%2 = 1 to get the highlighting working. It
appears to be working for the first group but group 2 it doesn't work. I
put a field in that group row and output the value and I get the following
numbers 1,3,6,8,11,13,15,18,21....According to the postings I found
Total.runningSum(1,null,1) should work. Can someone give me the right
syntax to get the relative group number for a group? For each record set
in the group i want it to start renumbering.

Re: Group Row Number [message #217956 is a reply to message #217571]

Thu, 08 February 2007 12:45

Eclipse User

The third parameter in the Total.runningSum is the group level. You have it
set to one. Can you try removing it and set the aggregate on to the
specific group (ie Group 1, Group 2 etc)

Jason

"Niraj Patel" <niraj.patel@spectrum-sg.com> wrote in message
news:61cfaaf636d863fca0ce13c3b69b07dc$1@www.eclipse.org...
>I am trying to get the group row number so that I can alternate the colors
>at the group level. here is my heirarchy
>
> Department - Group1
> Account - Group2
> Service Code - Group3
>
> At each level there is a layout that I have created that has mulitple rows
> that need alternate colors for readablitlity. I am trying to use
> Total.runningSum(1,null,1)%2 = 1 to get the highlighting working. It
> appears to be working for the first group but group 2 it doesn't work. I
> put a field in that group row and output the value and I get the following
> numbers 1,3,6,8,11,13,15,18,21....According to the postings I found
> Total.runningSum(1,null,1) should work. Can someone give me the right
> syntax to get the relative group number for a group? For each record set
> in the group i want it to start renumbering.
>
>

Re: Group Row Number [message #217972 is a reply to message #217956]

Thu, 08 February 2007 13:02

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

Jason,

I am trying to alternate colors at the group level. The aggregate is
already set on the data element for each grouped section. How do
highlight a specific Row of group data using alternate colors for each
set? I am clicking the row and then going to the Highlights and putting
in the formula. What should that formula be so that I can get the group
level number and %2 so that I can get even odd numbers for alternate
coloring?

Niraj

Re: Group Row Number [message #217988 is a reply to message #217972]

Thu, 08 February 2007 13:21

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

Sorry,

I meant to say alternate colors inside of each group set.

Niraj

Re: Group Row Number [message #217995 is a reply to message #217972]

Thu, 08 February 2007 13:28

Eclipse User

Try using the table column name that has the aggregate expression. So if
you have three groups on the table,
you will have three bound columns with the same expression, but the
aggregate on field will be set to the specific group.
Then in the highlight on the row you should be able to specify the specific
table column (no a data set column).

Jason

"Niraj Patel" <niraj.patel@spectrum-sg.com> wrote in message
news:8899675eaf8fd0207de9c7abe3a1f450$1@www.eclipse.org...
> Jason,
>
> I am trying to alternate colors at the group level. The aggregate is
> already set on the data element for each grouped section. How do
> highlight a specific Row of group data using alternate colors for each
> set? I am clicking the row and then going to the Highlights and putting
> in the formula. What should that formula be so that I can get the group
> level number and %2 so that I can get even odd numbers for alternate
> coloring?
>
> Niraj

Re: Group Row Number [message #218004 is a reply to message #217995]

Thu, 08 February 2007 13:34

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

Can you give me an example of what the syntax would look like? Would it
be something like this?

Total.runningSum(1,null, "Department") %2

Also, Im not sure what you mean by setting the aggregate on the column. I
set an aggregate on the data element that I am grouping on. here is some
sample output.

DEPT AMOUNT
OPERATING ROOM $62,842
STC LAB $28
NITRIC OXIDE $375
HOSPITAL $53

Total $63,298

Now this is the first layout with only one grouping. The aggregate is set
to department and I am summing up the amounts by departments. I want to
alternate coloring on each department.

Niraj

Re: Group Row Number [message #218022 is a reply to message #218004]

Thu, 08 February 2007 14:13

Eclipse User

Creating an example for this scenario is tough using the sample db, but this
example should help.
Look at the group 2 column in the data binding for the table. It just
counts up rows on the nested group.
I then use this in the hightlight rule for the row. You will notice that
only rows with more that one value are alternated.

Jason

<?xml version="1.0" encoding="UTF-8"?>



<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">

<property name="createdBy">Eclipse BIRT Designer Version
2.1.1.v20060922-1058 Build <20060926-0959></property>

<property name="units">in</property>

<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>

<data-sources>

<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="Data Source" id="4">

<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="Data Set" id="5">

<structure name="cachedMetaData">

<list-property name="resultSet">

<structure>

<property name="position">1</property>

<property name="name">CUSTOMERNUMBER</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">2</property>

<property name="name">CUSTOMERNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">3</property>

<property name="name">CONTACTLASTNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">4</property>

<property name="name">CONTACTFIRSTNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">5</property>

<property name="name">PHONE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">6</property>

<property name="name">ADDRESSLINE1</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">7</property>

<property name="name">ADDRESSLINE2</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">8</property>

<property name="name">CITY</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">9</property>

<property name="name">STATE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">10</property>

<property name="name">POSTALCODE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">11</property>

<property name="name">COUNTRY</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">12</property>

<property name="name">SALESREPEMPLOYEENUMBER</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">13</property>

<property name="name">CREDITLIMIT</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">CUSTOMERNUMBER</property>

<property name="nativeName">CUSTOMERNUMBER</property>

<property name="dataType">integer</property>

<property name="nativeDataType">4</property>

</structure>

<structure>

<property name="position">2</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">3</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">4</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">5</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">6</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">7</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">8</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">9</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">10</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">11</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">12</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">13</property>

<property name="name">CREDITLIMIT</property>

<property name="nativeName">CREDITLIMIT</property>

<property name="dataType">float</property>

<property name="nativeDataType">8</property>

</structure>

</list-property>

<property name="queryText">select *

from Customers</property>

<xml-property name="designerValues"><![CDATA[<?xml version="1.0"
encoding="UTF-8"?>

<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">

<Version>1.0</Version>

<design:ResultSets derivedMetaData="true">

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTLASTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTFIRSTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PHONE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE1</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE2</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CITY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>STATE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>POSTALCODE</design:label>

<design:formattingHints>

<design:displaySize>15</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>COUNTRY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>SALESREPEMPLOYEENUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CREDITLIMIT</design:label>

<design:formattingHints>

<design:displaySize>22</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

</design:ResultSets>

</model:DesignValues>]]></xml-property>

</oda-data-set>

</data-sets>

<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>

<table id="37">

<property name="width">100%</property>

<property name="dataSet">Data Set</property>

<list-property name="boundDataColumns">

<structure>

<property name="name">CUSTOMERNUMBER</property>

<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">CUSTOMERNAME</property>

<expression name="expression">dataSetRow["CUSTOMERNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CONTACTLASTNAME</property>

<expression name="expression">dataSetRow["CONTACTLASTNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CONTACTFIRSTNAME</property>

<expression name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">PHONE</property>

<expression name="expression">dataSetRow["PHONE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">ADDRESSLINE1</property>

<expression name="expression">dataSetRow["ADDRESSLINE1"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">ADDRESSLINE2</property>

<expression name="expression">dataSetRow["ADDRESSLINE2"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CITY</property>

<expression name="expression">dataSetRow["CITY"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">STATE</property>

<expression name="expression">dataSetRow["STATE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">POSTALCODE</property>

<expression name="expression">dataSetRow["POSTALCODE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">COUNTRY</property>

<expression name="expression">dataSetRow["COUNTRY"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">SALESREPEMPLOYEENUMBER</property>

<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">CREDITLIMIT</property>

<expression name="expression">dataSetRow["CREDITLIMIT"]</expression >

<property name="dataType">float</property>

</structure>

<structure>

<property name="name">group2</property>

<expression name="expression">Total.runningCount()</expression>

<property name="dataType">any</property>

<property name="aggregateOn">NewTableGroup2</property>

</structure>

<structure>

<property name="name">data item</property>

<expression name="expression">row["group2"]</expression>

<property name="dataType">any</property>

</structure>

</list-property>

<column id="154"/>

<column id="146"/>

<column id="106"/>

<column id="107"/>

<column id="118"/>

<header>

<row id="38">

<cell id="147"/>

<cell id="139"/>

<cell id="39">

<label id="40">

<text-property name="text">CUSTOMERNUMBER</text-property>

</label>

</cell>

<cell id="41">

<label id="42">

<text-property name="text">CUSTOMERNAME</text-property>

</label>

</cell>

<cell id="63">

<label id="64">

<text-property name="text">CREDITLIMIT</text-property>

</label>

</cell>

</row>

</header>

<group id="119">

<property name="groupName">NewTableGroup1</property>

<property name="interval">none</property>

<property name="sortDirection">asc</property>

<expression name="keyExpr">row["COUNTRY"]</expression>

<property name="repeatHeader">true</property>

<property name="hideDetail">false</property>

<property name="pageBreakAfter">auto</property>

<property name="pageBreakBefore">auto</property>

<header>

<row id="120">

<cell id="148">

<data id="128">

<property name="resultSetColumn">COUNTRY</property>

</data>

</cell>

<cell id="140"/>

<cell id="121"/>

<cell id="122"/>

<cell id="123"/>

</row>

</header>

<footer>

<row id="124">

<cell id="152"/>

<cell id="144"/>

<cell id="125"/>

<cell id="126"/>

<cell id="127"/>

</row>

</footer>

</group>

<group id="129">

<property name="groupName">NewTableGroup2</property>

<property name="interval">none</property>

<property name="sortDirection">asc</property>

<expression name="keyExpr">row["CITY"]</expression>

<property name="repeatHeader">true</property>

<property name="hideDetail">false</property>

<property name="pageBreakAfter">auto</property>

<property name="pageBreakBefore">auto</property>

<header>

<row id="130">

<cell id="149"/>

<cell id="141">

<data id="138">

<property name="resultSetColumn">CITY</property>

</data>

</cell>

<cell id="131"/>

<cell id="132"/>

<cell id="133"/>

</row>

</header>

<footer>

<row id="134">

<cell id="151"/>

<cell id="143"/>

<cell id="135"/>

<cell id="136"/>

<cell id="137"/>

</row>

</footer>

</group>

<detail>

<row id="65">

<list-property name="highlightRules">

<structure>

<property name="operator">eq</property>

<property name="backgroundColor">#FFFF80</property>

<expression name="testExpr">row["group2"]%2</expression>

<expression name="value1">0</expression>

</structure>

</list-property>

<cell id="150">

<data id="161">

<property name="resultSetColumn">data item</property>

</data>

</cell>

<cell id="142"/>

<cell id="66">

<data id="67">

<property name="resultSetColumn">CUSTOMERNUMBER</property>

</data>

</cell>

<cell id="68">

<data id="69">

<property name="resultSetColumn">CUSTOMERNAME</property>

</data>

</cell>

<cell id="90">

<data id="91">

<property name="resultSetColumn">CREDITLIMIT</property>

</data>

</cell>

</row>

</detail>

<footer>

<row id="92">

<cell id="153"/>

<cell id="145"/>

<cell id="93"/>

<cell id="94"/>

<cell id="105"/>

</row>

</footer>

</table>

</body>

</report>

"Niraj Patel" <niraj.patel@spectrum-sg.com> wrote in message
news:b981ef1bfb628c12c01562b706434464$1@www.eclipse.org...
> Can you give me an example of what the syntax would look like? Would it
> be something like this?
>
> Total.runningSum(1,null, "Department") %2
>
> Also, Im not sure what you mean by setting the aggregate on the column. I
> set an aggregate on the data element that I am grouping on. here is some
> sample output.
>
> DEPT AMOUNT OPERATING ROOM $62,842 STC LAB $28
> NITRIC OXIDE $375 HOSPITAL $53 Total $63,298
> Now this is the first layout with only one grouping. The aggregate is set
> to department and I am summing up the amounts by departments. I want to
> alternate coloring on each department.
>
> Niraj
>

Re: Group Row Number [message #218028 is a reply to message #218022]

Thu, 08 February 2007 14:34

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

Can you put instructions on how to do this within the reporting UI? I'm
not familiar with XML. Thanks!

Re: Group Row Number [message #218033 is a reply to message #218028]

Thu, 08 February 2007 14:52

Eclipse User

You can just create a new report, select the xml source tab and replace the
xml with the one in the post.

Jason

"Niraj Patel" <niraj.patel@spectrum-sg.com> wrote in message
news:60cb5c3aada6336616a5e848b384fdaf$1@www.eclipse.org...
> Can you put instructions on how to do this within the reporting UI? I'm
> not familiar with XML. Thanks!
>

Re: Group Row Number [message #218041 is a reply to message #218033]

Thu, 08 February 2007 14:58

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

Your condition highlight is on a Detail level row. I do not have any data
at the detail level. I need the condition highlight to be on the group
row. That example does not show that functionality. What I need is the
row number in the current group. So basically I am highlighting the group
row and trying to put a condition for highlighting on that.

Re: Group Row Number [message #218063 is a reply to message #218041]

Thu, 08 February 2007 16:57

Eclipse User

Maybe I am confused at what you want, but here is the same report doing a
highling on the group2 header.

Jason

<?xml version="1.0" encoding="UTF-8"?>



<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">

<property name="createdBy">Eclipse BIRT Designer Version
2.1.1.v20060922-1058 Build <20060926-0959></property>

<property name="units">in</property>

<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>

<data-sources>

<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="Data Source" id="4">

<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="Data Set" id="5">

<structure name="cachedMetaData">

<list-property name="resultSet">

<structure>

<property name="position">1</property>

<property name="name">CUSTOMERNUMBER</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">2</property>

<property name="name">CUSTOMERNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">3</property>

<property name="name">CONTACTLASTNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">4</property>

<property name="name">CONTACTFIRSTNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">5</property>

<property name="name">PHONE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">6</property>

<property name="name">ADDRESSLINE1</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">7</property>

<property name="name">ADDRESSLINE2</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">8</property>

<property name="name">CITY</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">9</property>

<property name="name">STATE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">10</property>

<property name="name">POSTALCODE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">11</property>

<property name="name">COUNTRY</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">12</property>

<property name="name">SALESREPEMPLOYEENUMBER</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">13</property>

<property name="name">CREDITLIMIT</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">CUSTOMERNUMBER</property>

<property name="nativeName">CUSTOMERNUMBER</property>

<property name="dataType">integer</property>

<property name="nativeDataType">4</property>

</structure>

<structure>

<property name="position">2</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">3</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">4</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">5</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">6</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">7</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">8</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">9</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">10</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">11</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">12</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">13</property>

<property name="name">CREDITLIMIT</property>

<property name="nativeName">CREDITLIMIT</property>

<property name="dataType">float</property>

<property name="nativeDataType">8</property>

</structure>

</list-property>

<property name="queryText">select *

from Customers</property>

<xml-property name="designerValues"><![CDATA[<?xml version="1.0"
encoding="UTF-8"?>

<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">

<Version>1.0</Version>

<design:ResultSets derivedMetaData="true">

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTLASTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTFIRSTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PHONE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE1</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE2</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CITY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>STATE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>POSTALCODE</design:label>

<design:formattingHints>

<design:displaySize>15</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>COUNTRY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>SALESREPEMPLOYEENUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CREDITLIMIT</design:label>

<design:formattingHints>

<design:displaySize>22</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

</design:ResultSets>

</model:DesignValues>]]></xml-property>

</oda-data-set>

</data-sets>

<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>

<table id="37">

<property name="width">100%</property>

<property name="dataSet">Data Set</property>

<list-property name="boundDataColumns">

<structure>

<property name="name">CUSTOMERNUMBER</property>

<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">CUSTOMERNAME</property>

<expression name="expression">dataSetRow["CUSTOMERNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CONTACTLASTNAME</property>

<expression name="expression">dataSetRow["CONTACTLASTNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CONTACTFIRSTNAME</property>

<expression name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">PHONE</property>

<expression name="expression">dataSetRow["PHONE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">ADDRESSLINE1</property>

<expression name="expression">dataSetRow["ADDRESSLINE1"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">ADDRESSLINE2</property>

<expression name="expression">dataSetRow["ADDRESSLINE2"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CITY</property>

<expression name="expression">dataSetRow["CITY"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">STATE</property>

<expression name="expression">dataSetRow["STATE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">POSTALCODE</property>

<expression name="expression">dataSetRow["POSTALCODE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">COUNTRY</property>

<expression name="expression">dataSetRow["COUNTRY"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">SALESREPEMPLOYEENUMBER</property>

<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">CREDITLIMIT</property>

<expression name="expression">dataSetRow["CREDITLIMIT"]</expression >

<property name="dataType">float</property>

</structure>

<structure>

<property name="name">group2</property>

<expression name="expression">Total.runningCount()</expression>

<property name="dataType">any</property>

<property name="aggregateOn">NewTableGroup2</property>

</structure>

<structure>

<property name="name">data item</property>

<expression name="expression">row["group2"]</expression>

<property name="dataType">any</property>

</structure>

<structure>

<property name="name">group1</property>

<expression name="expression">Total.runningCount()</expression>

<property name="dataType">any</property>

<property name="aggregateOn">NewTableGroup1</property>

</structure>

<structure>

<property name="name">data item_1</property>

<expression name="expression">row["group1"]</expression>

<property name="dataType">any</property>

</structure>

</list-property>

<column id="154"/>

<column id="146"/>

<column id="106"/>

<column id="107"/>

<column id="118"/>

<header>

<row id="38">

<cell id="147"/>

<cell id="139"/>

<cell id="39">

<label id="40">

<text-property name="text">CUSTOMERNUMBER</text-property>

</label>

</cell>

<cell id="41">

<label id="42">

<text-property name="text">CUSTOMERNAME</text-property>

</label>

</cell>

<cell id="63">

<label id="64">

<text-property name="text">CREDITLIMIT</text-property>

</label>

</cell>

</row>

</header>

<group id="119">

<property name="groupName">NewTableGroup1</property>

<property name="interval">none</property>

<property name="sortDirection">asc</property>

<expression name="keyExpr">row["COUNTRY"]</expression>

<property name="repeatHeader">true</property>

<property name="hideDetail">false</property>

<property name="pageBreakAfter">auto</property>

<property name="pageBreakBefore">auto</property>

<header>

<row id="120">

<cell id="148">

<data id="128">

<property name="resultSetColumn">COUNTRY</property>

</data>

</cell>

<cell id="140"/>

<cell id="121"/>

<cell id="122"/>

<cell id="123"/>

</row>

</header>

<footer>

<row id="124">

<cell id="152"/>

<cell id="144"/>

<cell id="125"/>

<cell id="126"/>

<cell id="127"/>

</row>

</footer>

</group>

<group id="129">

<property name="groupName">NewTableGroup2</property>

<property name="interval">none</property>

<property name="sortDirection">asc</property>

<expression name="keyExpr">row["CITY"]</expression>

<property name="repeatHeader">true</property>

<property name="hideDetail">false</property>

<property name="pageBreakAfter">auto</property>

<property name="pageBreakBefore">auto</property>

<header>

<row id="130">

<list-property name="highlightRules">

<structure>

<property name="operator">eq</property>

<property name="backgroundColor">#C0C0C0</property>

<expression name="testExpr">row["group1"]%2</expression>

<expression name="value1">0</expression>

</structure>

</list-property>

<cell id="149">

<data id="162">

<property name="resultSetColumn">data item_1</property>

</data>

</cell>

<cell id="141">

<data id="138">

<property name="resultSetColumn">CITY</property>

</data>

</cell>

<cell id="131"/>

<cell id="132"/>

<cell id="133"/>

</row>

</header>

<footer>

<row id="134">

<cell id="151"/>

<cell id="143"/>

<cell id="135"/>

<cell id="136"/>

<cell id="137"/>

</row>

</footer>

</group>

<detail>

<row id="65">

<list-property name="highlightRules">

<structure>

<property name="operator">eq</property>

<property name="backgroundColor">#FFFF80</property>

<expression name="testExpr">row["group2"]%2</expression>

<expression name="value1">0</expression>

</structure>

</list-property>

<cell id="150">

<data id="161">

<property name="resultSetColumn">data item</property>

</data>

</cell>

<cell id="142"/>

<cell id="66">

<data id="67">

<property name="resultSetColumn">CUSTOMERNUMBER</property>

</data>

</cell>

<cell id="68">

<data id="69">

<property name="resultSetColumn">CUSTOMERNAME</property>

</data>

</cell>

<cell id="90">

<data id="91">

<property name="resultSetColumn">CREDITLIMIT</property>

</data>

</cell>

</row>

</detail>

<footer>

<row id="92">

<cell id="153"/>

<cell id="145"/>

<cell id="93"/>

<cell id="94"/>

<cell id="105"/>

</row>

</footer>

</table>

</body>

</report>

"Niraj Patel" <niraj.patel@spectrum-sg.com> wrote in message
news:1fb59aa575b5ab175f0dadd9e02ca1d5$1@www.eclipse.org...
> Your condition highlight is on a Detail level row. I do not have any data
> at the detail level. I need the condition highlight to be on the group
> row. That example does not show that functionality. What I need is the
> row number in the current group. So basically I am highlighting the group
> row and trying to put a condition for highlighting on that.
>

Re: Group Row Number [message #218235 is a reply to message #218063]

Fri, 09 February 2007 14:39

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

Jason,

I got the version you sent me to work. I altered the layout a bit but
when I match the layout on the other report it doesnt work. I still get
numbering that is 1,3,6,8,11, etc...Here is the code to my current layout
report.

<?xml version="1.0" encoding="UTF-8"?>

<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.1.1.v20060922-1058 Build <20060926-0959></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>
<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>
<table id="104">
<property name="borderBottomColor">#E0F2FE</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#E0F2FE</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#E0F2FE</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#E0F2FE</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr">params["Department"] ==
false || params["Account_No"] == false
|| params["Service_Code"] == true</expression>
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">DEPARTMENT</property>
<expression
name="expression">dataSetRow["DEPARTMENT"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">SERVICECODE</property>
<expression
name="expression">dataSetRow["SERVICECODE"]</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Account_AMOUNT</property>
<expression
name="expression">Total.sum(dataSetRow["AMOUNT"])</expression >
<property name="dataType">decimal</property>
<property name="aggregateOn">Account</property>
</structure>
<structure>
<property name="name">ACCTNO</property>
<expression
name="expression">dataSetRow["ACCTNO"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">AMOUNT</property>
<expression
name="expression">Total.sum(dataSetRow["AMOUNT"])</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">DEPTNAME</property>
<expression
name="expression">dataSetRow["DEPTNAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">group1</property>
<expression
name="expression">Total.runningCount()</expression>
<property name="dataType">integer</property>
<property name="aggregateOn">Department</property>
</structure>
<structure>
<property name="name">group2</property>
<expression
name="expression">Total.runningCount()</expression>
<property name="dataType">integer</property>
<property name="aggregateOn">Account</property>
</structure>
<structure>
<property name="name">data item</property>
<expression
name="expression">row["group1"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<column id="117">
<property name="width">1.1354166667in</property>
</column>
<column id="118">
<property name="width">0.96875in</property>
</column>
<column id="119"/>
<header>
<row id="1867">
<property name="style">border</property>
<property name="fontFamily">"Verdana"</property>
<property name="fontWeight">bold</property>
<cell id="1868">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property
name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property
name="borderBottomWidth">medium</property>
<label id="1871">
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Financial Impact of
Errors</text-property>
</label>
</cell>
</row>
<row id="105">
<property name="style">columntitles</property>
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10px</property>
<property name="fontWeight">bold</property>
<property name="textUnderline">underline</property>
<cell id="106">
<label id="1762">
<property name="fontWeight">bold</property>
<property
name="textUnderline">underline</property>
<text-property name="text">DEPT</text-property>
</label>
</cell>
<cell id="107">
<label id="127">
<text-property
name="text">ACCTNO</text-property>
</label>
</cell>
<cell id="108">
<label id="125">
<text-property
name="text">AMOUNT</text-property>
</label>
</cell>
</row>
</header>
<group id="129">
<property name="groupName">Department</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["DEPARTMENT"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="130">
<property name="backgroundColor">#0080C0</property>
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">12px</property>
<property name="color">#FFFFFF</property>
<cell id="131">
<data id="2062">
<property
name="resultSetColumn">DEPTNAME</property>
</data>
</cell>
<cell id="132"/>
<cell id="133"/>
</row>
</header>
<footer>
<row id="134">
<cell id="135"/>
<cell id="136"/>
<cell id="137"/>
</row>
</footer>
</group>
<group id="139">
<property name="groupName">Account</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["ACCTNO"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="140">
<property name="style">fielddata</property>
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<property
name="backgroundColor">#E0F2FE</property>
<expression
name="testExpr">Total.runningSum(1,null, "AMOUNT") %2</expression>
<expression name="value1">1</expression>
</structure>
</list-property>
<cell id="141">
<data id="2083">
<property name="resultSetColumn">data
item</property>
</data>
</cell>
<cell id="142">
<data id="148">
<property
name="resultSetColumn">ACCTNO</property>
</data>
</cell>
<cell id="143">
<data id="126">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">$#,##0</property>
</structure>
<property
name="textAlign">center</property>
<property
name="resultSetColumn">Account_AMOUNT</property>
</data>
</cell>
</row>
</header>
<footer>
<row id="144">
<cell id="145"/>
<cell id="146"/>
<cell id="147"/>
</row>
</footer>
</group>
<detail>
<row id="109">
<cell id="110"/>
<cell id="111"/>
<cell id="112"/>
</row>
</detail>
<footer>
<row id="113">
<cell id="114">
<label id="1797">
<property name="fontWeight">bold</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property
name="borderTopWidth">medium</property>
<text-property
name="text">Total</text-property>
</label>
</cell>
<cell id="115"/>
<cell id="116">
<data id="150">
<property name="fontWeight">bold</property>
<property
name="textUnderline">underline</property>
<property
name="borderTopColor">#000000</property>
<property
name="borderTopStyle">solid</property>
<property
name="borderTopWidth">medium</property>
<structure name="numberFormat">
<property
name="category">Currency</property>
<property name="pattern">$#,##0</property>
</structure>
<property
name="resultSetColumn">AMOUNT</property>
</data>
</cell>
</row>
</footer>
</table>
</body>
</report>

And here is the code to yours that I altered.

<?xml version="1.0" encoding="UTF-8"?>

<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.1.1.v20060922-1058 Build <20060926-0959></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="4">
<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="Data Set" id="5">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</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">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</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">3</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">4</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">5</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">6</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">7</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">8</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">9</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">10</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">11</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">12</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">13</property>
<property name="name">CREDITLIMIT</property>
<property name="nativeName">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">select *

from Customers</property>
<xml-property name="designerValues"><![CDATA[<?xml
version="1.0"
encoding="UTF-8"?>

<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">

<Version>1.0</Version>

<design:ResultSets derivedMetaData="true">

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTLASTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTFIRSTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PHONE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE1</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE2</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CITY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>STATE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>POSTALCODE</design:label>

<design:formattingHints>

<design:displaySize>15</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>COUNTRY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>SALESREPEMPLOYEENUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CREDITLIMIT</design:label>

<design:formattingHints>

<design:displaySize>22</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

</design:ResultSets>

</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<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>
<table id="37">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CREDITLIMIT</property>
<expression
name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">group2</property>
<expression
name="expression">Total.runningCount()</expression>
<property name="dataType">any</property>
<property name="aggregateOn">NewTableGroup2</property>
</structure>
<structure>
<property name="name">data item</property>
<expression
name="expression">row["group2"]</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">group1</property>
<expression
name="expression">Total.runningCount()</expression>
<property name="dataType">any</property>
<property name="aggregateOn">NewTableGroup1</property>
</structure>
<structure>
<property name="name">data item_1</property>
<expression
name="expression">row["group1"]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<column id="154"/>
<column id="146"/>
<column id="106"/>
<column id="107"/>
<column id="118"/>
<header>
<row id="38">
<cell id="147"/>
<cell id="139"/>
<cell id="39">
<label id="40">
<text-property
name="text">CUSTOMERNUMBER</text-property>
</label>
</cell>
<cell id="41">
<label id="42">
<text-property
name="text">CUSTOMERNAME</text-property>
</label>
</cell>
<cell id="63">
<label id="64">
<text-property
name="text">CREDITLIMIT</text-property>
</label>
</cell>
</row>
</header>
<group id="119">
<property name="groupName">NewTableGroup1</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["COUNTRY"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="120">
<cell id="148">
<data id="128">
<property
name="resultSetColumn">COUNTRY</property>
</data>
</cell>
<cell id="140"/>
<cell id="121"/>
<cell id="122"/>
<cell id="123"/>
</row>
</header>
<footer>
<row id="124">
<cell id="152"/>
<cell id="144"/>
<cell id="125"/>
<cell id="126"/>
<cell id="127"/>
</row>
</footer>
</group>
<group id="129">
<property name="groupName">NewTableGroup2</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["CITY"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="130">
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>

Re: Group Row Number [message #218248 is a reply to message #218063]

Fri, 09 February 2007 14:48

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

On a second look at this code. The number is off here too. Cut and paste
this into a report. This is your report altered to be at the level of
grouping that I am using. If you sccroll down further into the report the
numbering starts to skip.

<?xml version="1.0" encoding="UTF-8"?>

<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.1.1.v20060922-1058 Build <20060926-0959></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="4">
<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="Data Set" id="5">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</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">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</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">3</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">4</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">5</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">6</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">7</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">8</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">9</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">10</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">11</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">12</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">13</property>
<property name="name">CREDITLIMIT</property>
<property name="nativeName">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">select *

from Customers</property>
<xml-property name="designerValues"><![CDATA[<?xml
version="1.0"
encoding="UTF-8"?>

<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">

<Version>1.0</Version>

<design:ResultSets derivedMetaData="true">

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTLASTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTFIRSTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PHONE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE1</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE2</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CITY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>STATE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>POSTALCODE</design:label>

<design:formattingHints>

<design:displaySize>15</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>COUNTRY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>SALESREPEMPLOYEENUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CREDITLIMIT</design:label>

<design:formattingHints>

<design:displaySize>22</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

</design:ResultSets>

</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<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>
<table id="37">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CREDITLIMIT</property>
<expression
name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">group2</property>
<expression
name="expression">Total.runningCount()</expression>
<property name="dataType">any</property>
<property name="aggregateOn">NewTableGroup2</property>
</structure>
<structure>
<property name="name">data item</property>
<expression
name="expression">row["group2"]</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">group1</property>
<expression
name="expression">Total.runningCount()</expression>
<property name="dataType">any</property>
<property name="aggregateOn">NewTableGroup1</property>
</structure>
<structure>
<property name="name">data item_1</property>
<expression
name="expression">row["group1"]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<column id="154"/>
<column id="146"/>
<column id="106"/>
<column id="107"/>
<column id="118"/>
<header>
<row id="38">
<cell id="147"/>
<cell id="139"/>
<cell id="39">
<label id="40">
<text-property
name="text">CUSTOMERNUMBER</text-property>
</label>
</cell>
<cell id="41">
<label id="42">
<text-property
name="text">CUSTOMERNAME</text-property>
</label>
</cell>
<cell id="63">
<label id="64">
<text-property
name="text">CREDITLIMIT</text-property>
</label>
</cell>
</row>
</header>
<group id="119">
<property name="groupName">NewTableGroup1</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["COUNTRY"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="120">
<cell id="148">
<data id="128">
<property
name="resultSetColumn">COUNTRY</property>
</data>
</cell>
<cell id="140"/>
<cell id="121"/>
<cell id="122"/>
<cell id="123"/>
</row>
</header>
<footer>
<row id="124">
<cell id="152"/>
<cell id="144"/>
<cell id="125"/>
<cell id="126"/>
<cell id="127"/>
</row>
</footer>
</group>
<group id="129">
<property name="groupName">NewTableGroup2</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["CITY"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="130">
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<property
name="backgroundColor">#C0C0C0</property>
<expression
name="testExpr">row["group1"]%2</expression>
<expression name="value1">0</expression>
</structure>
</list-property>
<cell id="149">
<data id="162">
<property name="resultSetColumn">data
item_1</property>
</data>
</cell>
<cell id="141">
<data id="138">
<property
name="resultSetColumn">CITY</property>
</data>
</cell>
<cell id="131">
<data id="67">
<property
name="resultSetColumn">CUSTOMERNUMBER</property>
</data>
</cell>
<cell id="132">
<data id="69">
<property
name="resultSetColumn">CUSTOMERNAME</property>
</data>
</cell>
<cell id="133">
<data id="91">
<property
name="resultSetColumn">CREDITLIMIT</property>
</data>
</cell>
</row>
</header>
<footer>
<row id="134">
<cell id="151"/>
<cell id="143"/>
<cell id="135"/>
<cell id="136"/>
<cell id="137"/>
</row>
</footer>
</group>
<detail>
<row id="65">
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<property
name="backgroundColor">#FFFF80</property>
<expression
name="testExpr">row["group2"]%2</expression>
<expression name="value1">0</expression>
</structure>
</list-property>
<cell id="150"/>
<cell id="142"/>
<cell id="66"/>
<cell id="68"/>
<cell id="90"/>
</row>
</detail>
<footer>
<row id="92">
<cell id="153"/>
<cell id="145"/>
<cell id="93"/>
<cell id="94"/>
<cell id="105"/>
</row>
</footer>
</table>
</body>
</report>

Re: Group Row Number [message #218264 is a reply to message #218063]

Fri, 09 February 2007 15:00

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

One more random comment. Could the gaps in my numbering be caused by the
fact that I'm grouping and then I'm using parameters to filter out what is
shown? Is there a way around it?

niraj

Re: Group Row Number [message #218499 is a reply to message #218264]

Mon, 12 February 2007 10:46

Eclipse User

Can you post the entire report again?

Jason

"Niraj Patel" <niraj.patel@spectrum-sg.com> wrote in message
news:b1c557783cbca43de1c94f4ac7ffe0c6$1@www.eclipse.org...
> One more random comment. Could the gaps in my numbering be caused by the
> fact that I'm grouping and then I'm using parameters to filter out what is
> shown? Is there a way around it?
>
> niraj
>

Re: Group Row Number [message #218523 is a reply to message #218499]

Mon, 12 February 2007 12:04

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

Below is the altered source code from your report that highlights at the
group level. Notice that when you preview the report the numbering at
each grouping starts to get off. I'm having the exact same issue in my
report. I dont have any gaps in my data either.

<?xml version="1.0" encoding="UTF-8"?>

<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.1.1.v20060922-1058 Build <20060926-0959></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="4">
<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="Data Set" id="5">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</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">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</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">3</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">4</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">5</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">6</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">7</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">8</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">9</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">10</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">11</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">12</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">13</property>
<property name="name">CREDITLIMIT</property>
<property name="nativeName">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">select *

from Customers</property>
<xml-property name="designerValues"><![CDATA[<?xml
version="1.0"
encoding="UTF-8"?>

<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">

<Version>1.0</Version>

<design:ResultSets derivedMetaData="true">

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTLASTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTFIRSTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PHONE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE1</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE2</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CITY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>STATE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>POSTALCODE</design:label>

<design:formattingHints>

<design:displaySize>15</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>COUNTRY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>SALESREPEMPLOYEENUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CREDITLIMIT</design:label>

<design:formattingHints>

<design:displaySize>22</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

</design:ResultSets>

</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<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>
<table id="37">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACTLASTNAME</property>
<expression
name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACTFIRSTNAME</property>
<expression
name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression
name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE1</property>
<expression
name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE2</property>
<expression
name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression
name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression
name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression
name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression
name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CREDITLIMIT</property>
<expression
name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">group2</property>
<expression
name="expression">Total.runningCount()</expression>
<property name="dataType">any</property>
<property name="aggregateOn">NewTableGroup2</property>
</structure>
<structure>
<property name="name">data item</property>
<expression
name="expression">row["group2"]</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">group1</property>
<expression
name="expression">Total.runningCount()</expression>
<property name="dataType">any</property>
<property name="aggregateOn">NewTableGroup1</property>
</structure>
<structure>
<property name="name">data item_1</property>
<expression
name="expression">row["group1"]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<column id="154"/>
<column id="146"/>
<column id="106"/>
<column id="107"/>
<column id="118"/>
<header>
<row id="38">
<cell id="147"/>
<cell id="139"/>
<cell id="39">
<label id="40">
<text-property
name="text">CUSTOMERNUMBER</text-property>
</label>
</cell>
<cell id="41">
<label id="42">
<text-property
name="text">CUSTOMERNAME</text-property>
</label>
</cell>
<cell id="63">
<label id="64">
<text-property
name="text">CREDITLIMIT</text-property>
</label>
</cell>
</row>
</header>
<group id="119">
<property name="groupName">NewTableGroup1</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["COUNTRY"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="120">
<cell id="148">
<data id="128">
<property name="fontWeight">bold</property>
<property
name="resultSetColumn">COUNTRY</property>
</data>
</cell>
<cell id="140"/>
<cell id="121"/>
<cell id="122"/>
<cell id="123"/>
</row>
</header>
<footer>
<row id="124">
<cell id="152"/>
<cell id="144"/>
<cell id="125"/>
<cell id="126"/>
<cell id="127"/>
</row>
</footer>
</group>
<group id="129">
<property name="groupName">NewTableGroup2</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["CITY"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="130">
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<property
name="backgroundColor">#C0C0C0</property>
<expression
name="testExpr">row["group1"]%2</expression>
<expression name="value1">1</expression>
</structure>
</list-property>
<cell id="149">
<data id="162">
<property name="resultSetColumn">data
item_1</property>
</data>
</cell>
<cell id="141">
<data id="138">
<property
name="resultSetColumn">CITY</property>
</data>
</cell>
<cell id="131">
<data id="67">
<property
name="resultSetColumn">CUSTOMERNUMBER</property>
</data>
</cell>
<cell id="132">
<data id="69">
<property
name="resultSetColumn">CUSTOMERNAME</property>
</data>
</cell>
<cell id="133">
<data id="91">
<property
name="resultSetColumn">CREDITLIMIT</property>
</data>
</cell>
</row>
</header>
<footer>
<row id="134">
<cell id="151"/>
<cell id="143"/>
<cell id="135"/>
<cell id="136"/>
<cell id="137"/>
</row>
</footer>
</group>
<detail>
<row id="65">
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<property
name="backgroundColor">#FFFF80</property>
<expression
name="testExpr">row["group2"]%2</expression>
<expression name="value1">0</expression>
</structure>
</list-property>
<cell id="150"/>
<cell id="142"/>
<cell id="66"/>
<cell id="68"/>
<cell id="90"/>
</row>
</detail>
<footer>
<row id="92">
<cell id="153"/>
<cell id="145"/>
<cell id="93"/>
<cell id="94"/>
<cell id="105"/>
</row>
</footer>
</table>
</body>
</report>

Re: Group Row Number [message #218561 is a reply to message #218523]

Mon, 12 February 2007 13:57

Eclipse User

I believe this may be a bug in the runningCount total. I logged a bug.
https://bugs.eclipse.org/bugs/show_bug.cgi?id=173903

Jason

"Niraj Patel" <niraj.patel@spectrum-sg.com> wrote in message
news:7cfc3670953cd38c32f689383228e14f$1@www.eclipse.org...
> Below is the altered source code from your report that highlights at the
> group level. Notice that when you preview the report the numbering at
> each grouping starts to get off. I'm having the exact same issue in my
> report. I dont have any gaps in my data either.
>
> <?xml version="1.0" encoding="UTF-8"?>
> 
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.1.1.v20060922-1058 Build <20060926-0959></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2006 <<Your Company Name
> here>></property>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="4">
> <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="Data Set" id="5">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CUSTOMERNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">CONTACTLASTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">CONTACTFIRSTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">PHONE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">ADDRESSLINE1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">ADDRESSLINE2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">CITY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">STATE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">POSTALCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">COUNTRY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property
> name="name">SALESREPEMPLOYEENUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">CREDITLIMIT</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">CUSTOMERNUMBER</property>
> <property name="nativeName">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</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">3</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">4</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">5</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">6</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">7</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">8</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">9</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">10</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">11</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">12</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">13</property>
> <property name="name">CREDITLIMIT</property>
> <property name="nativeName">CREDITLIMIT</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> </list-property>
> <property name="queryText">select *
>
> from Customers</property>
> <xml-property name="designerValues"><![CDATA[<?xml
> version="1.0" encoding="UTF-8"?>
>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
>
> <Version>1.0</Version>
>
> <design:ResultSets derivedMetaData="true">
>
> <design:resultSetDefinitions>
>
> <design:resultSetColumns>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CUSTOMERNUMBER</design:name>
>
> <design:position>1</design:position>
>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>
> <design:precision>10</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>CUSTOMERNUMBER</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>11</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CUSTOMERNAME</design:name>
>
> <design:position>2</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>CUSTOMERNAME</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CONTACTLASTNAME</design:name>
>
> <design:position>3</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>CONTACTLASTNAME</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CONTACTFIRSTNAME</design:name>
>
> <design:position>4</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>CONTACTFIRSTNAME</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>PHONE</design:name>
>
> <design:position>5</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>PHONE</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>ADDRESSLINE1</design:name>
>
> <design:position>6</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>ADDRESSLINE1</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>ADDRESSLINE2</design:name>
>
> <design:position>7</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>ADDRESSLINE2</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CITY</design:name>
>
> <design:position>8</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>CITY</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>STATE</design:name>
>
> <design:position>9</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>STATE</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>POSTALCODE</design:name>
>
> <design:position>10</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>15</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>POSTALCODE</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>15</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>COUNTRY</design:name>
>
> <design:position>11</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> <design:precision>50</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>COUNTRY</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>50</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>SALESREPEMPLOYEENUMBER</design:name>
>
> <design:position>12</design:position>
>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>
> <design:precision>10</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>SALESREPEMPLOYEENUMBER</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>11</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CREDITLIMIT</design:name>
>
> <design:position>13</design:position>
>
> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>
> <design:precision>15</design:precision>
>
> <design:scale>0</design:scale>
>
> <design:nullability>Nullable</design:nullability>
>
> </design:attributes>
>
> <design:usageHints>
>
> <design:label>CREDITLIMIT</design:label>
>
> <design:formattingHints>
>
> <design:displaySize>22</design:displaySize>
>
> </design:formattingHints>
>
> </design:usageHints>
>
> </design:resultColumnDefinitions>
>
> </design:resultSetColumns>
>
> </design:resultSetDefinitions>
>
> <design:resultSetDefinitions>
>
> <design:resultSetColumns>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CUSTOMERNUMBER</design:name>
>
> <design:position>1</design:position>
>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CUSTOMERNAME</design:name>
>
> <design:position>2</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CONTACTLASTNAME</design:name>
>
> <design:position>3</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CONTACTFIRSTNAME</design:name>
>
> <design:position>4</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>PHONE</design:name>
>
> <design:position>5</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>ADDRESSLINE1</design:name>
>
> <design:position>6</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>ADDRESSLINE2</design:name>
>
> <design:position>7</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CITY</design:name>
>
> <design:position>8</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>STATE</design:name>
>
> <design:position>9</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>POSTALCODE</design:name>
>
> <design:position>10</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>COUNTRY</design:name>
>
> <design:position>11</design:position>
>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>SALESREPEMPLOYEENUMBER</design:name>
>
> <design:position>12</design:position>
>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> <design:resultColumnDefinitions>
>
> <design:attributes>
>
> <design:name>CREDITLIMIT</design:name>
>
> <design:position>13</design:position>
>
> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>
> </design:attributes>
>
> </design:resultColumnDefinitions>
>
> </design:resultSetColumns>
>
> </design:resultSetDefinitions>
>
> </design:ResultSets>
>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <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>
> <table id="37">
> <property name="width">100%</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <expression
> name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">CUSTOMERNAME</property>
> <expression
> name="expression">dataSetRow["CUSTOMERNAME"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">CONTACTLASTNAME</property>
> <expression
> name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">CONTACTFIRSTNAME</property>
> <expression
> name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">PHONE</property>
> <expression
> name="expression">dataSetRow["PHONE"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">ADDRESSLINE1</property>
> <expression
> name="expression">dataSetRow["ADDRESSLINE1"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">ADDRESSLINE2</property>
> <expression
> name="expression">dataSetRow["ADDRESSLINE2"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">CITY</property>
> <expression
> name="expression">dataSetRow["CITY"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">STATE</property>
> <expression
> name="expression">dataSetRow["STATE"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">POSTALCODE</property>
> <expression
> name="expression">dataSetRow["POSTALCODE"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">COUNTRY</property>
> <expression
> name="expression">dataSetRow["COUNTRY"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">SALESREPEMPLOYEENUMBER</property>
> <expression
> name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">CREDITLIMIT</property>
> <expression
> name="expression">dataSetRow["CREDITLIMIT"]</expression >
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="name">group2</property>
> <expression
> name="expression">Total.runningCount()</expression>
> <property name="dataType">any</property>
> <property name="aggregateOn">NewTableGroup2</property>
> </structure>
> <structure>
> <property name="name">data item</property>
> <expression
> name="expression">row["group2"]</expression>
> <property name="dataType">any</property>
> </structure>
> <structure>
> <property name="name">group1</property>
> <expression
> name="expression">Total.runningCount()</expression>
> <property name="dataType">any</property>
> <property name="aggregateOn">NewTableGroup1</property>
> </structure>
> <structure>
> <property name="name">data item_1</property>
> <expression
> name="expression">row["group1"]</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <column id="154"/>
> <column id="146"/>
> <column id="106"/>
> <column id="107"/>
> <column id="118"/>
> <header>
> <row id="38">
> <cell id="147"/>
> <cell id="139"/>
> <cell id="39">
> <label id="40">
> <text-property
> name="text">CUSTOMERNUMBER</text-property>
> </label>
> </cell>
> <cell id="41">
> <label id="42">
> <text-property
> name="text">CUSTOMERNAME</text-property>
> </label>
> </cell>
> <cell id="63">
> <label id="64">
> <text-property
> name="text">CREDITLIMIT</text-property>
> </label>
> </cell>
> </row>
> </header>
> <group id="119">
> <property name="groupName">NewTableGroup1</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression name="keyExpr">row["COUNTRY"]</expression>
> <property name="repeatHeader">true</property>
> <property name="hideDetail">false</property>
> <property name="pageBreakAfter">auto</property>
> <property name="pageBreakBefore">auto</property>
> <header>
> <row id="120">
> <cell id="148">
> <data id="128">
> <property name="fontWeight">bold</property>
> <property
> name="resultSetColumn">COUNTRY</property>
> </data>
> </cell>
> <cell id="140"/>
> <cell id="121"/>
> <cell id="122"/>
> <cell id="123"/>
> </row>
> </header>
> <footer>
> <row id="124">
> <cell id="152"/>
> <cell id="144"/>
> <cell id="125"/>
> <cell id="126"/>
> <cell id="127"/>
> </row>
> </footer>
> </group>
> <group id="129">
> <property name="groupName">NewTableGroup2</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression name="keyExpr">row["CITY"]</expression>
> <property name="repeatHeader">true</property>
> <property name="hideDetail">false</property>
> <property name="pageBreakAfter">auto</property>
> <property name="pageBreakBefore">auto</property>
> <header>
> <row id="130">
> <list-property name="highlightRules">
> <structure>
> <property name="operator">eq</property>
> <property
> name="backgroundColor">#C0C0C0</property>
> <expression
> name="testExpr">row["group1"]%2</expression>
> <expression name="value1">1</expression>
> </structure>
> </list-property>
> <cell id="149">
> <data id="162">
> <property name="resultSetColumn">data
> item_1</property>
> </data>
> </cell>
> <cell id="141">
> <data id="138">
> <property
> name="resultSetColumn">CITY</property>
> </data>
> </cell>
> <cell id="131">
> <data id="67">
> <property
> name="resultSetColumn">CUSTOMERNUMBER</property>
> </data>
> </cell>
> <cell id="132">
> <data id="69">
> <property
> name="resultSetColumn">CUSTOMERNAME</property>
> </data>
> </cell>
> <cell id="133">
> <data id="91">
> <property
> name="resultSetColumn">CREDITLIMIT</property>
> </data>
> </cell>
> </row>
> </header>
> <footer>
> <row id="134">
> <cell id="151"/>
> <cell id="143"/>
> <cell id="135"/>
> <cell id="136"/>
> <cell id="137"/>
> </row>
> </footer>
> </group>
> <detail>
> <row id="65">
> <list-property name="highlightRules">
> <structure>
> <property name="operator">eq</property>
> <property
> name="backgroundColor">#FFFF80</property>
> <expression
> name="testExpr">row["group2"]%2</expression>
> <expression name="value1">0</expression>
> </structure>
> </list-property>
> <cell id="150"/>
> <cell id="142"/>
> <cell id="66"/>
> <cell id="68"/>
> <cell id="90"/>
> </row>
> </detail>
> <footer>
> <row id="92">
> <cell id="153"/>
> <cell id="145"/>
> <cell id="93"/>
> <cell id="94"/>
> <cell id="105"/>
> </row>
> </footer>
> </table>
> </body>
> </report>
>
>

Re: Group Row Number [message #218568 is a reply to message #218561]

Mon, 12 February 2007 14:25

Eclipse User

Originally posted by: niraj.patel.spectrum-sg.com

So there is no workaround? Are bugs fixed in future releases or is there
a patch that will become available?

Re: Group Row Number [message #218802 is a reply to message #218568]

Tue, 13 February 2007 15:21

Eclipse User

Here is a work around.
I replaced the outer running sum with a global variable. I used the inner
running sum. Look on the group header onRender event.

Jason

<?xml version="1.0" encoding="UTF-8"?>



<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">

<property name="createdBy">Eclipse BIRT Designer Version

2.1.1.v20060922-1058 Build <20060926-0959></property>

<property name="units">in</property>

<property name="comments">Copyright (c) 2006 <<Your Company Name

here>></property>

<method name="beforeFactory"><![CDATA[var tmpI =0;

importPackage(Packages.java.lang);

reportContext.setPersistentGlobalVariable("high1", new
Integer(tmpI));]]></method>

<data-sources>

<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="Data Source" id="4">

<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="Data Set" id="5">

<structure name="cachedMetaData">

<list-property name="resultSet">

<structure>

<property name="position">1</property>

<property name="name">CUSTOMERNUMBER</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">2</property>

<property name="name">CUSTOMERNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">3</property>

<property name="name">CONTACTLASTNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">4</property>

<property name="name">CONTACTFIRSTNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">5</property>

<property name="name">PHONE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">6</property>

<property name="name">ADDRESSLINE1</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">7</property>

<property name="name">ADDRESSLINE2</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">8</property>

<property name="name">CITY</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">9</property>

<property name="name">STATE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">10</property>

<property name="name">POSTALCODE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">11</property>

<property name="name">COUNTRY</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">12</property>

<property name="name">SALESREPEMPLOYEENUMBER</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">13</property>

<property name="name">CREDITLIMIT</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">CUSTOMERNUMBER</property>

<property name="nativeName">CUSTOMERNUMBER</property>

<property name="dataType">integer</property>

<property name="nativeDataType">4</property>

</structure>

<structure>

<property name="position">2</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">3</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">4</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">5</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">6</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">7</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">8</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">9</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">10</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">11</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">12</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">13</property>

<property name="name">CREDITLIMIT</property>

<property name="nativeName">CREDITLIMIT</property>

<property name="dataType">float</property>

<property name="nativeDataType">8</property>

</structure>

</list-property>

<property name="queryText">select *

from Customers</property>

<xml-property name="designerValues"><![CDATA[<?xml

version="1.0"

encoding="UTF-8"?>

<model:DesignValues

xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"

xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">

<Version>1.0</Version>

<design:ResultSets derivedMetaData="true">

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CUSTOMERNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTLASTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CONTACTFIRSTNAME</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PHONE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE1</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ADDRESSLINE2</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CITY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>STATE</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>POSTALCODE</design:label>

<design:formattingHints>

<design:displaySize>15</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>50</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>COUNTRY</design:label>

<design:formattingHints>

<design:displaySize>50</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>SALESREPEMPLOYEENUMBER</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>CREDITLIMIT</design:label>

<design:formattingHints>

<design:displaySize>22</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CUSTOMERNAME</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTLASTNAME</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CONTACTFIRSTNAME</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PHONE</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE1</design:name>

<design:position>6</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ADDRESSLINE2</design:name>

<design:position>7</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CITY</design:name>

<design:position>8</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>STATE</design:name>

<design:position>9</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>POSTALCODE</design:name>

<design:position>10</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>COUNTRY</design:name>

<design:position>11</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>SALESREPEMPLOYEENUMBER</design:name>

<design:position>12</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>CREDITLIMIT</design:name>

<design:position>13</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

</design:ResultSets>

</model:DesignValues>]]></xml-property>

</oda-data-set>

</data-sets>

<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>

<table id="37">

<property name="width">100%</property>

<property name="dataSet">Data Set</property>

<list-property name="boundDataColumns">

<structure>

<property name="name">CUSTOMERNUMBER</property>

<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">CUSTOMERNAME</property>

<expression name="expression">dataSetRow["CUSTOMERNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CONTACTLASTNAME</property>

<expression name="expression">dataSetRow["CONTACTLASTNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CONTACTFIRSTNAME</property>

<expression name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">PHONE</property>

<expression name="expression">dataSetRow["PHONE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">ADDRESSLINE1</property>

<expression name="expression">dataSetRow["ADDRESSLINE1"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">ADDRESSLINE2</property>

<expression name="expression">dataSetRow["ADDRESSLINE2"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CITY</property>

<expression name="expression">dataSetRow["CITY"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">STATE</property>

<expression name="expression">dataSetRow["STATE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">POSTALCODE</property>

<expression name="expression">dataSetRow["POSTALCODE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">COUNTRY</property>

<expression name="expression">dataSetRow["COUNTRY"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">SALESREPEMPLOYEENUMBER</property>

<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">CREDITLIMIT</property>

<expression name="expression">dataSetRow["CREDITLIMIT"]</expression >

<property name="dataType">float</property>

</structure>

<structure>

<property name="name">group2z</property>

<expression name="expression">Total.runningCount()</expression>

<property name="dataType">integer</property>

<property name="aggregateOn">NewTableGroup2</property>

</structure>

<structure>

<property name="name">data item</property>

<expression name="expression">row["group2z"]</expression>

<property name="dataType">any</property>

</structure>

<structure>

<property name="name">group1z</property>

<expression name="expression">Total.runningSum(1)</expression>

<property name="dataType">integer</property>

<property name="aggregateOn">NewTableGroup1</property>

</structure>

<structure>

<property name="name">data item_1</property>

<expression
name="expression">reportContext.getPersistentGlobalVariable( "high1");</expression>

<property name="dataType">any</property>

</structure>

<structure>

<property name="name">data item_2</property>

<property name="dataType">any</property>

</structure>

<structure>

<property name="name">data item_3</property>

<expression name="expression">Total.runningCount(null,2)</expression>

<property name="dataType">any</property>

</structure>

</list-property>

<column id="154"/>

<column id="146"/>

<column id="106"/>

<column id="107"/>

<column id="118"/>

<header>

<row id="38">

<cell id="147"/>

<cell id="139"/>

<cell id="39">

<label id="40">

<text-property name="text">CUSTOMERNUMBER</text-property>

</label>

</cell>

<cell id="41">

<label id="42">

<text-property name="text">CUSTOMERNAME</text-property>

</label>

</cell>

<cell id="63">

<label id="64">

<text-property name="text">CREDITLIMIT</text-property>

</label>

</cell>

</row>

</header>

<group id="119">

<property name="groupName">NewTableGroup1</property>

<property name="interval">none</property>

<property name="sortDirection">asc</property>

<expression name="keyExpr">row["COUNTRY"]</expression>

<property name="repeatHeader">true</property>

<property name="hideDetail">false</property>

<property name="pageBreakAfter">auto</property>

<property name="pageBreakBefore">auto</property>

<header>

<row id="120">

<cell id="148">

<data id="128">

<property name="fontWeight">bold</property>

<property name="resultSetColumn">COUNTRY</property>

</data>

</cell>

<cell id="140"/>

<cell id="121"/>

<cell id="122"/>

<cell id="123"/>

</row>

</header>

<footer>

<row id="124">

<cell id="152"/>

<cell id="144"/>

<cell id="125"/>

<cell id="126"/>

<cell id="127"/>

</row>

</footer>

</group>

<group id="129">

<property name="groupName">NewTableGroup2</property>

<property name="interval">none</property>

<property name="sortDirection">asc</property>

<expression name="keyExpr">row["CITY"]</expression>

<property name="repeatHeader">true</property>

<property name="hideDetail">false</property>

<property name="pageBreakAfter">auto</property>

<property name="pageBreakBefore">auto</property>

<header>

<row id="130">

<method name="onRender"><![CDATA[var tmpi =
parseInt(reportContext.getPersistentGlobalVariable("high1"), 10);

tmpi = tmpi + 1;

importPackage(Packages.java.lang);

reportContext.setPersistentGlobalVariable("high1", new
Integer(tmpi));]]></method>

<list-property name="highlightRules">

<structure>

<property name="operator">eq</property>

<property name="backgroundColor">#C0C0C0</property>

<expression name="testExpr">tmpV =
parseInt(reportContext.getPersistentGlobalVariable("high1"),10);

tmpV%2</expression>

<expression name="value1">1</expression>

</structure>

</list-property>

<cell id="149">

<data id="162">

<property name="resultSetColumn">data item_1</property>

</data>

</cell>

<cell id="141">

<data id="138">

<property name="resultSetColumn">CITY</property>

</data>

</cell>

<cell id="131">

<data id="67">

<property name="resultSetColumn">CUSTOMERNUMBER</property>

</data>

</cell>

<cell id="132">

<data id="69">

<property name="resultSetColumn">CUSTOMERNAME</property>

</data>

</cell>

<cell id="133">

<data id="91">

<property name="resultSetColumn">CREDITLIMIT</property>

</data>

</cell>

</row>

</header>

<footer>

<row id="134">

<cell id="151"/>

<cell id="143"/>

<cell id="135"/>

<cell id="136"/>

<cell id="137"/>

</row>

</footer>

</group>

<detail>

<row id="65">

<list-property name="highlightRules">

<structure>

<property name="operator">eq</property>

<property name="backgroundColor">#FFFF80</property>

<expression name="testExpr">Total.runningCount(null,2)%2</expression>

<expression name="value1">0</expression>

</structure>

</list-property>

<cell id="150"/>

<cell id="142">

<label id="163">

<text-property name="text">detail row</text-property>

</label>

</cell>

<cell id="66">

<data id="165">

<property name="resultSetColumn">data item_3</property>

</data>

</cell>

<cell id="68">

<data id="164">

<property name="resultSetColumn">CITY</property>

</data>

</cell>

<cell id="90"/>

</row>

</detail>

<footer>

<row id="92">

<cell id="153"/>

<cell id="145"/>

<cell id="93"/>

<cell id="94"/>

<cell id="105"/>

</row>

</footer>

</table>

</body>

</report>

"Niraj Patel" <niraj.patel@spectrum-sg.com> wrote in message
news:060fdc011d9f61be0ce8340ea5bbed21$1@www.eclipse.org...
> So there is no workaround? Are bugs fixed in future releases or is there
> a patch that will become available?
>

Re: Group Row Number [message #1843983 is a reply to message #218802]

Thu, 26 August 2021 01:17

Eclipse User

Hello, how can we add serial number on a group like runningsum but not for all the records.

Previous Topic:	birt runningsum on group
Next Topic:	Download automatic report (xlsx)

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Mar 20 11:21:45 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter