Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Optional Y series grouping using a grouped data set
Optional Y series grouping using a grouped data set [message #640459] Mon, 22 November 2010 08:30 Go to next message
Helmut Neubauer is currently offline Helmut NeubauerFriend
Messages: 54
Registered: July 2009
Member
Hello,

Is it possible to use "Optional Y series grouping" in a grouped dataset?

I'm using a table grouping my dataset and want so show a scatter chart
for each group with several series. I placed the chart in the group
footer. I tried to use "Optional Y series grouping" to group my grouped
values for different series. This doesn't work.

Now I tried a simple test example (using a CSV file with four rows):

a,b,c,d
1,1,1,1
1,2,2,2
2,1,3,3
2,2,4,4

First I tried to use only one scatter chart (X-> c, Y-> d, Optional
grouping -> b); no problem, I got my scatter chart with two series each
with two values.

Afterwards I placed the scatter chart in a group footer using the same
dataset. In addition I use 'a' as table group. No I got two scatter
charts each with only one series.

Thanks,
Helmut
Re: Optional Y series grouping using a grouped data set [message #640670 is a reply to message #640459] Mon, 22 November 2010 18:31 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I tried to reproduce the issue. Can you take a look at the attached
example?

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.5.2.v20100208 Build &lt;2.5.2.v20100210-0630></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<script-data-source name="Data Source" id="7"/>
</data-sources>
<data-sets>
<script-data-set name="Data Set" id="8">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">a</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">b</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">c</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">d</property>
<property name="dataType">integer</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">a</property>
</structure>
<structure>
<property name="columnName">b</property>
</structure>
<structure>
<property name="columnName">c</property>
</structure>
<structure>
<property name="columnName">d</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">a</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">b</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">c</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">d</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<method name="open"><![CDATA[ii=0;]]></method>
<method name="fetch"><![CDATA[if( ii > 3 ) return false;

if( ii == 0 ){
row["a"] = 1;
row["b"] = 1;
row["c"] = 1;
row["d"] = 1;
}

if( ii == 1 ){
row["a"] = 1;
row["b"] = 2;
row["c"] = 2;
row["d"] = 2;
}

if( ii == 2 ){
row["a"] = 2;
row["b"] = 1;
row["c"] = 3;
row["d"] = 3;
}

if( ii == 3 ){
row["a"] = 2;
row["b"] = 2;
row["c"] = 4;
row["d"] = 4;
}

ii++;
return true
]]></method>
</script-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property
name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="9">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">a</property>
<text-property name="displayName">a</text-property>
<expression name="expression"
type="javascript">dataSetRow["a"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">b</property>
<text-property name="displayName">b</text-property>
<expression name="expression"
type="javascript">dataSetRow["b"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">c</property>
<text-property name="displayName">c</text-property>
<expression name="expression"
type="javascript">dataSetRow["c"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">d</property>
<text-property name="displayName">d</text-property>
<expression name="expression"
type="javascript">dataSetRow["d"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<column id="33"/>
<column id="34"/>
<column id="35"/>
<column id="36"/>
<header>
<row id="10">
<cell id="11">
<label id="12">
<text-property name="text">a</text-property>
</label>
</cell>
<cell id="13">
<label id="14">
<text-property name="text">b</text-property>
</label>
</cell>
<cell id="15">
<label id="16">
<text-property name="text">c</text-property>
</label>
</cell>
<cell id="17">
<label id="18">
<text-property name="text">d</text-property>
</label>
</cell>
</row>
</header>
<group id="38">
<property name="groupName">NewTableGroup1</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr"
type="javascript">row["a"]</expression>
<structure name="toc">
<expression name="expressionValue"
type="javascript">row["a"]</expression>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="39">
<cell id="40">
<data id="49">
<property
name="resultSetColumn">a</property>
</data>
</cell>
<cell id="41"/>
<cell id="42"/>
<cell id="43"/>
</row>
</header>
<footer>
<row id="44">
<cell id="45">
<property name="colSpan">4</property>
<property name="rowSpan">1</property>
<extended-item extensionName="Chart" id="37">
<xml-property
name="xmlRepresentation"><![CDATA[<model:ChartWithAxes
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute"
xmlns:data="http://www.birt.eclipse.org/ChartModelData"
xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout"
xmlns:model="http://www.birt.eclipse.org/ChartModel"
xmlns:type="http://www.birt.eclipse.org/ChartModelType">
<Version>2.5.1</Version>
<Type>Scatter Chart</Type>
<SubType>Standard Scatter Chart</SubType>
<Block>
<Children xsi:type="layout:TitleBlock">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<Label>
<Caption>
<Value>Scatter Chart Title</Value>
<Font>
<Size>16.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
</Children>
<Children xsi:type="layout:Plot">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<HorizontalSpacing>5</HorizontalSpacing>
<VerticalSpacing>5</VerticalSpacing>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>0.0</Left>
<Bottom>0.0</Bottom>
<Right>0.0</Right>
</Insets>
</ClientArea>
</Children>
<Children xsi:type="layout:Legend">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>2.0</Top>
<Left>2.0</Left>
<Bottom>2.0</Bottom>
<Right>2.0</Right>
</Insets>
</ClientArea>
<Text>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Text>
<Orientation>Vertical</Orientation>
<Direction>Top_Bottom</Direction>
<Separator>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</Separator>
<Position>Right</Position>
<ItemType>Series</ItemType>
<Title>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Above</TitlePosition>
</Children>
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>555.0</Width>
<Height>228.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Visible>true</Visible>
</Block>
<Dimension>Two_Dimensional</Dimension>
<Units>Points</Units>
<SeriesThickness>10.0</SeriesThickness>
<ExtendedProperties>
<Name>enable.area.alt</Name>
<Value>false</Value>
</ExtendedProperties>
<SampleData>
<BaseSampleData>
<DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
</BaseSampleData>
<OrthogonalSampleData>
<DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
<SeriesDefinitionIndex>0</SeriesDefinitionIndex>
</OrthogonalSampleData>
</SampleData>
<Interactivity/>
<EmptyMessage>
<Caption>
<Value>This chart contains no data.</Value>
<Font>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>64</Transparency>
<Red>127</Red>
<Green>127</Green>
<Blue>127</Blue>
</Background>
<Outline>
<Color>
<Transparency>128</Transparency>
<Red>127</Red>
<Green>127</Green>
<Blue>127</Blue>
</Color>
<Visible>true</Visible>
</Outline>
<Insets>
<Top>10.0</Top>
<Left>10.0</Left>
<Bottom>10.0</Bottom>
<Right>10.0</Right>
</Insets>
<Visible>false</Visible>
</EmptyMessage>
<Axes>
<Type>Linear</Type>
<Title>
<Caption>
<Value>X-Axis Title</Value>
<Font>
<Size>14.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Below</TitlePosition>
<AssociatedAxes>
<Type>Linear</Type>
<Title>
<Caption>
<Value>Y-Axis Title</Value>
<Font>
<Size>14.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
<Rotation>90.0</Rotation>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Left</TitlePosition>
<SeriesDefinitions>
<Query>
<Definition>row[&quot;b&quot;]</Definition>
<Grouping>
<GroupType>Numeric</GroupType>
</Grouping>
</Query>
<SeriesPalette>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>166</Green>
<Blue>218</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>242</Red>
<Green>88</Green>
<Blue>106</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>232</Red>
<Green>172</Green>
<Blue>57</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>64</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>170</Red>
<Green>85</Green>
<Blue>85</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>192</Red>
<Green>192</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>192</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>7</Red>
<Green>146</Green>
<Blue>94</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>128</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>255</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>64</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>240</Green>
<Blue>120</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>64</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>0</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>64</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
</SeriesPalette>
<Series xsi:type="type:ScatterSeries">
<Visible>true</Visible>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<DataDefinition>
<Definition>row[&quot;d&quot;]</Definition>
<Grouping>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</DataDefinition>
<SeriesIdentifier>Series 1</SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Above</LabelPosition>
<Stacked>false</Stacked>
<Markers>
<Type>Crosshair</Type>
<Size>4</Size>
<Visible>true</Visible>
<Outline>
<Visible>true</Visible>
</Outline>
</Markers>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
</Series>
<Grouping>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</SeriesDefinitions>
<Orientation>Vertical</Orientation>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Visible>true</Visible>
</LineAttributes>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
<LabelPosition>Left</LabelPosition>
<MajorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>true</Visible>
</TickAttributes>
</MajorGrid>
<MinorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</TickAttributes>
</MinorGrid>
<Scale>
<MinorGridsPerUnit>5</MinorGridsPerUnit>
</Scale>
<Origin>
<Type>Min</Type>
<Value xsi:type="data:NumberDataElement">
<Value>0.0</Value>
</Value>
</Origin>
<PrimaryAxis>true</PrimaryAxis>
<Percent>false</Percent>
</AssociatedAxes>
<SeriesDefinitions>
<Query>
<Definition></Definition>
</Query>
<SeriesPalette>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>166</Green>
<Blue>218</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>242</Red>
<Green>88</Green>
<Blue>106</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>232</Red>
<Green>172</Green>
<Blue>57</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>64</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>170</Red>
<Green>85</Green>
<Blue>85</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>192</Red>
<Green>192</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>192</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>7</Red>
<Green>146</Green>
<Blue>94</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>128</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>255</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>64</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>240</Green>
<Blue>120</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>64</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>0</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>64</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
</SeriesPalette>
<Series>
<Visible>true</Visible>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<DataDefinition>
<Definition>row[&quot;c&quot;]</Definition>
</DataDefinition>
<SeriesIdentifier></SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
Re: Optional Y series grouping using a grouped data set [message #640808 is a reply to message #640670] Tue, 23 November 2010 08:58 Go to previous messageGo to next message
Helmut Neubauer is currently offline Helmut NeubauerFriend
Messages: 54
Registered: July 2009
Member
Hello Jason,

thanks for your help! With your example I found the problem. I've never
done this before, so I forgot to set "Inherit Columns and Groups" in the
"Select Data" tab of my scatter chart. Now it works.

Your support is as always great!
Helmut


Am 22.11.2010 19:31, schrieb Jason Weathersby:
> I tried to reproduce the issue. Can you take a look at the attached
> example?
>
> Jason
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.5.2.v20100208 Build &lt;2.5.2.v20100210-0630></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <property name="imageDPI">96</property>
> <data-sources>
> <script-data-source name="Data Source" id="7"/>
> </data-sources>
> <data-sets>
> <script-data-set name="Data Set" id="8">
> <list-property name="resultSetHints">
> <structure>
> <property name="position">1</property>
> <property name="name">a</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">b</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">c</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">d</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">a</property>
> </structure>
> <structure>
> <property name="columnName">b</property>
> </structure>
> <structure>
> <property name="columnName">c</property>
> </structure>
> <structure>
> <property name="columnName">d</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">a</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">b</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">c</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">d</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <method name="open"><![CDATA[ii=0;]]></method>
> <method name="fetch"><![CDATA[if( ii > 3 ) return false;
>
> if( ii == 0 ){
> row["a"] = 1;
> row["b"] = 1;
> row["c"] = 1;
> row["d"] = 1;
> }
>
> if( ii == 1 ){
> row["a"] = 1;
> row["b"] = 2;
> row["c"] = 2;
> row["d"] = 2;
> }
>
> if( ii == 2 ){
> row["a"] = 2;
> row["b"] = 1;
> row["c"] = 3;
> row["d"] = 3;
> }
>
> if( ii == 3 ){
> row["a"] = 2;
> row["b"] = 2;
> row["c"] = 4;
> row["d"] = 4;
> }
>
> ii++;
> return true
> ]]></method>
> </script-data-set>
> </data-sets>
> <styles>
> <style name="report" id="4">
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">10pt</property>
> </style>
> <style name="crosstab-cell" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab" id="6">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<value-of>new
> Date()</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="9">
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">a</property>
> <text-property name="displayName">a</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["a"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">b</property>
> <text-property name="displayName">b</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["b"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">c</property>
> <text-property name="displayName">c</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["c"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">d</property>
> <text-property name="displayName">d</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["d"]</expression>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <column id="33"/>
> <column id="34"/>
> <column id="35"/>
> <column id="36"/>
> <header>
> <row id="10">
> <cell id="11">
> <label id="12">
> <text-property name="text">a</text-property>
> </label>
> </cell>
> <cell id="13">
> <label id="14">
> <text-property name="text">b</text-property>
> </label>
> </cell>
> <cell id="15">
> <label id="16">
> <text-property name="text">c</text-property>
> </label>
> </cell>
> <cell id="17">
> <label id="18">
> <text-property name="text">d</text-property>
> </label>
> </cell>
> </row>
> </header>
> <group id="38">
> <property name="groupName">NewTableGroup1</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression name="keyExpr"
> type="javascript">row["a"]</expression>
> <structure name="toc">
> <expression name="expressionValue"
> type="javascript">row["a"]</expression>
> </structure>
> <property name="repeatHeader">true</property>
> <property name="hideDetail">false</property>
> <property name="pageBreakAfter">auto</property>
> <property name="pageBreakBefore">auto</property>
> <property name="pageBreakInside">auto</property>
> <header>
> <row id="39">
> <cell id="40">
> <data id="49">
> <property
> name="resultSetColumn">a</property>
> </data>
> </cell>
> <cell id="41"/>
> <cell id="42"/>
> <cell id="43"/>
> </row>
> </header>
> <footer>
> <row id="44">
> <cell id="45">
> <property name="colSpan">4</property>
> <property name="rowSpan">1</property>
> <extended-item extensionName="Chart" id="37">
> <xml-property
> name="xmlRepresentation"><![CDATA[<model:ChartWithAxes
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute"
> xmlns:data="http://www.birt.eclipse.org/ChartModelData"
> xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout"
> xmlns:model="http://www.birt.eclipse.org/ChartModel"
> xmlns:type="http://www.birt.eclipse.org/ChartModelType">
> <Version>2.5.1</Version>
> <Type>Scatter Chart</Type>
> <SubType>Standard Scatter Chart</SubType>
> <Block>
> <Children xsi:type="layout:TitleBlock">
> <Bounds>
> <Left>0.0</Left>
> <Top>0.0</Top>
> <Width>0.0</Width>
> <Height>0.0</Height>
> </Bounds>
> <Insets>
> <Top>3.0</Top>
> <Left>3.0</Left>
> <Bottom>3.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Row>-1</Row>
> <Column>-1</Column>
> <Rowspan>-1</Rowspan>
> <Columnspan>-1</Columnspan>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Visible>true</Visible>
> <Label>
> <Caption>
> <Value>Scatter Chart Title</Value>
> <Font>
> <Size>16.0</Size>
> <Bold>true</Bold>
> <Alignment>
> <horizontalAlignment>Center</horizontalAlignment>
> <verticalAlignment>Center</verticalAlignment>
> </Alignment>
> </Font>
> </Caption>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>0</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> </Outline>
> <Insets>
> <Top>0.0</Top>
> <Left>2.0</Left>
> <Bottom>0.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Visible>true</Visible>
> </Label>
> </Children>
> <Children xsi:type="layout:Plot">
> <Bounds>
> <Left>0.0</Left>
> <Top>0.0</Top>
> <Width>0.0</Width>
> <Height>0.0</Height>
> </Bounds>
> <Insets>
> <Top>3.0</Top>
> <Left>3.0</Left>
> <Bottom>3.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Row>-1</Row>
> <Column>-1</Column>
> <Rowspan>-1</Rowspan>
> <Columnspan>-1</Columnspan>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Visible>true</Visible>
> <HorizontalSpacing>5</HorizontalSpacing>
> <VerticalSpacing>5</VerticalSpacing>
> <ClientArea>
> <Outline>
> <Style>Solid</Style>
> <Thickness>0</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Insets>
> <Top>0.0</Top>
> <Left>0.0</Left>
> <Bottom>0.0</Bottom>
> <Right>0.0</Right>
> </Insets>
> </ClientArea>
> </Children>
> <Children xsi:type="layout:Legend">
> <Bounds>
> <Left>0.0</Left>
> <Top>0.0</Top>
> <Width>0.0</Width>
> <Height>0.0</Height>
> </Bounds>
> <Insets>
> <Top>3.0</Top>
> <Left>3.0</Left>
> <Bottom>3.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Row>-1</Row>
> <Column>-1</Column>
> <Rowspan>-1</Rowspan>
> <Columnspan>-1</Columnspan>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Visible>true</Visible>
> <ClientArea>
> <Outline>
> <Style>Solid</Style>
> <Thickness>0</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Insets>
> <Top>2.0</Top>
> <Left>2.0</Left>
> <Bottom>2.0</Bottom>
> <Right>2.0</Right>
> </Insets>
> </ClientArea>
> <Text>
> <Value></Value>
> <Font>
> <Alignment/>
> </Font>
> </Text>
> <Orientation>Vertical</Orientation>
> <Direction>Top_Bottom</Direction>
> <Separator>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>true</Visible>
> </Separator>
> <Position>Right</Position>
> <ItemType>Series</ItemType>
> <Title>
> <Caption>
> <Value></Value>
> <Font>
> <Alignment/>
> </Font>
> </Caption>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>0</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Insets>
> <Top>0.0</Top>
> <Left>2.0</Left>
> <Bottom>0.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Visible>false</Visible>
> </Title>
> <TitlePosition>Above</TitlePosition>
> </Children>
> <Bounds>
> <Left>0.0</Left>
> <Top>0.0</Top>
> <Width>555.0</Width>
> <Height>228.0</Height>
> </Bounds>
> <Insets>
> <Top>3.0</Top>
> <Left>3.0</Left>
> <Bottom>3.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Row>-1</Row>
> <Column>-1</Column>
> <Rowspan>-1</Rowspan>
> <Columnspan>-1</Columnspan>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Visible>true</Visible>
> </Block>
> <Dimension>Two_Dimensional</Dimension>
> <Units>Points</Units>
> <SeriesThickness>10.0</SeriesThickness>
> <ExtendedProperties>
> <Name>enable.area.alt</Name>
> <Value>false</Value>
> </ExtendedProperties>
> <SampleData>
> <BaseSampleData>
> <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
> </BaseSampleData>
> <OrthogonalSampleData>
> <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
> </OrthogonalSampleData>
> </SampleData>
> <Interactivity/>
> <EmptyMessage>
> <Caption>
> <Value>This chart contains no data.</Value>
> <Font>
> <Alignment>
> <horizontalAlignment>Center</horizontalAlignment>
> <verticalAlignment>Center</verticalAlignment>
> </Alignment>
> </Font>
> </Caption>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>64</Transparency>
> <Red>127</Red>
> <Green>127</Green>
> <Blue>127</Blue>
> </Background>
> <Outline>
> <Color>
> <Transparency>128</Transparency>
> <Red>127</Red>
> <Green>127</Green>
> <Blue>127</Blue>
> </Color>
> <Visible>true</Visible>
> </Outline>
> <Insets>
> <Top>10.0</Top>
> <Left>10.0</Left>
> <Bottom>10.0</Bottom>
> <Right>10.0</Right>
> </Insets>
> <Visible>false</Visible>
> </EmptyMessage>
> <Axes>
> <Type>Linear</Type>
> <Title>
> <Caption>
> <Value>X-Axis Title</Value>
> <Font>
> <Size>14.0</Size>
> <Bold>true</Bold>
> <Alignment>
> <horizontalAlignment>Center</horizontalAlignment>
> <verticalAlignment>Center</verticalAlignment>
> </Alignment>
> </Font>
> </Caption>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>0</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> </Outline>
> <Insets>
> <Top>0.0</Top>
> <Left>2.0</Left>
> <Bottom>0.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Visible>false</Visible>
> </Title>
> <TitlePosition>Below</TitlePosition>
> <AssociatedAxes>
> <Type>Linear</Type>
> <Title>
> <Caption>
> <Value>Y-Axis Title</Value>
> <Font>
> <Size>14.0</Size>
> <Bold>true</Bold>
> <Alignment>
> <horizontalAlignment>Center</horizontalAlignment>
> <verticalAlignment>Center</verticalAlignment>
> </Alignment>
> <Rotation>90.0</Rotation>
> </Font>
> </Caption>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>0</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> </Outline>
> <Insets>
> <Top>0.0</Top>
> <Left>2.0</Left>
> <Bottom>0.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Visible>false</Visible>
> </Title>
> <TitlePosition>Left</TitlePosition>
> <SeriesDefinitions>
> <Query>
> <Definition>row[&quot;b&quot;]</Definition>
> <Grouping>
> <GroupType>Numeric</GroupType>
> </Grouping>
> </Query>
> <SeriesPalette>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>80</Red>
> <Green>166</Green>
> <Blue>218</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>242</Red>
> <Green>88</Green>
> <Blue>106</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>232</Red>
> <Green>172</Green>
> <Blue>57</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>255</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>64</Red>
> <Green>128</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>128</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>170</Red>
> <Green>85</Green>
> <Blue>85</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>128</Green>
> <Blue>0</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>192</Red>
> <Green>192</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>192</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>7</Red>
> <Green>146</Green>
> <Blue>94</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>128</Green>
> <Blue>255</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>128</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>128</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>128</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>128</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>0</Green>
> <Blue>255</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>64</Green>
> <Blue>64</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>128</Green>
> <Blue>64</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>80</Red>
> <Green>240</Green>
> <Blue>120</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>64</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>0</Green>
> <Blue>64</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>0</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>128</Green>
> <Blue>64</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>128</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>128</Green>
> <Blue>255</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>64</Green>
> <Blue>0</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>128</Green>
> <Blue>0</Blue>
> </Entries>
> </SeriesPalette>
> <Series xsi:type="type:ScatterSeries">
> <Visible>true</Visible>
> <Label>
> <Caption>
> <Value></Value>
> <Font>
> <Alignment/>
> </Font>
> </Caption>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>0</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Insets>
> <Top>0.0</Top>
> <Left>2.0</Left>
> <Bottom>0.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Visible>false</Visible>
> </Label>
> <DataDefinition>
> <Definition>row[&quot;d&quot;]</Definition>
> <Grouping>
> <GroupType>Text</GroupType>
> <AggregateExpression>Sum</AggregateExpression>
> </Grouping>
> </DataDefinition>
> <SeriesIdentifier>Series 1</SeriesIdentifier>
> <DataPoint>
> <Components>
> <Type>Orthogonal_Value</Type>
> </Components>
> <Separator>, </Separator>
> </DataPoint>
> <LabelPosition>Above</LabelPosition>
> <Stacked>false</Stacked>
> <Markers>
> <Type>Crosshair</Type>
> <Size>4</Size>
> <Visible>true</Visible>
> <Outline>
> <Visible>true</Visible>
> </Outline>
> </Markers>
> <LineAttributes>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </LineAttributes>
> </Series>
> <Grouping>
> <GroupType>Text</GroupType>
> <AggregateExpression>Sum</AggregateExpression>
> </Grouping>
> </SeriesDefinitions>
> <Orientation>Vertical</Orientation>
> <LineAttributes>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Visible>true</Visible>
> </LineAttributes>
> <Label>
> <Caption>
> <Value></Value>
> <Font>
> <Alignment/>
> </Font>
> </Caption>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>0</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> </Outline>
> <Insets>
> <Top>0.0</Top>
> <Left>2.0</Left>
> <Bottom>0.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Visible>true</Visible>
> </Label>
> <LabelPosition>Left</LabelPosition>
> <MajorGrid>
> <LineAttributes>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>196</Red>
> <Green>196</Green>
> <Blue>196</Blue>
> </Color>
> <Visible>false</Visible>
> </LineAttributes>
> <TickStyle>Across</TickStyle>
> <TickAttributes>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>196</Red>
> <Green>196</Green>
> <Blue>196</Blue>
> </Color>
> <Visible>true</Visible>
> </TickAttributes>
> </MajorGrid>
> <MinorGrid>
> <LineAttributes>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>225</Red>
> <Green>225</Green>
> <Blue>225</Blue>
> </Color>
> <Visible>false</Visible>
> </LineAttributes>
> <TickStyle>Across</TickStyle>
> <TickAttributes>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>225</Red>
> <Green>225</Green>
> <Blue>225</Blue>
> </Color>
> <Visible>false</Visible>
> </TickAttributes>
> </MinorGrid>
> <Scale>
> <MinorGridsPerUnit>5</MinorGridsPerUnit>
> </Scale>
> <Origin>
> <Type>Min</Type>
> <Value xsi:type="data:NumberDataElement">
> <Value>0.0</Value>
> </Value>
> </Origin>
> <PrimaryAxis>true</PrimaryAxis>
> <Percent>false</Percent>
> </AssociatedAxes>
> <SeriesDefinitions>
> <Query>
> <Definition></Definition>
> </Query>
> <SeriesPalette>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>80</Red>
> <Green>166</Green>
> <Blue>218</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>242</Red>
> <Green>88</Green>
> <Blue>106</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>232</Red>
> <Green>172</Green>
> <Blue>57</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>255</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>64</Red>
> <Green>128</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>128</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>170</Red>
> <Green>85</Green>
> <Blue>85</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>128</Green>
> <Blue>0</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>192</Red>
> <Green>192</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>192</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>7</Red>
> <Green>146</Green>
> <Blue>94</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>128</Green>
> <Blue>255</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>128</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>128</Green>
> <Blue>128</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>128</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>128</Green>
> <Blue>192</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>0</Green>
> <Blue>255</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>128</Red>
> <Green>64</Green>
> <Blue>64</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>255</Red>
> <Green>128</Green>
> <Blue>64</Blue>
> </Entries>
> <Entries xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>80</Red>
> <Green>240</Green>
> <Blue>120</Blue>
> </Entries>
>
Re: Optional Y series grouping using a grouped data set [message #640814 is a reply to message #640808] Tue, 23 November 2010 09:18 Go to previous messageGo to next message
Helmut Neubauer is currently offline Helmut NeubauerFriend
Messages: 54
Registered: July 2009
Member
Hello Jason,

I was wrong, I have to choose "Inherit columns only" (like in your
report example), not the default. But I don't understand why. "Inherit
Columns and Groups" seems more intuitive. Perhaps you can explain, how
BIRT does the grouping?

Thanks,
Helmut


Am 23.11.2010 09:58, schrieb Helmut Neubauer:
> Hello Jason,
>
> thanks for your help! With your example I found the problem. I've never
> done this before, so I forgot to set "Inherit Columns and Groups" in the
> "Select Data" tab of my scatter chart. Now it works.
>
> Your support is as always great!
> Helmut
>
>
> Am 22.11.2010 19:31, schrieb Jason Weathersby:
>> I tried to reproduce the issue. Can you take a look at the attached
>> example?
>>
>> Jason
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
>> id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.5.2.v20100208 Build &lt;2.5.2.v20100210-0630></property>
>> <property name="units">in</property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <property name="bidiLayoutOrientation">ltr</property>
>> <property name="imageDPI">96</property>
>> <data-sources>
>> <script-data-source name="Data Source" id="7"/>
>> </data-sources>
>> <data-sets>
>> <script-data-set name="Data Set" id="8">
>> <list-property name="resultSetHints">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">a</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">b</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">c</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">d</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> <list-property name="columnHints">
>> <structure>
>> <property name="columnName">a</property>
>> </structure>
>> <structure>
>> <property name="columnName">b</property>
>> </structure>
>> <structure>
>> <property name="columnName">c</property>
>> </structure>
>> <structure>
>> <property name="columnName">d</property>
>> </structure>
>> </list-property>
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">a</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">b</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">c</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">d</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <method name="open"><![CDATA[ii=0;]]></method>
>> <method name="fetch"><![CDATA[if( ii > 3 ) return false;
>>
>> if( ii == 0 ){
>> row["a"] = 1;
>> row["b"] = 1;
>> row["c"] = 1;
>> row["d"] = 1;
>> }
>>
>> if( ii == 1 ){
>> row["a"] = 1;
>> row["b"] = 2;
>> row["c"] = 2;
>> row["d"] = 2;
>> }
>>
>> if( ii == 2 ){
>> row["a"] = 2;
>> row["b"] = 1;
>> row["c"] = 3;
>> row["d"] = 3;
>> }
>>
>> if( ii == 3 ){
>> row["a"] = 2;
>> row["b"] = 2;
>> row["c"] = 4;
>> row["d"] = 4;
>> }
>>
>> ii++;
>> return true
>> ]]></method>
>> </script-data-set>
>> </data-sets>
>> <styles>
>> <style name="report" id="4">
>> <property name="fontFamily">sans-serif</property>
>> <property name="fontSize">10pt</property>
>> </style>
>> <style name="crosstab-cell" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab" id="6">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> </styles>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <page-footer>
>> <text id="3">
>> <property name="contentType">html</property>
>> <text-property name="content"><![CDATA[<value-of>new
>> Date()</value-of>]]></text-property>
>> </text>
>> </page-footer>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <table id="9">
>> <property name="dataSet">Data Set</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">a</property>
>> <text-property name="displayName">a</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["a"]</expression>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">b</property>
>> <text-property name="displayName">b</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["b"]</expression>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">c</property>
>> <text-property name="displayName">c</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["c"]</expression>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">d</property>
>> <text-property name="displayName">d</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["d"]</expression>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> <column id="33"/>
>> <column id="34"/>
>> <column id="35"/>
>> <column id="36"/>
>> <header>
>> <row id="10">
>> <cell id="11">
>> <label id="12">
>> <text-property name="text">a</text-property>
>> </label>
>> </cell>
>> <cell id="13">
>> <label id="14">
>> <text-property name="text">b</text-property>
>> </label>
>> </cell>
>> <cell id="15">
>> <label id="16">
>> <text-property name="text">c</text-property>
>> </label>
>> </cell>
>> <cell id="17">
>> <label id="18">
>> <text-property name="text">d</text-property>
>> </label>
>> </cell>
>> </row>
>> </header>
>> <group id="38">
>> <property name="groupName">NewTableGroup1</property>
>> <property name="interval">none</property>
>> <property name="sortDirection">asc</property>
>> <expression name="keyExpr"
>> type="javascript">row["a"]</expression>
>> <structure name="toc">
>> <expression name="expressionValue"
>> type="javascript">row["a"]</expression>
>> </structure>
>> <property name="repeatHeader">true</property>
>> <property name="hideDetail">false</property>
>> <property name="pageBreakAfter">auto</property>
>> <property name="pageBreakBefore">auto</property>
>> <property name="pageBreakInside">auto</property>
>> <header>
>> <row id="39">
>> <cell id="40">
>> <data id="49">
>> <property
>> name="resultSetColumn">a</property>
>> </data>
>> </cell>
>> <cell id="41"/>
>> <cell id="42"/>
>> <cell id="43"/>
>> </row>
>> </header>
>> <footer>
>> <row id="44">
>> <cell id="45">
>> <property name="colSpan">4</property>
>> <property name="rowSpan">1</property>
>> <extended-item extensionName="Chart" id="37">
>> <xml-property
>> name="xmlRepresentation"><![CDATA[<model:ChartWithAxes
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute"
>> xmlns:data="http://www.birt.eclipse.org/ChartModelData"
>> xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout"
>> xmlns:model="http://www.birt.eclipse.org/ChartModel"
>> xmlns:type="http://www.birt.eclipse.org/ChartModelType">
>> <Version>2.5.1</Version>
>> <Type>Scatter Chart</Type>
>> <SubType>Standard Scatter Chart</SubType>
>> <Block>
>> <Children xsi:type="layout:TitleBlock">
>> <Bounds>
>> <Left>0.0</Left>
>> <Top>0.0</Top>
>> <Width>0.0</Width>
>> <Height>0.0</Height>
>> </Bounds>
>> <Insets>
>> <Top>3.0</Top>
>> <Left>3.0</Left>
>> <Bottom>3.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Row>-1</Row>
>> <Column>-1</Column>
>> <Rowspan>-1</Rowspan>
>> <Columnspan>-1</Columnspan>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Visible>true</Visible>
>> <Label>
>> <Caption>
>> <Value>Scatter Chart Title</Value>
>> <Font>
>> <Size>16.0</Size>
>> <Bold>true</Bold>
>> <Alignment>
>> <horizontalAlignment>Center</horizontalAlignment>
>> <verticalAlignment>Center</verticalAlignment>
>> </Alignment>
>> </Font>
>> </Caption>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>0</Transparency>
>> <Red>255</Red>
>> <Green>255</Green>
>> <Blue>255</Blue>
>> </Background>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> </Outline>
>> <Insets>
>> <Top>0.0</Top>
>> <Left>2.0</Left>
>> <Bottom>0.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Visible>true</Visible>
>> </Label>
>> </Children>
>> <Children xsi:type="layout:Plot">
>> <Bounds>
>> <Left>0.0</Left>
>> <Top>0.0</Top>
>> <Width>0.0</Width>
>> <Height>0.0</Height>
>> </Bounds>
>> <Insets>
>> <Top>3.0</Top>
>> <Left>3.0</Left>
>> <Bottom>3.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Row>-1</Row>
>> <Column>-1</Column>
>> <Rowspan>-1</Rowspan>
>> <Columnspan>-1</Columnspan>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Visible>true</Visible>
>> <HorizontalSpacing>5</HorizontalSpacing>
>> <VerticalSpacing>5</VerticalSpacing>
>> <ClientArea>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>0</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
> Path: news.eclipse.org!not-for-mail
> From: Helmut Neubauer <helmut.neubauer@cognidata.de>
> Newsgroups: eclipse.birt
> Subject: Re: Optional Y series grouping using a grouped data set
> Date: Tue, 23 Nov 2010 09:58:18 +0100
> Organization: EclipseCorner
> Lines: 1476
> Message-ID: <icfvff$pie$1@news.eclipse.org>
> References: <icd9fp$24i$1@news.eclipse.org> <icecm8$d6u$1@news.eclipse.org>
> NNTP-Posting-Host: pc12002.mathematik.uni-marburg.de
> Mime-Version: 1.0
> Content-Type: text/plain; charset=ISO-8859-15
> Content-Transfer-Encoding: 7bit
> X-Trace: news.eclipse.org 1290502448 26190 137.248.121.10 (23 Nov 2010 08:54:08 GMT)
> X-Complaints-To: news@news.eclipse.org
> NNTP-Posting-Date: Tue, 23 Nov 2010 08:54:08 +0000 (UTC)
> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.9) Gecko/20100915 Lightning/1.0b2 Thunderbird/3.1.4
> In-Reply-To: <icecm8$d6u$1@news.eclipse.org>
> Xref: news.eclipse.org eclipse.birt:40043
>
> Hello Jason,
>
> thanks for your help! With your example I found the problem. I've never
> done this before, so I forgot to set "Inherit Columns and Groups" in the
> "Select Data" tab of my scatter chart. Now it works.
>
> Your support is as always great!
> Helmut
>
>
> Am 22.11.2010 19:31, schrieb Jason Weathersby:
>> I tried to reproduce the issue. Can you take a look at the attached
>> example?
>>
>> Jason
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
>> id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.5.2.v20100208 Build &lt;2.5.2.v20100210-0630></property>
>> <property name="units">in</property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <property name="bidiLayoutOrientation">ltr</property>
>> <property name="imageDPI">96</property>
>> <data-sources>
>> <script-data-source name="Data Source" id="7"/>
>> </data-sources>
>> <data-sets>
>> <script-data-set name="Data Set" id="8">
>> <list-property name="resultSetHints">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">a</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">b</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">c</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">d</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> <list-property name="columnHints">
>> <structure>
>> <property name="columnName">a</property>
>> </structure>
>> <structure>
>> <property name="columnName">b</property>
>> </structure>
>> <structure>
>> <property name="columnName">c</property>
>> </structure>
>> <structure>
>> <property name="columnName">d</property>
>> </structure>
>> </list-property>
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">a</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">b</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">c</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">d</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <method name="open"><![CDATA[ii=0;]]></method>
>> <method name="fetch"><![CDATA[if( ii > 3 ) return false;
>>
>> if( ii == 0 ){
>> row["a"] = 1;
>> row["b"] = 1;
>> row["c"] = 1;
>> row["d"] = 1;
>> }
>>
>> if( ii == 1 ){
>> row["a"] = 1;
>> row["b"] = 2;
>> row["c"] = 2;
>> row["d"] = 2;
>> }
>>
>> if( ii == 2 ){
>> row["a"] = 2;
>> row["b"] = 1;
>> row["c"] = 3;
>> row["d"] = 3;
>> }
>>
>> if( ii == 3 ){
>> row["a"] = 2;
>> row["b"] = 2;
>> row["c"] = 4;
>> row["d"] = 4;
>> }
>>
>> ii++;
>> return true
>> ]]></method>
>> </script-data-set>
>> </data-sets>
>> <styles>
>> <style name="report" id="4">
>> <property name="fontFamily">sans-serif</property>
>> <property name="fontSize">10pt</property>
>> </style>
>> <style name="crosstab-cell" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab" id="6">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> </styles>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <page-footer>
>> <text id="3">
>> <property name="contentType">html</property>
>> <text-property name="content"><![CDATA[<value-of>new
>> Date()</value-of>]]></text-property>
>> </text>
>> </page-footer>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <table id="9">
>> <property name="dataSet">Data Set</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">a</property>
>> <text-property name="displayName">a</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["a"]</expression>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">b</property>
>> <text-property name="displayName">b</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["b"]</expression>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">c</property>
>> <text-property name="displayName">c</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["c"]</expression>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">d</property>
>> <text-property name="displayName">d</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["d"]</expression>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> <column id="33"/>
>> <column id="34"/>
>> <column id="35"/>
>> <column id="36"/>
>> <header>
>> <row id="10">
>> <cell id="11">
>> <label id="12">
>> <text-property name="text">a</text-property>
>> </label>
>> </cell>
>> <cell id="13">
>> <label id="14">
>> <text-property name="text">b</text-property>
>> </label>
>> </cell>
>> <cell id="15">
>> <label id="16">
>> <text-property name="text">c</text-property>
>> </label>
>> </cell>
>> <cell id="17">
>> <label id="18">
>> <text-property name="text">d</text-property>
>> </label>
>> </cell>
>> </row>
>> </header>
>> <group id="38">
>> <property name="groupName">NewTableGroup1</property>
>> <property name="interval">none</property>
>> <property name="sortDirection">asc</property>
>> <expression name="keyExpr"
>> type="javascript">row["a"]</expression>
>> <structure name="toc">
>> <expression name="expressionValue"
>> type="javascript">row["a"]</expression>
>> </structure>
>> <property name="repeatHeader">true</property>
>> <property name="hideDetail">false</property>
>> <property name="pageBreakAfter">auto</property>
>> <property name="pageBreakBefore">auto</property>
>> <property name="pageBreakInside">auto</property>
>> <header>
>> <row id="39">
>> <cell id="40">
>> <data id="49">
>> <property
>> name="resultSetColumn">a</property>
>> </data>
>> </cell>
>> <cell id="41"/>
>> <cell id="42"/>
>> <cell id="43"/>
>> </row>
>> </header>
>> <footer>
>> <row id="44">
>> <cell id="45">
>> <property name="colSpan">4</property>
>> <property name="rowSpan">1</property>
>> <extended-item extensionName="Chart" id="37">
>> <xml-property
>> name="xmlRepresentation"><![CDATA[<model:ChartWithAxes
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute"
>> xmlns:data="http://www.birt.eclipse.org/ChartModelData"
>> xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout"
>> xmlns:model="http://www.birt.eclipse.org/ChartModel"
>> xmlns:type="http://www.birt.eclipse.org/ChartModelType">
>> <Version>2.5.1</Version>
>> <Type>Scatter Chart</Type>
>> <SubType>Standard Scatter Chart</SubType>
>> <Block>
>> <Children xsi:type="layout:TitleBlock">
>> <Bounds>
>> <Left>0.0</Left>
>> <Top>0.0</Top>
>> <Width>0.0</Width>
>> <Height>0.0</Height>
>> </Bounds>
>> <Insets>
>> <Top>3.0</Top>
>> <Left>3.0</Left>
>> <Bottom>3.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Row>-1</Row>
>> <Column>-1</Column>
>> <Rowspan>-1</Rowspan>
>> <Columnspan>-1</Columnspan>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Visible>true</Visible>
>> <Label>
>> <Caption>
>> <Value>Scatter Chart Title</Value>
>> <Font>
>> <Size>16.0</Size>
>> <Bold>true</Bold>
>> <Alignment>
>> <horizontalAlignment>Center</horizontalAlignment>
>> <verticalAlignment>Center</verticalAlignment>
>> </Alignment>
>> </Font>
>> </Caption>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>0</Transparency>
>> <Red>255</Red>
>> <Green>255</Green>
>> <Blue>255</Blue>
>> </Background>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> </Outline>
>> <Insets>
>> <Top>0.0</Top>
>> <Left>2.0</Left>
>> <Bottom>0.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Visible>true</Visible>
>> </Label>
>> </Children>
>> <Children xsi:type="layout:Plot">
>> <Bounds>
>> <Left>0.0</Left>
>> <Top>0.0</Top>
>> <Width>0.0</Width>
>> <Height>0.0</Height>
>> </Bounds>
>> <Insets>
>> <Top>3.0</Top>
>> <Left>3.0</Left>
>> <Bottom>3.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Row>-1</Row>
>> <Column>-1</Column>
>> <Rowspan>-1</Rowspan>
>> <Columnspan>-1</Columnspan>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Visible>true</Visible>
>> <HorizontalSpacing>5</HorizontalSpacing>
>> <VerticalSpacing>5</VerticalSpacing>
>> <ClientArea>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>0</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Insets>
>> <Top>0.0</Top>
>> <Left>0.0</Left>
>> <Bottom>0.0</Bottom>
>> <Right>0.0</Right>
>> </Insets>
>> </ClientArea>
>> </Children>
>> <Children xsi:type="layout:Legend">
>> <Bounds>
>> <Left>0.0</Left>
>> <Top>0.0</Top>
>> <Width>0.0</Width>
>> <Height>0.0</Height>
>> </Bounds>
>> <Insets>
>> <Top>3.0</Top>
>> <Left>3.0</Left>
>> <Bottom>3.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Row>-1</Row>
>> <Column>-1</Column>
>> <Rowspan>-1</Rowspan>
>> <Columnspan>-1</Columnspan>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Visible>true</Visible>
>> <ClientArea>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>0</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Insets>
>> <Top>2.0</Top>
>> <Left>2.0</Left>
>> <Bottom>2.0</Bottom>
>> <Right>2.0</Right>
>> </Insets>
>> </ClientArea>
>> <Text>
>> <Value></Value>
>> <Font>
>> <Alignment/>
>> </Font>
>> </Text>
>> <Orientation>Vertical</Orientation>
>> <Direction>Top_Bottom</Direction>
>> <Separator>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>true</Visible>
>> </Separator>
>> <Position>Right</Position>
>> <ItemType>Series</ItemType>
>> <Title>
>> <Caption>
>> <Value></Value>
>> <Font>
>> <Alignment/>
>> </Font>
>> </Caption>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>0</Transparency>
>> <Red>255</Red>
>> <Green>255</Green>
>> <Blue>255</Blue>
>> </Background>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Insets>
>> <Top>0.0</Top>
>> <Left>2.0</Left>
>> <Bottom>0.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Visible>false</Visible>
>> </Title>
>> <TitlePosition>Above</TitlePosition>
>> </Children>
>> <Bounds>
>> <Left>0.0</Left>
>> <Top>0.0</Top>
>> <Width>555.0</Width>
>> <Height>228.0</Height>
>> </Bounds>
>> <Insets>
>> <Top>3.0</Top>
>> <Left>3.0</Left>
>> <Bottom>3.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Row>-1</Row>
>> <Column>-1</Column>
>> <Rowspan>-1</Rowspan>
>> <Columnspan>-1</Columnspan>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>255</Transparency>
>> <Red>255</Red>
>> <Green>255</Green>
>> <Blue>255</Blue>
>> </Background>
>> <Visible>true</Visible>
>> </Block>
>> <Dimension>Two_Dimensional</Dimension>
>> <Units>Points</Units>
>> <SeriesThickness>10.0</SeriesThickness>
>> <ExtendedProperties>
>> <Name>enable.area.alt</Name>
>> <Value>false</Value>
>> </ExtendedProperties>
>> <SampleData>
>> <BaseSampleData>
>> <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
>> </BaseSampleData>
>> <OrthogonalSampleData>
>> <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
>> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>> </OrthogonalSampleData>
>> </SampleData>
>> <Interactivity/>
>> <EmptyMessage>
>> <Caption>
>> <Value>This chart contains no data.</Value>
>> <Font>
>> <Alignment>
>> <horizontalAlignment>Center</horizontalAlignment>
>> <verticalAlignment>Center</verticalAlignment>
>> </Alignment>
>> </Font>
>> </Caption>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>64</Transparency>
>> <Red>127</Red>
>> <Green>127</Green>
>> <Blue>127</Blue>
>> </Background>
>> <Outline>
>> <Color>
>> <Transparency>128</Transparency>
>> <Red>127</Red>
>> <Green>127</Green>
>> <Blue>127</Blue>
>> </Color>
>> <Visible>true</Visible>
>> </Outline>
>> <Insets>
>> <Top>10.0</Top>
>> <Left>10.0</Left>
>> <Bottom>10.0</Bottom>
>> <Right>10.0</Right>
>> </Insets>
>> <Visible>false</Visible>
>> </EmptyMessage>
>> <Axes>
>> <Type>Linear</Type>
>> <Title>
>> <Caption>
>> <Value>X-Axis Title</Value>
>> <Font>
>> <Size>14.0</Size>
>> <Bold>true</Bold>
>> <Alignment>
>> <horizontalAlignment>Center</horizontalAlignment>
>> <verticalAlignment>Center</verticalAlignment>
>> </Alignment>
>> </Font>
>> </Caption>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>0</Transparency>
>> <Red>255</Red>
>> <Green>255</Green>
>> <Blue>255</Blue>
>> </Background>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> </Outline>
>> <Insets>
>> <Top>0.0</Top>
>> <Left>2.0</Left>
>> <Bottom>0.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Visible>false</Visible>
>> </Title>
>> <TitlePosition>Below</TitlePosition>
>> <AssociatedAxes>
>> <Type>Linear</Type>
>> <Title>
>> <Caption>
>> <Value>Y-Axis Title</Value>
>> <Font>
>> <Size>14.0</Size>
>> <Bold>
Re: Optional Y series grouping using a grouped data set [message #640956 is a reply to message #640814] Tue, 23 November 2010 16:42 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

If you inherit the groups I believe you can no longer do any additional
grouping (like optional y grouping, select grouping on x-axis or sum
type functions on the y axis). This means you should do all your
grouping and aggregation in the table and just use the chart to show
what you have calculated. If you inherit the columns you can do the
grouping in the chart. In your case because the chart is in the group
footer if you inherit columns only you only get the rows for that group
and then you can do additional grouping in the footer.

Jason


On 11/23/2010 4:18 AM, Helmut Neubauer wrote:
> Hello Jason,
>
> I was wrong, I have to choose "Inherit columns only" (like in your
> report example), not the default. But I don't understand why. "Inherit
> Columns and Groups" seems more intuitive. Perhaps you can explain, how
> BIRT does the grouping?
>
> Thanks,
> Helmut
>
>
> Am 23.11.2010 09:58, schrieb Helmut Neubauer:
>> Hello Jason,
>>
>> thanks for your help! With your example I found the problem. I've never
>> done this before, so I forgot to set "Inherit Columns and Groups" in the
>> "Select Data" tab of my scatter chart. Now it works.
>>
>> Your support is as always great!
>> Helmut
>>
>>
>> Am 22.11.2010 19:31, schrieb Jason Weathersby:
>>> I tried to reproduce the issue. Can you take a look at the attached
>>> example?
>>>
>>> Jason
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
>>> id="1">
>>> <property name="createdBy">Eclipse BIRT Designer Version
>>> 2.5.2.v20100208 Build&lt;2.5.2.v20100210-0630></property>
>>> <property name="units">in</property>
>>> <property name="iconFile">/templates/blank_report.gif</property>
>>> <property name="bidiLayoutOrientation">ltr</property>
>>> <property name="imageDPI">96</property>
>>> <data-sources>
>>> <script-data-source name="Data Source" id="7"/>
>>> </data-sources>
>>> <data-sets>
>>> <script-data-set name="Data Set" id="8">
>>> <list-property name="resultSetHints">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">a</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">b</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">c</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">d</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> <list-property name="columnHints">
>>> <structure>
>>> <property name="columnName">a</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">b</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">c</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">d</property>
>>> </structure>
>>> </list-property>
>>> <structure name="cachedMetaData">
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">a</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">b</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">c</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">d</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> </structure>
>>> <property name="dataSource">Data Source</property>
>>> <method name="open"><![CDATA[ii=0;]]></method>
>>> <method name="fetch"><![CDATA[if( ii> 3 ) return false;
>>>
>>> if( ii == 0 ){
>>> row["a"] = 1;
>>> row["b"] = 1;
>>> row["c"] = 1;
>>> row["d"] = 1;
>>> }
>>>
>>> if( ii == 1 ){
>>> row["a"] = 1;
>>> row["b"] = 2;
>>> row["c"] = 2;
>>> row["d"] = 2;
>>> }
>>>
>>> if( ii == 2 ){
>>> row["a"] = 2;
>>> row["b"] = 1;
>>> row["c"] = 3;
>>> row["d"] = 3;
>>> }
>>>
>>> if( ii == 3 ){
>>> row["a"] = 2;
>>> row["b"] = 2;
>>> row["c"] = 4;
>>> row["d"] = 4;
>>> }
>>>
>>> ii++;
>>> return true
>>> ]]></method>
>>> </script-data-set>
>>> </data-sets>
>>> <styles>
>>> <style name="report" id="4">
>>> <property name="fontFamily">sans-serif</property>
>>> <property name="fontSize">10pt</property>
>>> </style>
>>> <style name="crosstab-cell" id="5">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> <style name="crosstab" id="6">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> </styles>
>>> <page-setup>
>>> <simple-master-page name="Simple MasterPage" id="2">
>>> <page-footer>
>>> <text id="3">
>>> <property name="contentType">html</property>
>>> <text-property name="content"><![CDATA[<value-of>new
>>> Date()</value-of>]]></text-property>
>>> </text>
>>> </page-footer>
>>> </simple-master-page>
>>> </page-setup>
>>> <body>
>>> <table id="9">
>>> <property name="dataSet">Data Set</property>
>>> <list-property name="boundDataColumns">
>>> <structure>
>>> <property name="name">a</property>
>>> <text-property name="displayName">a</text-property>
>>> <expression name="expression"
>>> type="javascript">dataSetRow["a"]</expression>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">b</property>
>>> <text-property name="displayName">b</text-property>
>>> <expression name="expression"
>>> type="javascript">dataSetRow["b"]</expression>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">c</property>
>>> <text-property name="displayName">c</text-property>
>>> <expression name="expression"
>>> type="javascript">dataSetRow["c"]</expression>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">d</property>
>>> <text-property name="displayName">d</text-property>
>>> <expression name="expression"
>>> type="javascript">dataSetRow["d"]</expression>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> <column id="33"/>
>>> <column id="34"/>
>>> <column id="35"/>
>>> <column id="36"/>
>>> <header>
>>> <row id="10">
>>> <cell id="11">
>>> <label id="12">
>>> <text-property name="text">a</text-property>
>>> </label>
>>> </cell>
>>> <cell id="13">
>>> <label id="14">
>>> <text-property name="text">b</text-property>
>>> </label>
>>> </cell>
>>> <cell id="15">
>>> <label id="16">
>>> <text-property name="text">c</text-property>
>>> </label>
>>> </cell>
>>> <cell id="17">
>>> <label id="18">
>>> <text-property name="text">d</text-property>
>>> </label>
>>> </cell>
>>> </row>
>>> </header>
>>> <group id="38">
>>> <property name="groupName">NewTableGroup1</property>
>>> <property name="interval">none</property>
>>> <property name="sortDirection">asc</property>
>>> <expression name="keyExpr"
>>> type="javascript">row["a"]</expression>
>>> <structure name="toc">
>>> <expression name="expressionValue"
>>> type="javascript">row["a"]</expression>
>>> </structure>
>>> <property name="repeatHeader">true</property>
>>> <property name="hideDetail">false</property>
>>> <property name="pageBreakAfter">auto</property>
>>> <property name="pageBreakBefore">auto</property>
>>> <property name="pageBreakInside">auto</property>
>>> <header>
>>> <row id="39">
>>> <cell id="40">
>>> <data id="49">
>>> <property
>>> name="resultSetColumn">a</property>
>>> </data>
>>> </cell>
>>> <cell id="41"/>
>>> <cell id="42"/>
>>> <cell id="43"/>
>>> </row>
>>> </header>
>>> <footer>
>>> <row id="44">
>>> <cell id="45">
>>> <property name="colSpan">4</property>
>>> <property name="rowSpan">1</property>
>>> <extended-item extensionName="Chart" id="37">
>>> <xml-property
>>> name="xmlRepresentation"><![CDATA[<model:ChartWithAxes
>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>> xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute"
>>> xmlns:data="http://www.birt.eclipse.org/ChartModelData"
>>> xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout"
>>> xmlns:model="http://www.birt.eclipse.org/ChartModel"
>>> xmlns:type="http://www.birt.eclipse.org/ChartModelType">
>>> <Version>2.5.1</Version>
>>> <Type>Scatter Chart</Type>
>>> <SubType>Standard Scatter Chart</SubType>
>>> <Block>
>>> <Children xsi:type="layout:TitleBlock">
>>> <Bounds>
>>> <Left>0.0</Left>
>>> <Top>0.0</Top>
>>> <Width>0.0</Width>
>>> <Height>0.0</Height>
>>> </Bounds>
>>> <Insets>
>>> <Top>3.0</Top>
>>> <Left>3.0</Left>
>>> <Bottom>3.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Row>-1</Row>
>>> <Column>-1</Column>
>>> <Rowspan>-1</Rowspan>
>>> <Columnspan>-1</Columnspan>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Visible>true</Visible>
>>> <Label>
>>> <Caption>
>>> <Value>Scatter Chart Title</Value>
>>> <Font>
>>> <Size>16.0</Size>
>>> <Bold>true</Bold>
>>> <Alignment>
>>> <horizontalAlignment>Center</horizontalAlignment>
>>> <verticalAlignment>Center</verticalAlignment>
>>> </Alignment>
>>> </Font>
>>> </Caption>
>>> <Background xsi:type="attribute:ColorDefinition">
>>> <Transparency>0</Transparency>
>>> <Red>255</Red>
>>> <Green>255</Green>
>>> <Blue>255</Blue>
>>> </Background>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> </Outline>
>>> <Insets>
>>> <Top>0.0</Top>
>>> <Left>2.0</Left>
>>> <Bottom>0.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Visible>true</Visible>
>>> </Label>
>>> </Children>
>>> <Children xsi:type="layout:Plot">
>>> <Bounds>
>>> <Left>0.0</Left>
>>> <Top>0.0</Top>
>>> <Width>0.0</Width>
>>> <Height>0.0</Height>
>>> </Bounds>
>>> <Insets>
>>> <Top>3.0</Top>
>>> <Left>3.0</Left>
>>> <Bottom>3.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Row>-1</Row>
>>> <Column>-1</Column>
>>> <Rowspan>-1</Rowspan>
>>> <Columnspan>-1</Columnspan>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Visible>true</Visible>
>>> <HorizontalSpacing>5</HorizontalSpacing>
>>> <VerticalSpacing>5</VerticalSpacing>
>>> <ClientArea>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>0</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>> Path: news.eclipse.org!not-for-mail
>> From: Helmut Neubauer<helmut.neubauer@cognidata.de>
>> Newsgroups: eclipse.birt
>> Subject: Re: Optional Y series grouping using a grouped data set
>> Date: Tue, 23 Nov 2010 09:58:18 +0100
>> Organization: EclipseCorner
>> Lines: 1476
>> Message-ID:<icfvff$pie$1@news.eclipse.org>
>> References:<icd9fp$24i$1@news.eclipse.org> <icecm8$d6u$1@news.eclipse.org>
>> NNTP-Posting-Host: pc12002.mathematik.uni-marburg.de
>> Mime-Version: 1.0
>> Content-Type: text/plain; charset=ISO-8859-15
>> Content-Transfer-Encoding: 7bit
>> X-Trace: news.eclipse.org 1290502448 26190 137.248.121.10 (23 Nov 2010 08:54:08 GMT)
>> X-Complaints-To: news@news.eclipse.org
>> NNTP-Posting-Date: Tue, 23 Nov 2010 08:54:08 +0000 (UTC)
>> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.9) Gecko/20100915 Lightning/1.0b2 Thunderbird/3.1.4
>> In-Reply-To:<icecm8$d6u$1@news.eclipse.org>
>> Xref: news.eclipse.org eclipse.birt:40043
>>
>> Hello Jason,
>>
>> thanks for your help! With your example I found the problem. I've never
>> done this before, so I forgot to set "Inherit Columns and Groups" in the
>> "Select Data" tab of my scatter chart. Now it works.
>>
>> Your support is as always great!
>> Helmut
>>
>>
>> Am 22.11.2010 19:31, schrieb Jason Weathersby:
>>> I tried to reproduce the issue. Can you take a look at the attached
>>> example?
>>>
>>> Jason
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
>>> id="1">
>>> <property name="createdBy">Eclipse BIRT Designer Version
>>> 2.5.2.v20100208 Build&lt;2.5.2.v20100210-0630></property>
>>> <property name="units">in</property>
>>> <property name="iconFile">/templates/blank_report.gif</property>
>>> <property name="bidiLayoutOrientation">ltr</property>
>>> <property name="imageDPI">96</property>
>>> <data-sources>
>>> <script-data-source name="Data Source" id="7"/>
>>> </data-sources>
>>> <data-sets>
>>> <script-data-set name="Data Set" id="8">
>>> <list-property name="resultSetHints">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">a</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">b</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">c</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">d</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> <list-property name="columnHints">
>>> <structure>
>>> <property name="columnName">a</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">b</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">c</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">d</property>
>>> </structure>
>>> </list-property>
>>> <structure name="cachedMetaData">
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">a</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">b</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">c</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">d</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> </structure>
>>> <property name="dataSource">Data Source</property>
>>> <method name="open"><![CDATA[ii=0;]]></method>
>>> <method name="fetch"><![CDATA[if( ii> 3 ) return false;
>>>
>>> if( ii == 0 ){
>>> row["a"] = 1;
>>> row["b"] = 1;
>>> row["c"] = 1;
>>> row["d"] = 1;
>>> }
>>>
>>> if( ii == 1 ){
>>> row["a"] = 1;
>>> row["b"] = 2;
>>> row["c"] = 2;
>>> row["d"] = 2;
>>> }
>>>
>>> if( ii == 2 ){
>>> row["a"] = 2;
>>> row["b"] = 1;
>>> row["c"] = 3;
>>> row["d"] = 3;
>>> }
>>>
>>> if( ii == 3 ){
>>> row["a"] = 2;
>>> row["b"] = 2;
>>> row["c"] = 4;
>>> row["d"] = 4;
>>> }
>>>
>>> ii++;
>>> return true
>>> ]]></method>
>>> </script-data-set>
>>> </data-sets>
>>> <styles>
>>> <style name="report" id="4">
>>> <property name="fontFamily">sans-serif</property>
>>> <property name="fontSize">10pt</property>
>>> </style>
>>> <style name="crosstab-cell" id="5">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> <style name="crosstab" id="6">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> </styles>
>>> <page-setup>
>>> <simple-master-page name="Simple MasterPage" id="2">
>>> <page-footer>
>>> <text id="3">
>>> <property name="contentType">html</property>
>>> <text-property name="content"><![CDATA[<value-of>new
>>> Date()</value-of>]]></text-property>
>>> </text>
>>> </page-footer>
>>> </simple-master-page>
>>> </page-setup>
>>> <body>
>>> <table id="9">
>>> <property name="dataSet">Data Set</property>
>>> <list-property name="boundDataColumns">
>>> <structure>
>>> <property name="name">a</property>
>>> <text-property name="displayName">a</text-property>
>>> <expression name="expression"
>>> type="javascript">dataSetRow["a"]</expression>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">b</property>
>>> <text-property name="displayName">b</text-property>
>>> <expression name="expression"
>>> type="javascript">dataSetRow["b"]</expression>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">c</property>
>>> <text-property name="displayName">c</text-property>
>>> <expression name="expression"
>>> type="javascript">dataSetRow["c"]</expression>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">d</property>
>>> <text-property name="displayName">d</text-property>
>>> <expression name="expression"
>>> type="javascript">dataSetRow["d"]</expression>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> <column id="33"/>
>>> <column id="34"/>
>>> <column id="35"/>
>>> <column id="36"/>
>>> <header>
>>> <row id="10">
>>> <cell id="11">
>>> <label id="12">
>>> <text-property name="text">a</text-property>
>>> </label>
>>> </cell>
>>> <cell id="13">
>>> <label id="14">
>>> <text-property name="text">b</text-property>
>>> </label>
>>> </cell>
>>> <cell id="15">
>>> <label id="16">
>>> <text-property name="text">c</text-property>
>>> </label>
>>> </cell>
>>> <cell id="17">
>>> <label id="18">
>>> <text-property name="text">d</text-property>
>>> </label>
>>> </cell>
>>> </row>
>>> </header>
>>> <group id="38">
>>> <property name="groupName">NewTableGroup1</property>
>>> <property name="interval">none</property>
>>> <property name="sortDirection">asc</property>
>>> <expression name="keyExpr"
>>> type="javascript">row["a"]</expression>
>>> <structure name="toc">
>>> <expression name="expressionValue"
>>> type="javascript">row["a"]</expression>
>>> </structure>
>>> <property name="repeatHeader">true</property>
>>> <property name="hideDetail">false</property>
>>> <property name="pageBreakAfter">auto</property>
>>> <property name="pageBreakBefore">auto</property>
>>> <property name="pageBreakInside">auto</property>
>>> <header>
>>> <row id="39">
>>> <cell id="40">
>>> <data id="49">
>>> <property
>>> name="resultSetColumn">a</property>
>>> </data>
>>> </cell>
>>> <cell id="41"/>
>>> <cell id="42"/>
>>> <cell id="43"/>
>>> </row>
>>> </header>
>>> <footer>
>>> <row id="44">
>>> <cell id="45">
>>> <property name="colSpan">4</property>
>>> <property name="rowSpan">1</property>
>>> <extended-item extensionName="Chart" id="37">
>>> <xml-property
>>> name="xmlRepresentation"><![CDATA[<model:ChartWithAxes
>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>> xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute"
>>> xmlns:data="http://www.birt.eclipse.org/ChartModelData"
>>> xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout"
>>> xmlns:model="http://www.birt.eclipse.org/ChartModel"
>>> xmlns:type="http://www.birt.eclipse.org/ChartModelType">
>>> <Version>2.5.1</Version>
>>> <Type>Scatter Chart</Type>
>>> <SubType>Standard Scatter Chart</SubType>
>>> <Block>
>>> <Children xsi:type="layout:TitleBlock">
>>> <Bounds>
>>> <Left>0.0</Left>
>>> <Top>0.0</Top>
>>> <Width>0.0</Width>
>>> <Height>0.0</Height>
>>> </Bounds>
>>> <Insets>
>>> <Top>3.0</Top>
>>> <Left>3.0</Left>
>>> <Bottom>3.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Row>-1</Row>
>>> <Column>-1</Column>
>>> <Rowspan>-1</Rowspan>
>>> <Columnspan>-1</Columnspan>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Visible>true</Visible>
>>> <Label>
>>> <Caption>
>>> <Value>Scatter Chart Title</Value>
>>> <Font>
>>> <Size>16.0</Size>
>>> <Bold>true</Bold>
>>> <Alignment>
>>> <horizontalAlignment>Center</horizontalAlignment>
>>> <verticalAlignment>Center</verticalAlignment>
>>> </Alignment>
>>> </Font>
>>> </Caption>
>>> <Background xsi:type="attribute:ColorDefinition">
>>> <Transparency>0</Transparency>
>>> <Red>255</Red>
>>> <Green>255</Green>
>>> <Blue>255</Blue>
>>> </Background>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> </Outline>
>>> <Insets>
>>> <Top>0.0</Top>
>>> <Left>2.0</Left>
>>> <Bottom>0.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Visible>true</Visible>
>>> </Label>
>>> </Children>
>>> <Children xsi:type="layout:Plot">
>>> <Bounds>
>>> <Left>0.0</Left>
>>> <Top>0.0</Top>
>>> <Width>0.0</Width>
>>> <Height>0.0</Height>
>>> </Bounds>
>>> <Insets>
>>> <Top>3.0</Top>
>>> <Left>3.0</Left>
>>> <Bottom>3.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Row>-1</Row>
>>> <Column>-1</Column>
>>> <Rowspan>-1</Rowspan>
>>> <Columnspan>-1</Columnspan>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Visible>true</Visible>
>>> <HorizontalSpacing>5</HorizontalSpacing>
>>> <VerticalSpacing>5</VerticalSpacing>
>>> <ClientArea>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>0</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Insets>
>>> <Top>0.0</Top>
>>> <Left>0.0</Left>
>>> <Bottom>0.0</Bottom>
>>> <Right>0.0</Right>
>>> </Insets>
>>> </ClientArea>
>>> </Children>
>>> <Children xsi:type="layout:Legend">
>>> <Bounds>
>>> <Left>0.0</Left>
>>> <Top>0.0</Top>
>>> <Width>0.0</Width>
>>> <Height>0.0</Height>
>>> </Bounds>
>>> <Insets>
>>> <Top>3.0</Top>
>>> <Left>3.0</Left>
>>> <Bottom>3.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Row>-1</Row>
>>> <Column>-1</Column>
>>> <Rowspan>-1</Rowspan>
>>> <Columnspan>-1</Columnspan>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Visible>true</Visible>
>>> <ClientArea>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>0</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Insets>
>>> <Top>2.0</Top>
>>> <Left>2.0</Left>
>>> <Bottom>2.0</Bottom>
>>> <Right>2.0</Right>
>>> </Insets>
>>> </ClientArea>
>>> <Text>
>>> <Value></Value>
>>> <Font>
>>> <Alignment/>
>>> </Font>
>>> </Text>
>>> <Orientation>Vertical</Orientation>
>>> <Direction>Top_Bottom</Direction>
>>> <Separator>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>true</Visible>
>>> </Separator>
>>> <Position>Right</Position>
>>> <ItemType>Series</ItemType>
>>> <Title>
>>> <Caption>
>>> <Value></Value>
>>> <Font>
>>> <Alignment/>
>>> </Font>
>>> </Caption>
>>> <Background xsi:type="attribute:ColorDefinition">
>>> <Transparency>0</Transparency>
>>> <Red>255</Red>
>>> <Green>255</Green>
>>> <Blue>255</Blue>
>>> </Background>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Insets>
>>> <Top>0.0</Top>
>>> <Left>2.0</Left>
>>> <Bottom>0.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Visible>false</Visible>
>>> </Title>
>>> <TitlePosition>Above</TitlePosition>
>>> </Children>
>>> <Bounds>
>>> <Left>0.0</Left>
>>> <Top>0.0</Top>
>>> <Width>555.0</Width>
>>> <Height>228.0</Height>
>>> </Bounds>
>>> <Insets>
>>> <Top>3.0</Top>
>>> <Left>3.0</Left>
>>> <Bottom>3.0</Bottom>
>>> <Right>3.0</Right>
>>> </Insets>
>>> <Row>-1</Row>
>>> <Column>-1</Column>
>>> <Rowspan>-1</Rowspan>
>>> <Columnspan>-1</Columnspan>
>>> <Outline>
>>> <Style>Solid</Style>
>>> <Thickness>1</Thickness>
>>> <Color>
>>> <Transparency>255</Transparency>
>>> <Red>0</Red>
>>> <Green>0</Green>
>>> <Blue>0</Blue>
>>> </Color>
>>> <Visible>false</Visible>
>>> </Outline>
>>> <Background xsi:type="attribute:ColorDefinition">
>>> <Transparency>255</Transparency>
>>> <Red>255</Red>
>>> <Gre
Previous Topic:Error: <unused> is not recognized! by using version 2.6.1
Next Topic:BIRT designer perspective using two windows
Goto Forum:
  


Current Time: Thu Mar 28 13:13:43 GMT 2024

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

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

Back to the top