Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Bar charts width
Bar charts width [message #367583] Mon, 23 March 2009 17:58 Go to next message
Christophe is currently offline ChristopheFriend
Messages: 15
Registered: July 2009
Junior Member
Hi all,

I have a question about bar charts.
Can I set the width of bars (Y series) ?

Thanks.

Chris.

Report message to a moderator

Re: Bar charts width [message #367595 is a reply to message #367583] Tue, 24 March 2009 18:53 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Chris,

If you are wanting to set this dynamically see:
http://birtworld.blogspot.com/2008/04/birt-resizing-charts.h tml

Jason

Chris wrote:
> Hi all,
>
> I have a question about bar charts.
> Can I set the width of bars (Y series) ?
>
> Thanks.
>
> Chris.
>
>

Report message to a moderator

Re: Bar charts width [message #367615 is a reply to message #367595] Thu, 26 March 2009 09:34 Go to previous messageGo to next message
Christophe is currently offline ChristopheFriend
Messages: 15
Registered: July 2009
Junior Member
Thank Jason, but I want to set the width of BARS, not the whole chart.

Any ideas ?

Thanks.

Jason Weathersby a écrit :
> Chris,
>
> If you are wanting to set this dynamically see:
> http://birtworld.blogspot.com/2008/04/birt-resizing-charts.h tml
>
> Jason
>
> Chris wrote:
>> Hi all,
>>
>> I have a question about bar charts.
>> Can I set the width of bars (Y series) ?
>>
>> Thanks.
>>
>> Chris.
>>
>>

Report message to a moderator

Re: Bar charts width [message #367617 is a reply to message #367615] Thu, 26 March 2009 16:35 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Chris,

Not sure if this is what you want but attached is an example of two bar
series of different sizes. It uses the following script:
function beforeGeneration( chart, context )
{
chart.setUnitSpacing(20);
}
var oldSpacing;
function beforeDrawSeries( series, seriesRenderer, context )

{
oldSpacing = context.getChartInstance().getUnitSpacing();
if( series.getSeriesIdentifier() == "series one" ){
context.getChartInstance().setUnitSpacing(70);
}
}

function afterDrawSeries( series, seriesRenderer, context )
{
context.getChartInstance().setUnitSpacing(oldSpacing);
}

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
Name here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="6">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="7">
<list-property name="columnHints">
<structure>
<property name="columnName">CUSTOMERNAME</property>
<property name="displayName">CUSTOMERNAME</property>
</structure>
<structure>
<property name="columnName">CUSTOMERNUMBER</property>
<property name="displayName">CUSTOMERNUMBER</property>
</structure>
<structure>
<property name="columnName">CUSTOMERTOTAL</property>
<property name="displayName">CUSTOMERTOTAL</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNAME</property>
<property name="nativeName">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="nativeName">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">select CUSTOMERS.CUSTOMERNAME,
CUSTOMERS.CUSTOMERNUMBER,
sum(ORDERDETAILS.QUANTITYORDERED *
ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
from CUSTOMERS, ORDERS, ORDERDETAILS
where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER
and ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER
order by CUSTOMERTOTAL</property>
<xml-property name="designerValues"><![CDATA[<?xml
version="1.0" encoding="UTF-8"?>
<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMERNAME</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CUSTOMERNAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMERNAME</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMERNUMBER</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CUSTOMERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMERTOTAL</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CUSTOMERTOTAL</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMERTOTAL</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property
name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<extended-item extensionName="Chart" name="NewChart" id="8">
<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">
<Type>Bar Chart</Type>
<SubType>Side-by-side</SubType>
<Description>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Description>
<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>Bar 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>Categories</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>433.49999999759996</Width>
<Height>276.75</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>
</Block>
<Dimension>Two_Dimensional</Dimension>
<Script>function beforeGeneration( chart, context )&#xD;
{&#xD;
chart.setUnitSpacing(20);&#xD;
}&#xD;
var oldSpacing;&#xD;
function beforeDrawSeries( series, seriesRenderer, context )&#xD;
&#xD;
{ &#xD;
oldSpacing = context.getChartInstance().getUnitSpacing();&#xD;
if( series.getSeriesIdentifier() == &quot;series one&quot; ){&#xD;
context.getChartInstance().setUnitSpacing(70);&#xD;
}&#xD;
}&#xD;
&#xD;
function afterDrawSeries( series, seriesRenderer, context )&#xD;
{&#xD;
context.getChartInstance().setUnitSpacing(oldSpacing);&# xD;
}</Script>
<Units>Points</Units>
<SeriesThickness>10.0</SeriesThickness>
<SampleData>
<BaseSampleData>
<DataSetRepresentation>A, B, C</DataSetRepresentation>
</BaseSampleData>
<OrthogonalSampleData>
<DataSetRepresentation>5,4,12</DataSetRepresentation>
<SeriesDefinitionIndex>0</SeriesDefinitionIndex>
</OrthogonalSampleData>
<OrthogonalSampleData>
<DataSetRepresentation>10.0,8.0,24.0</DataSetRepresentation >
<SeriesDefinitionIndex>1</SeriesDefinitionIndex>
</OrthogonalSampleData>
</SampleData>
<Interactivity/>
<Axes>
<Type>Text</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></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 xsi:type="type:BarSeries">
<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>true</Visible>
</Label>
<DataDefinition>
<Definition>row[&quot;CUSTOMERTOTAL&quot;]</Definition >
</DataDefinition>
<SeriesIdentifier>series one</SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Outside</LabelPosition>
<Stacked>false</Stacked>
<Riser>Rectangle</Riser>
</Series>
<Grouping>
<Enabled>false</Enabled>
<GroupingInterval>2</GroupingInterval>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
<Sorting>Ascending</Sorting>
</SeriesDefinitions>
<SeriesDefinitions>
<Query>
<Definition></Definition>
</Query>
<SeriesPalette>
<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>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>166</Green>
<Blue>218</Blue>
</Entries>
</SeriesPalette>
<Series xsi:type="type:BarSeries">
<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>true</Visible>
</Label>
<DataDefinition>
<Definition>row[&quot;CUSTOMERTOTAL&quot;]/10</Definition >
</DataDefinition>
<SeriesIdentifier>series two</SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Outside</LabelPosition>
<Stacked>false</Stacked>
<Riser>Rectangle</Riser>
</Series>
<Grouping>
<Enabled>false</Enabled>
<GroupingInterval>2</GroupingInterval>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</SeriesDefinitions>
<Orientation>Vertical</Orientation>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<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><

Report message to a moderator

Re: Bar charts width [message #367712 is a reply to message #367617] Thu, 02 April 2009 15:16 Go to previous messageGo to next message
Christophe is currently offline ChristopheFriend
Messages: 15
Registered: July 2009
Junior Member
This is a multi-part message in MIME format.
--------------050407060301070506000909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Thank Jason for your solution but in my case it's more difficult because
in my report, each chart has much bars, and I don't know the number of
bars ! (See attached files)

I think the best way is to always fix the width of the bars, for all
charts... Can I do that ?

Do you have any other solutions ?

cheers.


Jason Weathersby a

Report message to a moderator

Re: Bar charts width [message #367733 is a reply to message #367712] Mon, 06 April 2009 15:24 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Chris,

You can get the number of bars by using a script in the after data set
filled I believe. Other than that it may be a good idea to log an
enhancement bug for this.

Jason

Chris wrote:
> Thank Jason for your solution but in my case it's more difficult because
> in my report, each chart has much bars, and I don't know the number of
> bars ! (See attached files)
>
> I think the best way is to always fix the width of the bars, for all
> charts... Can I do that ?
>
> Do you have any other solutions ?
>
> cheers.
>
>
> Jason Weathersby a écrit :
>> Chris,
>>
>> Not sure if this is what you want but attached is an example of two
>> bar series of different sizes. It uses the following script:
>> function beforeGeneration( chart, context )
>> {
>> chart.setUnitSpacing(20);
>> }
>> var oldSpacing;
>> function beforeDrawSeries( series, seriesRenderer, context )
>>
>> { oldSpacing = context.getChartInstance().getUnitSpacing();
>> if( series.getSeriesIdentifier() == "series one" ){
>> context.getChartInstance().setUnitSpacing(70);
>> }
>> }
>>
>> function afterDrawSeries( series, seriesRenderer, context )
>> {
>> context.getChartInstance().setUnitSpacing(oldSpacing);
>> }
>>
>> Jason
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>> version="3.2.15" id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
>> <property name="units">in</property>
>> <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
>> Name here>></property>
>> <html-property name="description">Creates a blank report with no
>> predefined content.</html-property>
>> <text-property name="displayName">Blank Report</text-property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <data-sources>
>> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
>> id="6">
>> <property
>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>
>> <property
>> name="odaURL">jdbc:classicmodels:sampledb</property>
>> <property name="odaUser">ClassicModels</property>
>> </oda-data-source>
>> </data-sources>
>> <data-sets>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Data Set" id="7">
>> <list-property name="columnHints">
>> <structure>
>> <property name="columnName">CUSTOMERNAME</property>
>> <property name="displayName">CUSTOMERNAME</property>
>> </structure>
>> <structure>
>> <property name="columnName">CUSTOMERNUMBER</property>
>> <property
>> name="displayName">CUSTOMERNUMBER</property>
>> </structure>
>> <structure>
>> <property name="columnName">CUSTOMERTOTAL</property>
>> <property name="displayName">CUSTOMERTOTAL</property>
>> </structure>
>> </list-property>
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">CUSTOMERNAME</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">CUSTOMERTOTAL</property>
>> <property name="dataType">float</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">CUSTOMERNAME</property>
>> <property name="nativeName">CUSTOMERNAME</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="nativeName">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">CUSTOMERTOTAL</property>
>> <property name="nativeName">CUSTOMERTOTAL</property>
>> <property name="dataType">float</property>
>> <property name="nativeDataType">8</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select CUSTOMERS.CUSTOMERNAME,
>> CUSTOMERS.CUSTOMERNUMBER,
>> sum(ORDERDETAILS.QUANTITYORDERED *
>> ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
>> from CUSTOMERS, ORDERS, ORDERDETAILS
>> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER
>> and ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
>> group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER
>> order by CUSTOMERTOTAL</property>
>> <xml-property name="designerValues"><![CDATA[<?xml
>> version="1.0" encoding="UTF-8"?>
>> <model:DesignValues
>> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
>> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
>> <Version>1.0</Version>
>> <design:ResultSets derivedMetaData="true">
>> <design:resultSetDefinitions>
>> <design:resultSetColumns>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>CUSTOMERNAME</design:name>
>> <design:position>1</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>CUSTOMERNAME</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>CUSTOMERNAME</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>CUSTOMERNUMBER</design:name>
>> <design:position>2</design:position>
>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>CUSTOMERNUMBER</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>CUSTOMERNUMBER</design:label>
>> <design:formattingHints>
>> <design:displaySize>11</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>CUSTOMERTOTAL</design:name>
>> <design:position>3</design:position>
>> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>> <design:precision>15</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>CUSTOMERTOTAL</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>CUSTOMERTOTAL</design:label>
>> <design:formattingHints>
>> <design:displaySize>22</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> </design:resultSetColumns>
>> </design:resultSetDefinitions>
>> </design:ResultSets>
>> </model:DesignValues>]]></xml-property>
>> </oda-data-set>
>> </data-sets>
>> <styles>
>> <style name="crosstab" id="4">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab-cell" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> </styles>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <page-footer>
>> <text id="3">
>> <property name="contentType">html</property>
>> <text-property
>> name="content"><![CDATA[<value-of>new
>> Date()</value-of>]]></text-property>
>> </text>
>> </page-footer>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <extended-item extensionName="Chart" name="NewChart" id="8">
>> <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">
>> <Type>Bar Chart</Type>
>> <SubType>Side-by-side</SubType>
>> <Description>
>> <Value></Value>
>> <Font>
>> <Alignment/>
>> </Font>
>> </Description>
>> <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>Bar 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>Categories</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>433.49999999759996</Width>
>> <Height>276.75</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>
>> </Block>
>> <Dimension>Two_Dimensional</Dimension>
>> <Script>function beforeGeneration( chart, context )&#xD;
>> {&#xD;
>> chart.setUnitSpacing(20);&#xD;
>> }&#xD;
>> var oldSpacing;&#xD;
>> function beforeDrawSeries( series, seriesRenderer, context )&#xD;
>> &#xD;
>> { &#xD;
>> oldSpacing = context.getChartInstance().getUnitSpacing();&#xD;
>> if( series.getSeriesIdentifier() == &quot;series one&quot; ){&#xD;
>> context.getChartInstance().setUnitSpacing(70);&#xD;
>> }&#xD;
>> }&#xD;
>> &#xD;
>> function afterDrawSeries( series, seriesRenderer, context )&#xD;
>> {&#xD;
>> context.getChartInstance().setUnitSpacing(oldSpacing);&# xD;
>> }</Script>
>> <Units>Points</Units>
>> <SeriesThickness>10.0</SeriesThickness>
>> <SampleData>
>> <BaseSampleData>
>> <DataSetRepresentation>A, B, C</DataSetRepresentation>
>> </BaseSampleData>
>> <OrthogonalSampleData>
>> <DataSetRepresentation>5,4,12</DataSetRepresentation>
>> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>> </OrthogonalSampleData>
>> <OrthogonalSampleData>
>> <DataSetRepresentation>10.0,8.0,24.0</DataSetRepresentation >
>> <SeriesDefinitionIndex>1</SeriesDefinitionIndex>
>> </OrthogonalSampleData>
>> </SampleData>
>> <Interactivity/>
>> <Axes>
>> <Type>Text</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></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 xsi:type="type:BarSeries">
>> <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>true</Visible>
>> </Label>
>> <DataDefinition>
>> <Definition>row[&quot;CUSTOMERTOTAL&quot;]</Definition >
>> </DataDefinition>
>> <SeriesIdentifier>series one</SeriesIdentifier>
>> <DataPoint>
>> <Components>
>> <Type>Orthogonal_Value</Type>
>> </Components>
>> <Separator>, </Separator>
>> </DataPoint>
>> <LabelPosition>Outside</LabelPosition>
>> <Stacked>false</Stacked>
>> <Riser>Rectangle</Riser>
>> </Series>
>> <Grouping>
>> <Enabled>false</Enabled>
>> <GroupingInterval>2</GroupingInterval>
>> <GroupType>Text</GroupType>
>> <AggregateExpression>Sum</AggregateExpression>
>> </Grouping>
>> <Sorting>Ascending</Sorting>
>> </SeriesDefinitions>
>> <SeriesDefinitions>
>> <Query>
>> <Definition></Definition>
>> </Query>
>> <SeriesPalette>
>> <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="attribut

Report message to a moderator

Re: Bar charts width [message #367795 is a reply to message #367733] Wed, 08 April 2009 17:11 Go to previous messageGo to next message
Christophe is currently offline ChristopheFriend
Messages: 15
Registered: July 2009
Junior Member
Jason,

Could you help me to do that please ?

"You can get the number of bars by using a *script* in the after data
set filled I believe".


Chris.


Jason Weathersby a écrit :
> Chris,
>
> You can get the number of bars by using a script in the after data set
> filled I believe. Other than that it may be a good idea to log an
> enhancement bug for this.
>
> Jason
>
> Chris wrote:
>> Thank Jason for your solution but in my case it's more difficult
>> because in my report, each chart has much bars, and I don't know the
>> number of bars ! (See attached files)
>>
>> I think the best way is to always fix the width of the bars, for all
>> charts... Can I do that ?
>>
>> Do you have any other solutions ?
>>
>> cheers.
>>
>>
>> Jason Weathersby a écrit :
>>> Chris,
>>>
>>> Not sure if this is what you want but attached is an example of two
>>> bar series of different sizes. It uses the following script:
>>> function beforeGeneration( chart, context )
>>> {
>>> chart.setUnitSpacing(20);
>>> }
>>> var oldSpacing;
>>> function beforeDrawSeries( series, seriesRenderer, context )
>>>
>>> { oldSpacing = context.getChartInstance().getUnitSpacing();
>>> if( series.getSeriesIdentifier() == "series one" ){
>>> context.getChartInstance().setUnitSpacing(70);
>>> }
>>> }
>>>
>>> function afterDrawSeries( series, seriesRenderer, context )
>>> {
>>> context.getChartInstance().setUnitSpacing(oldSpacing);
>>> }
>>>
>>> Jason
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>>> version="3.2.15" id="1">
>>> <property name="createdBy">Eclipse BIRT Designer Version
>>> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
>>> <property name="units">in</property>
>>> <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
>>> Name here>></property>
>>> <html-property name="description">Creates a blank report with no
>>> predefined content.</html-property>
>>> <text-property name="displayName">Blank Report</text-property>
>>> <property name="iconFile">/templates/blank_report.gif</property>
>>> <data-sources>
>>> <oda-data-source
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data
>>> Source" id="6">
>>> <property
>>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>>
>>> <property
>>> name="odaURL">jdbc:classicmodels:sampledb</property>
>>> <property name="odaUser">ClassicModels</property>
>>> </oda-data-source>
>>> </data-sources>
>>> <data-sets>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="Data Set" id="7">
>>> <list-property name="columnHints">
>>> <structure>
>>> <property name="columnName">CUSTOMERNAME</property>
>>> <property name="displayName">CUSTOMERNAME</property>
>>> </structure>
>>> <structure>
>>> <property
>>> name="columnName">CUSTOMERNUMBER</property>
>>> <property
>>> name="displayName">CUSTOMERNUMBER</property>
>>> </structure>
>>> <structure>
>>> <property name="columnName">CUSTOMERTOTAL</property>
>>> <property
>>> name="displayName">CUSTOMERTOTAL</property>
>>> </structure>
>>> </list-property>
>>> <structure name="cachedMetaData">
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">CUSTOMERNAME</property>
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">CUSTOMERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">CUSTOMERTOTAL</property>
>>> <property name="dataType">float</property>
>>> </structure>
>>> </list-property>
>>> </structure>
>>> <property name="dataSource">Data Source</property>
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">CUSTOMERNAME</property>
>>> <property name="nativeName">CUSTOMERNAME</property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">12</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">CUSTOMERNUMBER</property>
>>> <property
>>> name="nativeName">CUSTOMERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">CUSTOMERTOTAL</property>
>>> <property name="nativeName">CUSTOMERTOTAL</property>
>>> <property name="dataType">float</property>
>>> <property name="nativeDataType">8</property>
>>> </structure>
>>> </list-property>
>>> <property name="queryText">select CUSTOMERS.CUSTOMERNAME,
>>> CUSTOMERS.CUSTOMERNUMBER,
>>> sum(ORDERDETAILS.QUANTITYORDERED *
>>> ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
>>> from CUSTOMERS, ORDERS, ORDERDETAILS
>>> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER
>>> and ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
>>> group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER
>>> order by CUSTOMERTOTAL</property>
>>> <xml-property name="designerValues"><![CDATA[<?xml
>>> version="1.0" encoding="UTF-8"?>
>>> <model:DesignValues
>>> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
>>> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
>>> <Version>1.0</Version>
>>> <design:ResultSets derivedMetaData="true">
>>> <design:resultSetDefinitions>
>>> <design:resultSetColumns>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>CUSTOMERNAME</design:name>
>>> <design:position>1</design:position>
>>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>>> <design:precision>50</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>CUSTOMERNAME</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>CUSTOMERNAME</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>50</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>CUSTOMERNUMBER</design:name>
>>> <design:position>2</design:position>
>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>> <design:precision>10</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>CUSTOMERNUMBER</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>CUSTOMERNUMBER</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>11</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> <design:resultColumnDefinitions>
>>> <design:attributes>
>>> <design:name>CUSTOMERTOTAL</design:name>
>>> <design:position>3</design:position>
>>> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>>> <design:precision>15</design:precision>
>>> <design:scale>0</design:scale>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints>
>>> <design:displayName>CUSTOMERTOTAL</design:displayName>
>>> </design:uiHints>
>>> </design:attributes>
>>> <design:usageHints>
>>> <design:label>CUSTOMERTOTAL</design:label>
>>> <design:formattingHints>
>>> <design:displaySize>22</design:displaySize>
>>> </design:formattingHints>
>>> </design:usageHints>
>>> </design:resultColumnDefinitions>
>>> </design:resultSetColumns>
>>> </design:resultSetDefinitions>
>>> </design:ResultSets>
>>> </model:DesignValues>]]></xml-property>
>>> </oda-data-set>
>>> </data-sets>
>>> <styles>
>>> <style name="crosstab" id="4">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> <style name="crosstab-cell" id="5">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> </styles>
>>> <page-setup>
>>> <simple-master-page name="Simple MasterPage" id="2">
>>> <page-footer>
>>> <text id="3">
>>> <property name="contentType">html</property>
>>> <text-property
>>> name="content"><![CDATA[<value-of>new
>>> Date()</value-of>]]></text-property>
>>> </text>
>>> </page-footer>
>>> </simple-master-page>
>>> </page-setup>
>>> <body>
>>> <extended-item extensionName="Chart" name="NewChart" id="8">
>>> <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">
>>> <Type>Bar Chart</Type>
>>> <SubType>Side-by-side</SubType>
>>> <Description>
>>> <Value></Value>
>>> <Font>
>>> <Alignment/>
>>> </Font>
>>> </Description>
>>> <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>Bar 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>Categories</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>433.49999999759996</Width>
>>> <Height>276.75</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>
>>> </Block>
>>> <Dimension>Two_Dimensional</Dimension>
>>> <Script>function beforeGeneration( chart, context )&#xD;
>>> {&#xD;
>>> chart.setUnitSpacing(20);&#xD;
>>> }&#xD;
>>> var oldSpacing;&#xD;
>>> function beforeDrawSeries( series, seriesRenderer, context )&#xD;
>>> &#xD;
>>> { &#xD;
>>> oldSpacing = context.getChartInstance().getUnitSpacing();&#xD;
>>> if( series.getSeriesIdentifier() == &quot;series one&quot; ){&#xD;
>>> context.getChartInstance().setUnitSpacing(70);&#xD;
>>> }&#xD;
>>> }&#xD;
>>> &#xD;
>>> function afterDrawSeries( series, seriesRenderer, context )&#xD;
>>> {&#xD;
>>> context.getChartInstance().setUnitSpacing(oldSpacing);&# xD;
>>> }</Script>
>>> <Units>Points</Units>
>>> <SeriesThickness>10.0</SeriesThickness>
>>> <SampleData>
>>> <BaseSampleData>
>>> <DataSetRepresentation>A, B, C</DataSetRepresentation>
>>> </BaseSampleData>
>>> <OrthogonalSampleData>
>>> <DataSetRepresentation>5,4,12</DataSetRepresentation>
>>> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>>> </OrthogonalSampleData>
>>> <OrthogonalSampleData>
>>> <DataSetRepresentation>10.0,8.0,24.0</DataSetRepresentation >
>>> <SeriesDefinitionIndex>1</SeriesDefinitionIndex>
>>> </OrthogonalSampleData>
>>> </SampleData>
>>> <Interactivity/>
>>> <Axes>
>>> <Type>Text</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></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 xsi:type="type:BarSeries">
>>> <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>true</Visible>
>>> </Label>
>>> <DataDefinition>
>>> <Definition>row[&quot;CUSTOMERTOTAL&quot;]</Definition >
>>> </DataDefinition>
>>> <SeriesIdentifier>series one</SeriesIdentifier>
>>> <DataPoint>
>>> <Components>
>>> <Type>Orthogonal_Value</Type>
>>> </Components>
>>> <Separator>, </Separator>
>>> </DataPoint>
>>> <LabelPosition>Outside</LabelPosition>
>>> <Stacked>false</Stacked>
>>> <Riser>Rectangle</Riser>
>>> </Series>
>>> <Grouping>
>>> <Enabled>false</Enabled>
>>> <GroupingInterval>2</GroupingInterval>
>>> <GroupType>Text</GroupType>
>>> <AggregateExpression>Sum</AggregateExpression>
>>> </Grouping>
>>> <Sorting>Ascending</Sorting>
>>> </SeriesDefinitions>
>>> <SeriesDefinitions>
>>> <Query>
>>> <Definition></Definition>
>>> </Query>
>>> <SeriesPalette>
>>> <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>
>>>

Report message to a moderator

Re: Bar charts width [message #367804 is a reply to message #367795] Wed, 08 April 2009 18:56 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Chris,

Sorry I just saw this.

In the afterdataset filled event do something like:

barcnt = 0;
function afterDataSetFilled(series, dataSet, icsc)
{
importPackage( Packages.java.io );
importPackage( Packages.org.eclipse.birt.chart.model.type.impl );

if( series.getClass() == LineSeriesImpl ){
series.getLineAttributes().setThickness(5);
}
if( series.getClass() == BarSeriesImpl ){
if( series.getSeriesIdentifier() == "mybar" ){
var list = dataSet.getValues();
barcnt = list.length;
}


}


}
Noticed that I named my series to mybar in the third tab of the chart
wizard. I can then add this count to the y axis label like:

function beforeDrawAxisTitle( axis, label, icsc )
{
importPackage(Packages.org.eclipse.birt.chart.model.attribut e);
if (axis.getType() == AxisType.LINEAR_LITERAL)
{
label.getCaption( ).setValue( "Total Bars = " + barcnt);
}
}

Jason

Chris wrote:
> Jason,
>
> Could you help me to do that please ?
>
> "You can get the number of bars by using a *script* in the after data
> set filled I believe".
>
>
> Chris.
>
>
> Jason Weathersby a écrit :
>> Chris,
>>
>> You can get the number of bars by using a script in the after data set
>> filled I believe. Other than that it may be a good idea to log an
>> enhancement bug for this.
>>
>> Jason
>>
>> Chris wrote:
>>> Thank Jason for your solution but in my case it's more difficult
>>> because in my report, each chart has much bars, and I don't know the
>>> number of bars ! (See attached files)
>>>
>>> I think the best way is to always fix the width of the bars, for all
>>> charts... Can I do that ?
>>>
>>> Do you have any other solutions ?
>>>
>>> cheers.
>>>
>>>
>>> Jason Weathersby a écrit :
>>>> Chris,
>>>>
>>>> Not sure if this is what you want but attached is an example of two
>>>> bar series of different sizes. It uses the following script:
>>>> function beforeGeneration( chart, context )
>>>> {
>>>> chart.setUnitSpacing(20);
>>>> }
>>>> var oldSpacing;
>>>> function beforeDrawSeries( series, seriesRenderer, context )
>>>>
>>>> { oldSpacing = context.getChartInstance().getUnitSpacing();
>>>> if( series.getSeriesIdentifier() == "series one" ){
>>>> context.getChartInstance().setUnitSpacing(70);
>>>> }
>>>> }
>>>>
>>>> function afterDrawSeries( series, seriesRenderer, context )
>>>> {
>>>> context.getChartInstance().setUnitSpacing(oldSpacing);
>>>> }
>>>>
>>>> Jason
>>>>
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>>>> version="3.2.15" id="1">
>>>> <property name="createdBy">Eclipse BIRT Designer Version
>>>> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
>>>> <property name="units">in</property>
>>>> <property name="comments">Copyright (c) 2007 &lt;&lt;Your
>>>> Company Name here>></property>
>>>> <html-property name="description">Creates a blank report with no
>>>> predefined content.</html-property>
>>>> <text-property name="displayName">Blank Report</text-property>
>>>> <property name="iconFile">/templates/blank_report.gif</property>
>>>> <data-sources>
>>>> <oda-data-source
>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data
>>>> Source" id="6">
>>>> <property
>>>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>>>
>>>> <property
>>>> name="odaURL">jdbc:classicmodels:sampledb</property>
>>>> <property name="odaUser">ClassicModels</property>
>>>> </oda-data-source>
>>>> </data-sources>
>>>> <data-sets>
>>>> <oda-data-set
>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>>> name="Data Set" id="7">
>>>> <list-property name="columnHints">
>>>> <structure>
>>>> <property name="columnName">CUSTOMERNAME</property>
>>>> <property
>>>> name="displayName">CUSTOMERNAME</property>
>>>> </structure>
>>>> <structure>
>>>> <property
>>>> name="columnName">CUSTOMERNUMBER</property>
>>>> <property
>>>> name="displayName">CUSTOMERNUMBER</property>
>>>> </structure>
>>>> <structure>
>>>> <property
>>>> name="columnName">CUSTOMERTOTAL</property>
>>>> <property
>>>> name="displayName">CUSTOMERTOTAL</property>
>>>> </structure>
>>>> </list-property>
>>>> <structure name="cachedMetaData">
>>>> <list-property name="resultSet">
>>>> <structure>
>>>> <property name="position">1</property>
>>>> <property name="name">CUSTOMERNAME</property>
>>>> <property name="dataType">string</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">2</property>
>>>> <property name="name">CUSTOMERNUMBER</property>
>>>> <property name="dataType">integer</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">3</property>
>>>> <property name="name">CUSTOMERTOTAL</property>
>>>> <property name="dataType">float</property>
>>>> </structure>
>>>> </list-property>
>>>> </structure>
>>>> <property name="dataSource">Data Source</property>
>>>> <list-property name="resultSet">
>>>> <structure>
>>>> <property name="position">1</property>
>>>> <property name="name">CUSTOMERNAME</property>
>>>> <property name="nativeName">CUSTOMERNAME</property>
>>>> <property name="dataType">string</property>
>>>> <property name="nativeDataType">12</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">2</property>
>>>> <property name="name">CUSTOMERNUMBER</property>
>>>> <property
>>>> name="nativeName">CUSTOMERNUMBER</property>
>>>> <property name="dataType">integer</property>
>>>> <property name="nativeDataType">4</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="position">3</property>
>>>> <property name="name">CUSTOMERTOTAL</property>
>>>> <property
>>>> name="nativeName">CUSTOMERTOTAL</property>
>>>> <property name="dataType">float</property>
>>>> <property name="nativeDataType">8</property>
>>>> </structure>
>>>> </list-property>
>>>> <property name="queryText">select CUSTOMERS.CUSTOMERNAME,
>>>> CUSTOMERS.CUSTOMERNUMBER,
>>>> sum(ORDERDETAILS.QUANTITYORDERED *
>>>> ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
>>>> from CUSTOMERS, ORDERS, ORDERDETAILS
>>>> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER
>>>> and ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
>>>> group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER
>>>> order by CUSTOMERTOTAL</property>
>>>> <xml-property name="designerValues"><![CDATA[<?xml
>>>> version="1.0" encoding="UTF-8"?>
>>>> <model:DesignValues
>>>> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
>>>> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
>>>>
>>>> <Version>1.0</Version>
>>>> <design:ResultSets derivedMetaData="true">
>>>> <design:resultSetDefinitions>
>>>> <design:resultSetColumns>
>>>> <design:resultColumnDefinitions>
>>>> <design:attributes>
>>>> <design:name>CUSTOMERNAME</design:name>
>>>> <design:position>1</design:position>
>>>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>>>> <design:precision>50</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>CUSTOMERNAME</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>CUSTOMERNAME</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>50</design:displaySize>
>>>> </design:formattingHints>
>>>> </design:usageHints>
>>>> </design:resultColumnDefinitions>
>>>> <design:resultColumnDefinitions>
>>>> <design:attributes>
>>>> <design:name>CUSTOMERNUMBER</design:name>
>>>> <design:position>2</design:position>
>>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>>> <design:precision>10</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>CUSTOMERNUMBER</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>CUSTOMERNUMBER</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>11</design:displaySize>
>>>> </design:formattingHints>
>>>> </design:usageHints>
>>>> </design:resultColumnDefinitions>
>>>> <design:resultColumnDefinitions>
>>>> <design:attributes>
>>>> <design:name>CUSTOMERTOTAL</design:name>
>>>> <design:position>3</design:position>
>>>> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>>>> <design:precision>15</design:precision>
>>>> <design:scale>0</design:scale>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints>
>>>> <design:displayName>CUSTOMERTOTAL</design:displayName>
>>>> </design:uiHints>
>>>> </design:attributes>
>>>> <design:usageHints>
>>>> <design:label>CUSTOMERTOTAL</design:label>
>>>> <design:formattingHints>
>>>> <design:displaySize>22</design:displaySize>
>>>> </design:formattingHints>
>>>> </design:usageHints>
>>>> </design:resultColumnDefinitions>
>>>> </design:resultSetColumns>
>>>> </design:resultSetDefinitions>
>>>> </design:ResultSets>
>>>> </model:DesignValues>]]></xml-property>
>>>> </oda-data-set>
>>>> </data-sets>
>>>> <styles>
>>>> <style name="crosstab" id="4">
>>>> <property name="borderBottomColor">#CCCCCC</property>
>>>> <property name="borderBottomStyle">solid</property>
>>>> <property name="borderBottomWidth">1pt</property>
>>>> <property name="borderLeftColor">#CCCCCC</property>
>>>> <property name="borderLeftStyle">solid</property>
>>>> <property name="borderLeftWidth">1pt</property>
>>>> <property name="borderRightColor">#CCCCCC</property>
>>>> <property name="borderRightStyle">solid</property>
>>>> <property name="borderRightWidth">1pt</property>
>>>> <property name="borderTopColor">#CCCCCC</property>
>>>> <property name="borderTopStyle">solid</property>
>>>> <property name="borderTopWidth">1pt</property>
>>>> </style>
>>>> <style name="crosstab-cell" id="5">
>>>> <property name="borderBottomColor">#CCCCCC</property>
>>>> <property name="borderBottomStyle">solid</property>
>>>> <property name="borderBottomWidth">1pt</property>
>>>> <property name="borderLeftColor">#CCCCCC</property>
>>>> <property name="borderLeftStyle">solid</property>
>>>> <property name="borderLeftWidth">1pt</property>
>>>> <property name="borderRightColor">#CCCCCC</property>
>>>> <property name="borderRightStyle">solid</property>
>>>> <property name="borderRightWidth">1pt</property>
>>>> <property name="borderTopColor">#CCCCCC</property>
>>>> <property name="borderTopStyle">solid</property>
>>>> <property name="borderTopWidth">1pt</property>
>>>> </style>
>>>> </styles>
>>>> <page-setup>
>>>> <simple-master-page name="Simple MasterPage" id="2">
>>>> <page-footer>
>>>> <text id="3">
>>>> <property name="contentType">html</property>
>>>> <text-property
>>>> name="content"><![CDATA[<value-of>new
>>>> Date()</value-of>]]></text-property>
>>>> </text>
>>>> </page-footer>
>>>> </simple-master-page>
>>>> </page-setup>
>>>> <body>
>>>> <extended-item extensionName="Chart" name="NewChart" id="8">
>>>> <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">
>>>> <Type>Bar Chart</Type>
>>>> <SubType>Side-by-side</SubType>
>>>> <Description>
>>>> <Value></Value>
>>>> <Font>
>>>> <Alignment/>
>>>> </Font>
>>>> </Description>
>>>> <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>Bar 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>Categories</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>433.49999999759996</Width>
>>>> <Height>276.75</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>
>>>> </Block>
>>>> <Dimension>Two_Dimensional</Dimension>
>>>> <Script>function beforeGeneration( chart, context )&#xD;
>>>> {&#xD;
>>>> chart.setUnitSpacing(20);&#xD;
>>>> }&#xD;
>>>> var oldSpacing;&#xD;
>>>> function beforeDrawSeries( series, seriesRenderer, context )&#xD;
>>>> &#xD;
>>>> { &#xD;
>>>> oldSpacing = context.getChartInstance().getUnitSpacing();&#xD;
>>>> if( series.getSeriesIdentifier() == &quot;series one&quot;
>>>> ){&#xD;
>>>> context.getChartInstance().setUnitSpacing(70);&#xD;
>>>> }&#xD;
>>>> }&#xD;
>>>> &#xD;
>>>> function afterDrawSeries( series, seriesRenderer, context )&#xD;
>>>> {&#xD;
>>>> context.getChartInstance().setUnitSpacing(oldSpacing);&# xD;
>>>> }</Script>
>>>> <Units>Points</Units>
>>>> <SeriesThickness>10.0</SeriesThickness>
>>>> <SampleData>
>>>> <BaseSampleData>
>>>> <DataSetRepresentation>A, B, C</DataSetRepresentation>
>>>> </BaseSampleData>
>>>> <OrthogonalSampleData>
>>>> <DataSetRepresentation>5,4,12</DataSetRepresentation>
>>>> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>>>> </OrthogonalSampleData>
>>>> <OrthogonalSampleData>
>>>> <DataSetRepresentation>10.0,8.0,24.0</DataSetRepresentation >
>>>> <SeriesDefinitionIndex>1</SeriesDefinitionIndex>
>>>> </OrthogonalSampleData>
>>>> </SampleData>
>>>> <Interactivity/>
>>>> <Axes>
>>>> <Type>Text</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></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 xsi:type="type:BarSeries">
>>>> <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>true</Visible>
>>>> </Label>
>>>> <DataDefinition>
>>>> <Definition>row[&quot;CUSTOMERTOTAL&quot;]</Definition >
>>>> </DataDefinition>
>>>> <SeriesIdentifier>series one</SeriesIdentifier>
>>>> <DataPoint>
>>>> <Components>
>>>> <Type>Orthogonal_Value</Type>
>>>> </Components>
>>>> <Separator>, </Separator>
>>>> </DataPoint>
>>>> <LabelPosition>Outside</LabelPosition>
>>>> <Stacked>false</Stacked>
>>>> <Riser>Rectangle</Riser>
>>>> </Series>
>>>> <Grouping>
>>>> <Enabled>false</Enabled>
>>>> <GroupingInterval>2</GroupingInterval>
>>>> <GroupType>Text</GroupType>
>>>> <AggregateExpression>Sum</AggregateExpression>
>>>> </Grouping>
>>>> <Sorting>Ascending</Sorting>
>>>> </SeriesDefinitions>
>>>> <SeriesDefinitions>
>>>> <Query>
>>>> <Definition></Definition>
>>>> </Query>
>>>> <SeriesPalette>
>>>> <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>
&g

Report message to a moderator

Re: Bar charts width [message #367858 is a reply to message #367804] Tue, 14 April 2009 08:48 Go to previous message
Christophe is currently offline ChristopheFriend
Messages: 15
Registered: July 2009
Junior Member
Thank Jason,

It's perfect.

Cheers.

Jason Weathersby a écrit :
> Chris,
>
> Sorry I just saw this.
>
> In the afterdataset filled event do something like:
>
> barcnt = 0;
> function afterDataSetFilled(series, dataSet, icsc)
> {
> importPackage( Packages.java.io );
> importPackage( Packages.org.eclipse.birt.chart.model.type.impl );
>
> if( series.getClass() == LineSeriesImpl ){
> series.getLineAttributes().setThickness(5);
> }
> if( series.getClass() == BarSeriesImpl ){
> if( series.getSeriesIdentifier() == "mybar" ){
> var list = dataSet.getValues();
> barcnt = list.length;
> }
>
>
> }
>
>
> }
> Noticed that I named my series to mybar in the third tab of the chart
> wizard. I can then add this count to the y axis label like:
>
> function beforeDrawAxisTitle( axis, label, icsc )
> {
> importPackage(Packages.org.eclipse.birt.chart.model.attribut e);
> if (axis.getType() == AxisType.LINEAR_LITERAL)
> {
> label.getCaption( ).setValue( "Total Bars = " + barcnt);
> }
> }
>
> Jason
>
> Chris wrote:
>> Jason,
>>
>> Could you help me to do that please ?
>>
>> "You can get the number of bars by using a *script* in the after data
>> set filled I believe".
>>
>>
>> Chris.
>>
>>
>> Jason Weathersby a écrit :
>>> Chris,
>>>
>>> You can get the number of bars by using a script in the after data
>>> set filled I believe. Other than that it may be a good idea to log
>>> an enhancement bug for this.
>>>
>>> Jason
>>>
>>> Chris wrote:
>>>> Thank Jason for your solution but in my case it's more difficult
>>>> because in my report, each chart has much bars, and I don't know the
>>>> number of bars ! (See attached files)
>>>>
>>>> I think the best way is to always fix the width of the bars, for all
>>>> charts... Can I do that ?
>>>>
>>>> Do you have any other solutions ?
>>>>
>>>> cheers.
>>>>
>>>>
>>>> Jason Weathersby a écrit :
>>>>> Chris,
>>>>>
>>>>> Not sure if this is what you want but attached is an example of two
>>>>> bar series of different sizes. It uses the following script:
>>>>> function beforeGeneration( chart, context )
>>>>> {
>>>>> chart.setUnitSpacing(20);
>>>>> }
>>>>> var oldSpacing;
>>>>> function beforeDrawSeries( series, seriesRenderer, context )
>>>>>
>>>>> { oldSpacing = context.getChartInstance().getUnitSpacing();
>>>>> if( series.getSeriesIdentifier() == "series one" ){
>>>>> context.getChartInstance().setUnitSpacing(70);
>>>>> }
>>>>> }
>>>>>
>>>>> function afterDrawSeries( series, seriesRenderer, context )
>>>>> {
>>>>> context.getChartInstance().setUnitSpacing(oldSpacing);
>>>>> }
>>>>>
>>>>> Jason
>>>>>
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>>>>> version="3.2.15" id="1">
>>>>> <property name="createdBy">Eclipse BIRT Designer Version
>>>>> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
>>>>> <property name="units">in</property>
>>>>> <property name="comments">Copyright (c) 2007 &lt;&lt;Your
>>>>> Company Name here>></property>
>>>>> <html-property name="description">Creates a blank report with
>>>>> no predefined content.</html-property>
>>>>> <text-property name="displayName">Blank Report</text-property>
>>>>> <property name="iconFile">/templates/blank_report.gif</property>
>>>>> <data-sources>
>>>>> <oda-data-source
>>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data
>>>>> Source" id="6">
>>>>> <property
>>>>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>>>>
>>>>> <property
>>>>> name="odaURL">jdbc:classicmodels:sampledb</property>
>>>>> <property name="odaUser">ClassicModels</property>
>>>>> </oda-data-source>
>>>>> </data-sources>
>>>>> <data-sets>
>>>>> <oda-data-set
>>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>>>> name="Data Set" id="7">
>>>>> <list-property name="columnHints">
>>>>> <structure>
>>>>> <property
>>>>> name="columnName">CUSTOMERNAME</property>
>>>>> <property
>>>>> name="displayName">CUSTOMERNAME</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property
>>>>> name="columnName">CUSTOMERNUMBER</property>
>>>>> <property
>>>>> name="displayName">CUSTOMERNUMBER</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property
>>>>> name="columnName">CUSTOMERTOTAL</property>
>>>>> <property
>>>>> name="displayName">CUSTOMERTOTAL</property>
>>>>> </structure>
>>>>> </list-property>
>>>>> <structure name="cachedMetaData">
>>>>> <list-property name="resultSet">
>>>>> <structure>
>>>>> <property name="position">1</property>
>>>>> <property name="name">CUSTOMERNAME</property>
>>>>> <property name="dataType">string</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">2</property>
>>>>> <property
>>>>> name="name">CUSTOMERNUMBER</property>
>>>>> <property name="dataType">integer</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">3</property>
>>>>> <property name="name">CUSTOMERTOTAL</property>
>>>>> <property name="dataType">float</property>
>>>>> </structure>
>>>>> </list-property>
>>>>> </structure>
>>>>> <property name="dataSource">Data Source</property>
>>>>> <list-property name="resultSet">
>>>>> <structure>
>>>>> <property name="position">1</property>
>>>>> <property name="name">CUSTOMERNAME</property>
>>>>> <property
>>>>> name="nativeName">CUSTOMERNAME</property>
>>>>> <property name="dataType">string</property>
>>>>> <property name="nativeDataType">12</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">2</property>
>>>>> <property name="name">CUSTOMERNUMBER</property>
>>>>> <property
>>>>> name="nativeName">CUSTOMERNUMBER</property>
>>>>> <property name="dataType">integer</property>
>>>>> <property name="nativeDataType">4</property>
>>>>> </structure>
>>>>> <structure>
>>>>> <property name="position">3</property>
>>>>> <property name="name">CUSTOMERTOTAL</property>
>>>>> <property
>>>>> name="nativeName">CUSTOMERTOTAL</property>
>>>>> <property name="dataType">float</property>
>>>>> <property name="nativeDataType">8</property>
>>>>> </structure>
>>>>> </list-property>
>>>>> <property name="queryText">select CUSTOMERS.CUSTOMERNAME,
>>>>> CUSTOMERS.CUSTOMERNUMBER,
>>>>> sum(ORDERDETAILS.QUANTITYORDERED *
>>>>> ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
>>>>> from CUSTOMERS, ORDERS, ORDERDETAILS
>>>>> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER
>>>>> and ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
>>>>> group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER
>>>>> order by CUSTOMERTOTAL</property>
>>>>> <xml-property name="designerValues"><![CDATA[<?xml
>>>>> version="1.0" encoding="UTF-8"?>
>>>>> <model:DesignValues
>>>>> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
>>>>> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
>>>>>
>>>>> <Version>1.0</Version>
>>>>> <design:ResultSets derivedMetaData="true">
>>>>> <design:resultSetDefinitions>
>>>>> <design:resultSetColumns>
>>>>> <design:resultColumnDefinitions>
>>>>> <design:attributes>
>>>>> <design:name>CUSTOMERNAME</design:name>
>>>>> <design:position>1</design:position>
>>>>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>>>>> <design:precision>50</design:precision>
>>>>> <design:scale>0</design:scale>
>>>>> <design:nullability>Nullable</design:nullability>
>>>>> <design:uiHints>
>>>>> <design:displayName>CUSTOMERNAME</design:displayName>
>>>>> </design:uiHints>
>>>>> </design:attributes>
>>>>> <design:usageHints>
>>>>> <design:label>CUSTOMERNAME</design:label>
>>>>> <design:formattingHints>
>>>>> <design:displaySize>50</design:displaySize>
>>>>> </design:formattingHints>
>>>>> </design:usageHints>
>>>>> </design:resultColumnDefinitions>
>>>>> <design:resultColumnDefinitions>
>>>>> <design:attributes>
>>>>> <design:name>CUSTOMERNUMBER</design:name>
>>>>> <design:position>2</design:position>
>>>>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>>>>> <design:precision>10</design:precision>
>>>>> <design:scale>0</design:scale>
>>>>> <design:nullability>Nullable</design:nullability>
>>>>> <design:uiHints>
>>>>> <design:displayName>CUSTOMERNUMBER</design:displayName>
>>>>> </design:uiHints>
>>>>> </design:attributes>
>>>>> <design:usageHints>
>>>>> <design:label>CUSTOMERNUMBER</design:label>
>>>>> <design:formattingHints>
>>>>> <design:displaySize>11</design:displaySize>
>>>>> </design:formattingHints>
>>>>> </design:usageHints>
>>>>> </design:resultColumnDefinitions>
>>>>> <design:resultColumnDefinitions>
>>>>> <design:attributes>
>>>>> <design:name>CUSTOMERTOTAL</design:name>
>>>>> <design:position>3</design:position>
>>>>> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>>>>> <design:precision>15</design:precision>
>>>>> <design:scale>0</design:scale>
>>>>> <design:nullability>Nullable</design:nullability>
>>>>> <design:uiHints>
>>>>> <design:displayName>CUSTOMERTOTAL</design:displayName>
>>>>> </design:uiHints>
>>>>> </design:attributes>
>>>>> <design:usageHints>
>>>>> <design:label>CUSTOMERTOTAL</design:label>
>>>>> <design:formattingHints>
>>>>> <design:displaySize>22</design:displaySize>
>>>>> </design:formattingHints>
>>>>> </design:usageHints>
>>>>> </design:resultColumnDefinitions>
>>>>> </design:resultSetColumns>
>>>>> </design:resultSetDefinitions>
>>>>> </design:ResultSets>
>>>>> </model:DesignValues>]]></xml-property>
>>>>> </oda-data-set>
>>>>> </data-sets>
>>>>> <styles>
>>>>> <style name="crosstab" id="4">
>>>>> <property name="borderBottomColor">#CCCCCC</property>
>>>>> <property name="borderBottomStyle">solid</property>
>>>>> <property name="borderBottomWidth">1pt</property>
>>>>> <property name="borderLeftColor">#CCCCCC</property>
>>>>> <property name="borderLeftStyle">solid</property>
>>>>> <property name="borderLeftWidth">1pt</property>
>>>>> <property name="borderRightColor">#CCCCCC</property>
>>>>> <property name="borderRightStyle">solid</property>
>>>>> <property name="borderRightWidth">1pt</property>
>>>>> <property name="borderTopColor">#CCCCCC</property>
>>>>> <property name="borderTopStyle">solid</property>
>>>>> <property name="borderTopWidth">1pt</property>
>>>>> </style>
>>>>> <style name="crosstab-cell" id="5">
>>>>> <property name="borderBottomColor">#CCCCCC</property>
>>>>> <property name="borderBottomStyle">solid</property>
>>>>> <property name="borderBottomWidth">1pt</property>
>>>>> <property name="borderLeftColor">#CCCCCC</property>
>>>>> <property name="borderLeftStyle">solid</property>
>>>>> <property name="borderLeftWidth">1pt</property>
>>>>> <property name="borderRightColor">#CCCCCC</property>
>>>>> <property name="borderRightStyle">solid</property>
>>>>> <property name="borderRightWidth">1pt</property>
>>>>> <property name="borderTopColor">#CCCCCC</property>
>>>>> <property name="borderTopStyle">solid</property>
>>>>> <property name="borderTopWidth">1pt</property>
>>>>> </style>
>>>>> </styles>
>>>>> <page-setup>
>>>>> <simple-master-page name="Simple MasterPage" id="2">
>>>>> <page-footer>
>>>>> <text id="3">
>>>>> <property name="contentType">html</property>
>>>>> <text-property
>>>>> name="content"><![CDATA[<value-of>new
>>>>> Date()</value-of>]]></text-property>
>>>>> </text>
>>>>> </page-footer>
>>>>> </simple-master-page>
>>>>> </page-setup>
>>>>> <body>
>>>>> <extended-item extensionName="Chart" name="NewChart" id="8">
>>>>> <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">
>>>>> <Type>Bar Chart</Type>
>>>>> <SubType>Side-by-side</SubType>
>>>>> <Description>
>>>>> <Value></Value>
>>>>> <Font>
>>>>> <Alignment/>
>>>>> </Font>
>>>>> </Description>
>>>>> <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>Bar 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>Categories</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>433.49999999759996</Width>
>>>>> <Height>276.75</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>
>>>>> </Block>
>>>>> <Dimension>Two_Dimensional</Dimension>
>>>>> <Script>function beforeGeneration( chart, context )&#xD;
>>>>> {&#xD;
>>>>> chart.setUnitSpacing(20);&#xD;
>>>>> }&#xD;
>>>>> var oldSpacing;&#xD;
>>>>> function beforeDrawSeries( series, seriesRenderer, context )&#xD;
>>>>> &#xD;
>>>>> { &#xD;
>>>>> oldSpacing = context.getChartInstance().getUnitSpacing();&#xD;
>>>>> if( series.getSeriesIdentifier() == &quot;series one&quot;
>>>>> ){&#xD;
>>>>> context.getChartInstance().setUnitSpacing(70);&#xD;
>>>>> }&#xD;
>>>>> }&#xD;
>>>>> &#xD;
>>>>> function afterDrawSeries( series, seriesRenderer, context )&#xD;
>>>>> {&#xD;
>>>>> context.getChartInstance().setUnitSpacing(oldSpacing);&# xD;
>>>>> }</Script>
>>>>> <Units>Points</Units>
>>>>> <SeriesThickness>10.0</SeriesThickness>
>>>>> <SampleData>
>>>>> <BaseSampleData>
>>>>> <DataSetRepresentation>A, B, C</DataSetRepresentation>
>>>>> </BaseSampleData>
>>>>> <OrthogonalSampleData>
>>>>> <DataSetRepresentation>5,4,12</DataSetRepresentation>
>>>>> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>>>>> </OrthogonalSampleData>
>>>>> <OrthogonalSampleData>
>>>>> <DataSetRepresentation>10.0,8.0,24.0</DataSetRepresentation >
>>>>> <SeriesDefinitionIndex>1</SeriesDefinitionIndex>
>>>>> </OrthogonalSampleData>
>>>>> </SampleData>
>>>>> <Interactivity/>
>>>>> <Axes>
>>>>> <Type>Text</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></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 xsi:type="type:BarSeries">
>>>>> <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>true</Visible>
>>>>> </Label>
>>>>> <DataDefinition>
>>>>> <Definition>row[&quot;CUSTOMERTOTAL&quot;]</Definition >
>>>>

Report message to a moderator

Previous Topic:making chart axis ticks invisible
Next Topic:Passing Filename as a Parameter to a CSV Report...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 13:37:17 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly