|
Re: Using chart ellipsis for long labels [message #535619 is a reply to message #535574] |
Mon, 24 May 2010 22:27 |
|
Chris,
Are you using 2.5.2. See attached example see if the ellipsis show up.
Are you using the fixed label spans? BTW you can also trim the labels
in script in the beforeDrawAxisLabel event.
Jason
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
id="1">
<property name="comments">Copyright (c) 2007 <<Your Company
Name here>></property>
<property name="createdBy">Eclipse BIRT Designer Version
2.5.2.v20100208 Build <2.5.2.v20100210-0630></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<property name="units">in</property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">auto layout</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>
<property name="OdaConnProfileName"></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">CUSTOMERNUMBER</property>
<text-property
name="displayName">CUSTOMERNUMBER</text-property>
</structure>
<structure>
<property name="columnName">CUSTOMERNAME</property>
<text-property
name="displayName">CUSTOMERNAME</text-property>
</structure>
<structure>
<property name="columnName">CONTACTLASTNAME</property>
<text-property
name="displayName">CONTACTLASTNAME</text-property>
</structure>
<structure>
<property name="columnName">CONTACTFIRSTNAME</property>
<text-property
name="displayName">CONTACTFIRSTNAME</text-property>
</structure>
<structure>
<property name="columnName">PHONE</property>
<text-property name="displayName">PHONE</text-property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE1</property>
<text-property
name="displayName">ADDRESSLINE1</text-property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE2</property>
<text-property
name="displayName">ADDRESSLINE2</text-property>
</structure>
<structure>
<property name="columnName">CITY</property>
<text-property name="displayName">CITY</text-property>
</structure>
<structure>
<property name="columnName">STATE</property>
<text-property name="displayName">STATE</text-property>
</structure>
<structure>
<property name="columnName">POSTALCODE</property>
<text-property
name="displayName">POSTALCODE</text-property>
</structure>
<structure>
<property name="columnName">COUNTRY</property>
<text-property
name="displayName">COUNTRY</text-property>
</structure>
<structure>
<property
name="columnName">SALESREPEMPLOYEENUMBER</property>
<text-property
name="displayName">SALESREPEMPLOYEENUMBER</text-property>
</structure>
<structure>
<property name="columnName">CREDITLIMIT</property>
<text-property
name="displayName">CREDITLIMIT</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property
name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="nativeName">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="nativeName">CONTACTLASTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="nativeName">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="nativeName">PHONE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="nativeName">ADDRESSLINE1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="nativeName">ADDRESSLINE2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="nativeName">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="nativeName">POSTALCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="nativeName">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property
name="nativeName">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="nativeName">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select *
from CLASSICMODELS.CUSTOMERS]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml
version="1.0" encoding="UTF-8"?>
<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMERNUMBER</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design: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>CUSTOMERNAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design: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>CONTACTLASTNAME</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CONTACTLASTNAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CONTACTLASTNAME</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CONTACTFIRSTNAME</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CONTACTFIRSTNAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CONTACTFIRSTNAME</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PHONE</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PHONE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PHONE</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ADDRESSLINE1</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ADDRESSLINE1</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ADDRESSLINE1</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ADDRESSLINE2</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ADDRESSLINE2</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ADDRESSLINE2</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CITY</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CITY</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CITY</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STATE</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>STATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STATE</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>POSTALCODE</design:name>
<design:position>10</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>POSTALCODE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>POSTALCODE</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>COUNTRY</design:name>
<design:position>11</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>COUNTRY</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>COUNTRY</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SALESREPEMPLOYEENUMBER</design:name>
<design:position>12</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SALESREPEMPLOYEENUMBER</design:displayName >
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SALESREPEMPLOYEENUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CREDITLIMIT</design:name>
<design:position>13</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CREDITLIMIT</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CREDITLIMIT</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<cubes>
<tabular-cube name="Data Cube" id="9">
<property name="dimensions">
<tabular-dimension name="Group" id="12">
<property
name="defaultHierarchy">NewTabularHierarchy</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy"
id="13">
<property name="levels">
<tabular-level name="COUNTRY" id="14">
<property
name="dataType">string</property>
<property
name="columnName">COUNTRY</property>
</tabular-level>
<tabular-level name="STATE" id="15">
<property
name="dataType">string</property>
<property
name="columnName">STATE</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="Summary Field" id="10">
<property name="measures">
<tabular-measure name="CREDITLIMIT" id="11">
<expression
name="measureExpression">dataSetRow["CREDITLIMIT"]</expression >
<property name="dataType">float</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">Data Set</property>
</tabular-cube>
</cubes>
<styles>
<style name="crosstab-cell" 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" 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">
<property name="topMargin">1in</property>
<property name="leftMargin">1.25in</property>
<property name="bottomMargin">1in</property>
<property name="rightMargin">1.25in</property>
<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>
<Anchor>North</Anchor>
<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>true</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>
<Rotation>18.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>254</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</Outline>
<ShadowColor>
<Transparency>255</Transparency>
<Red>204</Red>
<Green>254</Green>
<Blue>204</Blue>
</ShadowColor>
<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>true</Visible>
</Outline>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Visible>true</Visible>
<HorizontalSpacing>5</HorizontalSpacing>
<VerticalSpacing>5</VerticalSpacing>
<ClientArea>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>204</Red>
<Green>254</Green>
<Blue>254</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</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>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>254</Red>
<Green>254</Green>
<Blue>153</Blue>
</Background>
<Visible>true</Visible>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>2.0</Top>
<Left>2.0</Left>
<Bottom>2.0</Bottom>
<Right>2.0</Right>
</Insets>
</ClientArea>
<Text>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Text>
<Orientation>Vertical</Orientation>
<Direction>Top_Bottom</Direction>
<Separator>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</Separator>
<Position>Right</Position>
<ItemType>Series</ItemType>
<Title>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Above</TitlePosition>
<ShowValue>true</ShowValue>
<WrappingSize>0.0</WrappingSize>
<MaxPercent>0.333</MaxPercent>
</Children>
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>433.49999999759996</Width>
<Height>239.9999999976</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>true</Visible>
</Outline>
<Visible>true</Visible>
</Block>
<Dimension>Two_Dimensional</Dimension>
<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>
</SampleData>
<Interactivity/>
<EmptyMessage>
<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>false</Visible>
</EmptyMessage>
<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>
<Rotation>-21.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>254</Blue>
</Color>
<Visible>true</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>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>67.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>254</Blue>
</Color>
<Visible>true</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>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
|
|
|
|
Re: Using chart ellipsis for long labels [message #536291 is a reply to message #536074] |
Thu, 27 May 2010 14:18 |
|
Chris,
Can you open a bug for the ellipsis?
Are you just wanting to set a width of the label? Have you tried using
the label span feature as defined on the axis in the third tab of the
chart wizard?
Jason
On 5/26/2010 5:22 PM, Chris wrote:
> I am using 2.5.2. Your example works as long as you don't flip the Axis
> in the chart configuration. I did experiment with trimming the labels in
> the beforeDrawAxisLabel event. That works as far trimming the label. The
> problem is that the chart seems to have already calculated its layout so
> I cannot affect the position of the axis. Is there a way to axis the
> label data before the chart does all of its calculations? I tried using
> the 'afterDataSetFilled' but can't seem to discover how to access the
> label values.
>
> Thanks
>
|
|
|
|
Re: Using chart ellipsis for long labels [message #536325 is a reply to message #536300] |
Thu, 27 May 2010 16:25 |
|
Chris,
Any chance you could use the sample db to create a chart with the issue
and post the report? I will try to come up with some script to work
around the issue.
Jason
On 5/27/2010 11:05 AM, Chris wrote:
> I will log a bug. I have tried using the label span feature. It has
> the same result. The labels just disappear instead being truncated.
>
> I am really looking for a max width for the labels to allow the bar
> chart to still auto-size its layout up to a max-allowed length. That
> would prevent the bars portion from getting sized extremely small while
> the labels take most of the room or from the labels just getting dropped
> completely.
>
> Is there a way to access the label(category) values via scripting after
> the data set has been loaded but before the chart tries to lay
> everything out?
>
>
> On 5/27/2010 8:18 AM, Jason Weathersby wrote:
>> Chris,
>>
>> Can you open a bug for the ellipsis?
>> Are you just wanting to set a width of the label? Have you tried using
>> the label span feature as defined on the axis in the third tab of the
>> chart wizard?
>>
>> Jason
>>
>> On 5/26/2010 5:22 PM, Chris wrote:
>>> I am using 2.5.2. Your example works as long as you don't flip the Axis
>>> in the chart configuration. I did experiment with trimming the labels in
>>> the beforeDrawAxisLabel event. That works as far trimming the label. The
>>> problem is that the chart seems to have already calculated its layout so
>>> I cannot affect the position of the axis. Is there a way to axis the
>>> label data before the chart does all of its calculations? I tried using
>>> the 'afterDataSetFilled' but can't seem to discover how to access the
>>> label values.
>>>
>>> Thanks
>>>
>>
>
|
|
|
Re: Using chart ellipsis for long labels [message #536326 is a reply to message #536325] |
Thu, 27 May 2010 16:28 |
|
BTW what string length do you want to limit to?
On 5/27/2010 12:25 PM, Jason Weathersby wrote:
> Chris,
>
> Any chance you could use the sample db to create a chart with the issue
> and post the report? I will try to come up with some script to work
> around the issue.
>
> Jason
>
> On 5/27/2010 11:05 AM, Chris wrote:
>> I will log a bug. I have tried using the label span feature. It has
>> the same result. The labels just disappear instead being truncated.
>>
>> I am really looking for a max width for the labels to allow the bar
>> chart to still auto-size its layout up to a max-allowed length. That
>> would prevent the bars portion from getting sized extremely small while
>> the labels take most of the room or from the labels just getting dropped
>> completely.
>>
>> Is there a way to access the label(category) values via scripting after
>> the data set has been loaded but before the chart tries to lay
>> everything out?
>>
>>
>> On 5/27/2010 8:18 AM, Jason Weathersby wrote:
>>> Chris,
>>>
>>> Can you open a bug for the ellipsis?
>>> Are you just wanting to set a width of the label? Have you tried using
>>> the label span feature as defined on the axis in the third tab of the
>>> chart wizard?
>>>
>>> Jason
>>>
>>> On 5/26/2010 5:22 PM, Chris wrote:
>>>> I am using 2.5.2. Your example works as long as you don't flip the Axis
>>>> in the chart configuration. I did experiment with trimming the
>>>> labels in
>>>> the beforeDrawAxisLabel event. That works as far trimming the label.
>>>> The
>>>> problem is that the chart seems to have already calculated its
>>>> layout so
>>>> I cannot affect the position of the axis. Is there a way to axis the
>>>> label data before the chart does all of its calculations? I tried using
>>>> the 'afterDataSetFilled' but can't seem to discover how to access the
>>>> label values.
>>>>
>>>> Thanks
>>>>
>>>
>>
>
|
|
|
Re: Using chart ellipsis for long labels [message #536357 is a reply to message #536300] |
Thu, 27 May 2010 18:39 |
|
Chris,
In the afterComputations enter this script:
importPackage( Packages.org.eclipse.birt.chart.model.attribute );
importPackage(Packages.org.eclipse.birt.chart.model.attribut e.impl);
importPackage(Packages.org.eclipse.birt.chart.model.attribut e);
plotComputation.getAxes( ).getPrimaryBase( ).setShowLabels(true);
You can then use the beforeDrawAxisLabels to modify them.
Jason
On 5/27/2010 11:05 AM, Chris wrote:
> I will log a bug. I have tried using the label span feature. It has
> the same result. The labels just disappear instead being truncated.
>
> I am really looking for a max width for the labels to allow the bar
> chart to still auto-size its layout up to a max-allowed length. That
> would prevent the bars portion from getting sized extremely small while
> the labels take most of the room or from the labels just getting dropped
> completely.
>
> Is there a way to access the label(category) values via scripting after
> the data set has been loaded but before the chart tries to lay
> everything out?
>
>
> On 5/27/2010 8:18 AM, Jason Weathersby wrote:
>> Chris,
>>
>> Can you open a bug for the ellipsis?
>> Are you just wanting to set a width of the label? Have you tried using
>> the label span feature as defined on the axis in the third tab of the
>> chart wizard?
>>
>> Jason
>>
>> On 5/26/2010 5:22 PM, Chris wrote:
>>> I am using 2.5.2. Your example works as long as you don't flip the Axis
>>> in the chart configuration. I did experiment with trimming the labels in
>>> the beforeDrawAxisLabel event. That works as far trimming the label. The
>>> problem is that the chart seems to have already calculated its layout so
>>> I cannot affect the position of the axis. Is there a way to axis the
>>> label data before the chart does all of its calculations? I tried using
>>> the 'afterDataSetFilled' but can't seem to discover how to access the
>>> label values.
>>>
>>> Thanks
>>>
>>
>
|
|
|
|
Re: Using chart ellipsis for long labels [message #536572 is a reply to message #536380] |
Fri, 28 May 2010 17:14 |
|
Chris,
If you just want to get the label values you can do this in the
afterdataset filled. This event is fired for every series that is
created. It is first called for the category series and then for each
orthogonal series. So in your case the first series will be your
labels. To get the values use the dataSet.getValues() call.
function afterDataSetFilled( series, dataSet, icsc )
{
importPackage( Packages.java.io );
out = new PrintWriter( new FileWriter( "c:/test/events.txt", true ) );
var list = dataSet.getValues();
out.println("=="+series.getDisplayName());
for ( i=0; i<list.length; i=i+1)
{
out.println( list[i] );
}
out.close();
}
You can change a value like:
list[i] = "I changed this category value"
You can also set the values using dataSet.setValues. For example I
wrote a script to add an extra data point to a simple bar chart like:
function afterDataSetFilled(series, dataSet, icsc)
{
importPackage( Packages.java.io );
importPackage( Packages.java.util );
importPackage( Packages.org.eclipse.birt.chart.model.type.impl );
var list = dataSet.getValues();
var narray1 = new ArrayList( );
var ll =list.length;
for ( i=0; i<ll; i=i+1)
{
narray1.add(list[i]);
}
if( series.getClass() == BarSeriesImpl ){
narray1.add(400000);
}else{
narray1.add("Tanks");
}
dataSet.setValues(narray1);
}
Jason
On 5/27/2010 5:35 PM, Chris wrote:
> Jason,
>
> Thanks for your input. I appreciate your help.
> Attached is a sample of what i am seeing. I sized the chart a little
> small for practical purposes but serves to illustrate my issue.
>
> For a label limit for my purposes I would probably use something like 30
> characters.
>
> I tried your script for afterComputations and in conjuction with using
> the beforeDrawAxisLabels function and setting the span width things work
> better.
>
> I would really like to be able to modify the labels without having to
> set a fixed span. This would allow the chart to use a larger area for
> the bars when you have shorter labels that don't need truncated.
> Is there a way I can access the label values in the beforeComputation
> function?
>
> Is there any authoritative web sites or documentation that you could
> point me to that would provide information about the APIs and
> relationships of the various data structures that are available via
> scripting?
>
> thanks again
>
> Chris
>
>
>
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
> id="1">
> <property name="comments">Copyright (c) 2007 <<Your Company Name
> here>></property>
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100211
> Build <2.5.2.v20100210-0630></property>
> <html-property name="description">Creates a blank report with no
> predefined content.</html-property>
> <property name="units">in</property>
> <text-property name="displayName">Blank Report</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="layoutPreference">auto layout</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>
> <property name="OdaConnProfileName"></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">CUSTOMERNUMBER</property>
> <text-property name="displayName">CUSTOMERNUMBER</text-property>
> </structure>
> <structure>
> <property name="columnName">CUSTOMERNAME</property>
> <text-property name="displayName">CUSTOMERNAME</text-property>
> </structure>
> <structure>
> <property name="columnName">CONTACTLASTNAME</property>
> <text-property name="displayName">CONTACTLASTNAME</text-property>
> </structure>
> <structure>
> <property name="columnName">CONTACTFIRSTNAME</property>
> <text-property name="displayName">CONTACTFIRSTNAME</text-property>
> </structure>
> <structure>
> <property name="columnName">PHONE</property>
> <text-property name="displayName">PHONE</text-property>
> </structure>
> <structure>
> <property name="columnName">ADDRESSLINE1</property>
> <text-property name="displayName">ADDRESSLINE1</text-property>
> </structure>
> <structure>
> <property name="columnName">ADDRESSLINE2</property>
> <text-property name="displayName">ADDRESSLINE2</text-property>
> </structure>
> <structure>
> <property name="columnName">CITY</property>
> <text-property name="displayName">CITY</text-property>
> </structure>
> <structure>
> <property name="columnName">STATE</property>
> <text-property name="displayName">STATE</text-property>
> </structure>
> <structure>
> <property name="columnName">POSTALCODE</property>
> <text-property name="displayName">POSTALCODE</text-property>
> </structure>
> <structure>
> <property name="columnName">COUNTRY</property>
> <text-property name="displayName">COUNTRY</text-property>
> </structure>
> <structure>
> <property name="columnName">SALESREPEMPLOYEENUMBER</property>
> <text-property name="displayName">SALESREPEMPLOYEENUMBER</text-property>
> </structure>
> <structure>
> <property name="columnName">CREDITLIMIT</property>
> <text-property name="displayName">CREDITLIMIT</text-property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CUSTOMERNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">CONTACTLASTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">CONTACTFIRSTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">PHONE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">ADDRESSLINE1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">ADDRESSLINE2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">CITY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">STATE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">POSTALCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">COUNTRY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">SALESREPEMPLOYEENUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">CREDITLIMIT</property>
> <property name="dataType">float</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="nativeName">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CUSTOMERNAME</property>
> <property name="nativeName">CUSTOMERNAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">CONTACTLASTNAME</property>
> <property name="nativeName">CONTACTLASTNAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">CONTACTFIRSTNAME</property>
> <property name="nativeName">CONTACTFIRSTNAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">PHONE</property>
> <property name="nativeName">PHONE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">ADDRESSLINE1</property>
> <property name="nativeName">ADDRESSLINE1</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">ADDRESSLINE2</property>
> <property name="nativeName">ADDRESSLINE2</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">CITY</property>
> <property name="nativeName">CITY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">STATE</property>
> <property name="nativeName">STATE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">POSTALCODE</property>
> <property name="nativeName">POSTALCODE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">COUNTRY</property>
> <property name="nativeName">COUNTRY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">SALESREPEMPLOYEENUMBER</property>
> <property name="nativeName">SALESREPEMPLOYEENUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">CREDITLIMIT</property>
> <property name="nativeName">CREDITLIMIT</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[select *
> from CLASSICMODELS.CUSTOMERS]]></xml-property>
> <xml-property name="designerValues"><![CDATA[<?xml version="1.0"
> encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design: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>CUSTOMERNAME</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design: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>CONTACTLASTNAME</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CONTACTLASTNAME</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CONTACTLASTNAME</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CONTACTFIRSTNAME</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CONTACTFIRSTNAME</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CONTACTFIRSTNAME</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>PHONE</design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>PHONE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>PHONE</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ADDRESSLINE1</design:name>
> <design:position>6</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>ADDRESSLINE1</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ADDRESSLINE1</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ADDRESSLINE2</design:name>
> <design:position>7</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>ADDRESSLINE2</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ADDRESSLINE2</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CITY</design:name>
> <design:position>8</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CITY</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CITY</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>STATE</design:name>
> <design:position>9</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>STATE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>STATE</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>POSTALCODE</design:name>
> <design:position>10</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>15</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>POSTALCODE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>POSTALCODE</design:label>
> <design:formattingHints>
> <design:displaySize>15</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>COUNTRY</design:name>
> <design:position>11</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>COUNTRY</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>COUNTRY</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>SALESREPEMPLOYEENUMBER</design:name>
> <design:position>12</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
>
> <design:displayName>SALESREPEMPLOYEENUMBER</design:displayName >
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>SALESREPEMPLOYEENUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CREDITLIMIT</design:name>
> <design:position>13</design:position>
> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
> <design:precision>15</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CREDITLIMIT</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CREDITLIMIT</design:label>
> <design:formattingHints>
> <design:displaySize>22</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <cubes>
> <tabular-cube name="Data Cube" id="9">
> <property name="dimensions">
> <tabular-dimension name="Group" id="12">
> <property name="defaultHierarchy">NewTabularHierarchy</property>
> <property name="hierarchies">
> <tabular-hierarchy name="NewTabularHierarchy" id="13">
> <property name="levels">
> <tabular-level name="COUNTRY" id="14">
> <property name="dataType">string</property>
> <property name="columnName">COUNTRY</property>
> </tabular-level>
> <tabular-level name="STATE" id="15">
> <property name="dataType">string</property>
> <property name="columnName">STATE</property>
> </tabular-level>
> </property>
> </tabular-hierarchy>
> </property>
> </tabular-dimension>
> </property>
> <property name="measureGroups">
> <tabular-measure-group name="Summary Field" id="10">
> <property name="measures">
> <tabular-measure name="CREDITLIMIT" id="11">
> <expression name="measureExpression">dataSetRow["CREDITLIMIT"]</expression >
> <property name="dataType">float</property>
> </tabular-measure>
> </property>
> </tabular-measure-group>
> </property>
> <property name="dataSet">Data Set</property>
> </tabular-cube>
> </cubes>
> <styles>
> <style name="crosstab-cell" 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" 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">
> <property name="type">custom</property>
> <property name="height">11in</property>
> <property name="width">18in</property>
> <property name="topMargin">1in</property>
> <property name="leftMargin">1.25in</property>
> <property name="bottomMargin">1in</property>
> <property name="rightMargin">1.25in</property>
> <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">
> <Version>2.5.1</Version>
> <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>
> <Anchor>North</Anchor>
> <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>true</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>
> <Rotation>18.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>254</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>true</Visible>
> </Outline>
> <ShadowColor>
> <Transparency>255</Transparency>
> <Red>204</Red>
> <Green>254</Green>
> <Blue>204</Blue>
> </ShadowColor>
> <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>true</Visible>
> </Outline>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>0</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Visible>true</Visible>
> <HorizontalSpacing>5</HorizontalSpacing>
> <VerticalSpacing>5</VerticalSpacing>
> <ClientArea>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>204</Red>
> <Green>254</Green>
> <Blue>254</Blue>
> </Background>
> <Outline>
> <Style>Solid</Style>
> <Thickness>0</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>true</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>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>255</Transparency>
> <Red>254</Red>
> <Green>254</Green>
> <Blue>153</Blue>
> </Background>
> <Visible>true</Visible>
> <ClientArea>
> <Outline>
> <Style>Solid</Style>
> <Thickness>0</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Insets>
> <Top>2.0</Top>
> <Left>2.0</Left>
> <Bottom>2.0</Bottom>
> <Right>2.0</Right>
> </Insets>
> </ClientArea>
> <Text>
> <Value></Value>
> <Font>
> <Alignment/>
> </Font>
> </Text>
> <Orientation>Vertical</Orientation>
> <Direction>Top_Bottom</Direction>
> <Separator>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>true</Visible>
> </Separator>
> <Position>Right</Position>
> <ItemType>Series</ItemType>
> <Title>
> <Caption>
> <Value></Value>
> <Font>
> <Alignment/>
> </Font>
> </Caption>
> <Background xsi:type="attribute:ColorDefinition">
> <Transparency>0</Transparency>
> <Red>255</Red>
> <Green>255</Green>
> <Blue>255</Blue>
> </Background>
> <Outline>
> <Style>Solid</Style>
> <Thickness>1</Thickness>
> <Color>
> <Transparency>255</Transparency>
> <Red>0</Red>
> <Green>0</Green>
> <Blue>0</Blue>
> </Color>
> <Visible>false</Visible>
> </Outline>
> <Insets>
> <Top>0.0</Top>
> <Left>2.0</Left>
> <Bottom>0.0</Bottom>
> <Right>3.0</Right>
> </Insets>
> <Visible>false</Visible>
> </Title>
> <TitlePosition>Above</TitlePosition>
> <ShowValue>true</ShowValue>
> <WrappingSize>0.0</WrappingSize>
> <MaxPercent>0.333</MaxPercent>
> </Children>
> <Bounds>
> <Left>0.0</Left>
> <Top>0.0</Top>
> <Width>162.0</Width>
> <Height>337.5</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>true</Visible>
> </Outline>
> <Visible>true</Visible>
> </Block>
> <Dimension>Two_Dimensional</Dimension>
> <Units>Points</Units>
> <SeriesThickness>10.0</SeriesThickness>
> <ExtendedProperties>
> <Name>enable.area.alt</Name>
> <Value>false</Value>
> </ExtendedProperties>
> <SampleData>
> <BaseSampleData>
> <DataSetRepresentation>A, B, C</DataSetRepresentation>
> </BaseSampleData>
> <OrthogonalSampleData>
> <DataSetRepresentation>5,4,12</DataSetRepresentation>
> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
> </OrthogonalSampleData>
> </SampleData>
> <Interactivity/>
> <EmptyMessage>
> <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>false</Visible>
> </EmptyMessage>
> <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>
> <Rotation>-69.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>254</Blue>
> </Color>
> <Visible>true</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>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>23.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>254</Blue>
> </Color>
> <Visible>true</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>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:ColorD
|
|
|
Re: Using chart ellipsis for long labels [message #536573 is a reply to message #536572] |
Fri, 28 May 2010 17:15 |
|
BTW there are alot of PPTs and webinars on Birt-Exchange.org that show
using chart scripting. We are still working on getting the examples and
write-ups more organized.
On 5/28/2010 1:14 PM, Jason Weathersby wrote:
> Chris,
>
> If you just want to get the label values you can do this in the
> afterdataset filled. This event is fired for every series that is
> created. It is first called for the category series and then for each
> orthogonal series. So in your case the first series will be your labels.
> To get the values use the dataSet.getValues() call.
>
> function afterDataSetFilled( series, dataSet, icsc )
> {
>
> importPackage( Packages.java.io );
> out = new PrintWriter( new FileWriter( "c:/test/events.txt", true ) );
> var list = dataSet.getValues();
> out.println("=="+series.getDisplayName());
> for ( i=0; i<list.length; i=i+1)
> {
> out.println( list[i] );
>
> }
> out.close();
> }
>
> You can change a value like:
> list[i] = "I changed this category value"
>
> You can also set the values using dataSet.setValues. For example I wrote
> a script to add an extra data point to a simple bar chart like:
>
> function afterDataSetFilled(series, dataSet, icsc)
> {
> importPackage( Packages.java.io );
> importPackage( Packages.java.util );
>
> importPackage( Packages.org.eclipse.birt.chart.model.type.impl );
> var list = dataSet.getValues();
> var narray1 = new ArrayList( );
> var ll =list.length;
> for ( i=0; i<ll; i=i+1)
> {
> narray1.add(list[i]);
> }
>
> if( series.getClass() == BarSeriesImpl ){
> narray1.add(400000);
> }else{
> narray1.add("Tanks");
> }
> dataSet.setValues(narray1);
>
> }
>
> Jason
>
> On 5/27/2010 5:35 PM, Chris wrote:
>> Jason,
>>
>> Thanks for your input. I appreciate your help.
>> Attached is a sample of what i am seeing. I sized the chart a little
>> small for practical purposes but serves to illustrate my issue.
>>
>> For a label limit for my purposes I would probably use something like 30
>> characters.
>>
>> I tried your script for afterComputations and in conjuction with using
>> the beforeDrawAxisLabels function and setting the span width things work
>> better.
>>
>> I would really like to be able to modify the labels without having to
>> set a fixed span. This would allow the chart to use a larger area for
>> the bars when you have shorter labels that don't need truncated.
>> Is there a way I can access the label values in the beforeComputation
>> function?
>>
>> Is there any authoritative web sites or documentation that you could
>> point me to that would provide information about the APIs and
>> relationships of the various data structures that are available via
>> scripting?
>>
>> thanks again
>>
>> Chris
>>
>>
>>
>>
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
>> id="1">
>> <property name="comments">Copyright (c) 2007 <<Your Company Name
>> here>></property>
>> <property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100211
>> Build <2.5.2.v20100210-0630></property>
>> <html-property name="description">Creates a blank report with no
>> predefined content.</html-property>
>> <property name="units">in</property>
>> <text-property name="displayName">Blank Report</text-property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <property name="layoutPreference">auto layout</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>
>> <property name="OdaConnProfileName"></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">CUSTOMERNUMBER</property>
>> <text-property name="displayName">CUSTOMERNUMBER</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">CUSTOMERNAME</property>
>> <text-property name="displayName">CUSTOMERNAME</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">CONTACTLASTNAME</property>
>> <text-property name="displayName">CONTACTLASTNAME</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">CONTACTFIRSTNAME</property>
>> <text-property name="displayName">CONTACTFIRSTNAME</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">PHONE</property>
>> <text-property name="displayName">PHONE</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">ADDRESSLINE1</property>
>> <text-property name="displayName">ADDRESSLINE1</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">ADDRESSLINE2</property>
>> <text-property name="displayName">ADDRESSLINE2</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">CITY</property>
>> <text-property name="displayName">CITY</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">STATE</property>
>> <text-property name="displayName">STATE</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">POSTALCODE</property>
>> <text-property name="displayName">POSTALCODE</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">COUNTRY</property>
>> <text-property name="displayName">COUNTRY</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">SALESREPEMPLOYEENUMBER</property>
>> <text-property name="displayName">SALESREPEMPLOYEENUMBER</text-property>
>> </structure>
>> <structure>
>> <property name="columnName">CREDITLIMIT</property>
>> <text-property name="displayName">CREDITLIMIT</text-property>
>> </structure>
>> </list-property>
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">CUSTOMERNAME</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">CONTACTLASTNAME</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">CONTACTFIRSTNAME</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">PHONE</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">ADDRESSLINE1</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">ADDRESSLINE2</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">8</property>
>> <property name="name">CITY</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">9</property>
>> <property name="name">STATE</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">10</property>
>> <property name="name">POSTALCODE</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">11</property>
>> <property name="name">COUNTRY</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">12</property>
>> <property name="name">SALESREPEMPLOYEENUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">13</property>
>> <property name="name">CREDITLIMIT</property>
>> <property name="dataType">float</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="nativeName">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">CUSTOMERNAME</property>
>> <property name="nativeName">CUSTOMERNAME</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">CONTACTLASTNAME</property>
>> <property name="nativeName">CONTACTLASTNAME</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">CONTACTFIRSTNAME</property>
>> <property name="nativeName">CONTACTFIRSTNAME</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">PHONE</property>
>> <property name="nativeName">PHONE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">ADDRESSLINE1</property>
>> <property name="nativeName">ADDRESSLINE1</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">ADDRESSLINE2</property>
>> <property name="nativeName">ADDRESSLINE2</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">8</property>
>> <property name="name">CITY</property>
>> <property name="nativeName">CITY</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">9</property>
>> <property name="name">STATE</property>
>> <property name="nativeName">STATE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">10</property>
>> <property name="name">POSTALCODE</property>
>> <property name="nativeName">POSTALCODE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">11</property>
>> <property name="name">COUNTRY</property>
>> <property name="nativeName">COUNTRY</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">12</property>
>> <property name="name">SALESREPEMPLOYEENUMBER</property>
>> <property name="nativeName">SALESREPEMPLOYEENUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">13</property>
>> <property name="name">CREDITLIMIT</property>
>> <property name="nativeName">CREDITLIMIT</property>
>> <property name="dataType">float</property>
>> <property name="nativeDataType">8</property>
>> </structure>
>> </list-property>
>> <xml-property name="queryText"><![CDATA[select *
>> from CLASSICMODELS.CUSTOMERS]]></xml-property>
>> <xml-property name="designerValues"><![CDATA[<?xml version="1.0"
>> encoding="UTF-8"?>
>> <model:DesignValues
>> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
>> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
>> <Version>1.0</Version>
>> <design:ResultSets derivedMetaData="true">
>> <design:resultSetDefinitions>
>> <design:resultSetColumns>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>CUSTOMERNUMBER</design:name>
>> <design:position>1</design:position>
>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design: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>CUSTOMERNAME</design:name>
>> <design:position>2</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design: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>CONTACTLASTNAME</design:name>
>> <design:position>3</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>CONTACTLASTNAME</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>CONTACTLASTNAME</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>CONTACTFIRSTNAME</design:name>
>> <design:position>4</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>CONTACTFIRSTNAME</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>CONTACTFIRSTNAME</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>PHONE</design:name>
>> <design:position>5</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>PHONE</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>PHONE</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>ADDRESSLINE1</design:name>
>> <design:position>6</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>ADDRESSLINE1</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>ADDRESSLINE1</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>ADDRESSLINE2</design:name>
>> <design:position>7</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>ADDRESSLINE2</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>ADDRESSLINE2</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>CITY</design:name>
>> <design:position>8</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>CITY</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>CITY</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>STATE</design:name>
>> <design:position>9</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>STATE</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>STATE</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>POSTALCODE</design:name>
>> <design:position>10</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>15</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>POSTALCODE</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>POSTALCODE</design:label>
>> <design:formattingHints>
>> <design:displaySize>15</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>COUNTRY</design:name>
>> <design:position>11</design:position>
>> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>> <design:precision>50</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>COUNTRY</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>COUNTRY</design:label>
>> <design:formattingHints>
>> <design:displaySize>50</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>SALESREPEMPLOYEENUMBER</design:name>
>> <design:position>12</design:position>
>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>>
>> <design:displayName>SALESREPEMPLOYEENUMBER</design:displayName >
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>SALESREPEMPLOYEENUMBER</design:label>
>> <design:formattingHints>
>> <design:displaySize>11</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>CREDITLIMIT</design:name>
>> <design:position>13</design:position>
>> <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>> <design:precision>15</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>CREDITLIMIT</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>CREDITLIMIT</design:label>
>> <design:formattingHints>
>> <design:displaySize>22</design:displaySize>
>> </design:formattingHints>
>> </design:usageHints>
>> </design:resultColumnDefinitions>
>> </design:resultSetColumns>
>> </design:resultSetDefinitions>
>> </design:ResultSets>
>> </model:DesignValues>]]></xml-property>
>> </oda-data-set>
>> </data-sets>
>> <cubes>
>> <tabular-cube name="Data Cube" id="9">
>> <property name="dimensions">
>> <tabular-dimension name="Group" id="12">
>> <property name="defaultHierarchy">NewTabularHierarchy</property>
>> <property name="hierarchies">
>> <tabular-hierarchy name="NewTabularHierarchy" id="13">
>> <property name="levels">
>> <tabular-level name="COUNTRY" id="14">
>> <property name="dataType">string</property>
>> <property name="columnName">COUNTRY</property>
>> </tabular-level>
>> <tabular-level name="STATE" id="15">
>> <property name="dataType">string</property>
>> <property name="columnName">STATE</property>
>> </tabular-level>
>> </property>
>> </tabular-hierarchy>
>> </property>
>> </tabular-dimension>
>> </property>
>> <property name="measureGroups">
>> <tabular-measure-group name="Summary Field" id="10">
>> <property name="measures">
>> <tabular-measure name="CREDITLIMIT" id="11">
>> <expression
>> name="measureExpression">dataSetRow["CREDITLIMIT"]</expression >
>> <property name="dataType">float</property>
>> </tabular-measure>
>> </property>
>> </tabular-measure-group>
>> </property>
>> <property name="dataSet">Data Set</property>
>> </tabular-cube>
>> </cubes>
>> <styles>
>> <style name="crosstab-cell" 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" 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">
>> <property name="type">custom</property>
>> <property name="height">11in</property>
>> <property name="width">18in</property>
>> <property name="topMargin">1in</property>
>> <property name="leftMargin">1.25in</property>
>> <property name="bottomMargin">1in</property>
>> <property name="rightMargin">1.25in</property>
>> <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">
>> <Version>2.5.1</Version>
>> <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>
>> <Anchor>North</Anchor>
>> <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>true</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>
>> <Rotation>18.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>254</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>true</Visible>
>> </Outline>
>> <ShadowColor>
>> <Transparency>255</Transparency>
>> <Red>204</Red>
>> <Green>254</Green>
>> <Blue>204</Blue>
>> </ShadowColor>
>> <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>true</Visible>
>> </Outline>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>0</Transparency>
>> <Red>255</Red>
>> <Green>255</Green>
>> <Blue>255</Blue>
>> </Background>
>> <Visible>true</Visible>
>> <HorizontalSpacing>5</HorizontalSpacing>
>> <VerticalSpacing>5</VerticalSpacing>
>> <ClientArea>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>255</Transparency>
>> <Red>204</Red>
>> <Green>254</Green>
>> <Blue>254</Blue>
>> </Background>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>0</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>true</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>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>255</Transparency>
>> <Red>254</Red>
>> <Green>254</Green>
>> <Blue>153</Blue>
>> </Background>
>> <Visible>true</Visible>
>> <ClientArea>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>0</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Insets>
>> <Top>2.0</Top>
>> <Left>2.0</Left>
>> <Bottom>2.0</Bottom>
>> <Right>2.0</Right>
>> </Insets>
>> </ClientArea>
>> <Text>
>> <Value></Value>
>> <Font>
>> <Alignment/>
>> </Font>
>> </Text>
>> <Orientation>Vertical</Orientation>
>> <Direction>Top_Bottom</Direction>
>> <Separator>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>true</Visible>
>> </Separator>
>> <Position>Right</Position>
>> <ItemType>Series</ItemType>
>> <Title>
>> <Caption>
>> <Value></Value>
>> <Font>
>> <Alignment/>
>> </Font>
>> </Caption>
>> <Background xsi:type="attribute:ColorDefinition">
>> <Transparency>0</Transparency>
>> <Red>255</Red>
>> <Green>255</Green>
>> <Blue>255</Blue>
>> </Background>
>> <Outline>
>> <Style>Solid</Style>
>> <Thickness>1</Thickness>
>> <Color>
>> <Transparency>255</Transparency>
>> <Red>0</Red>
>> <Green>0</Green>
>> <Blue>0</Blue>
>> </Color>
>> <Visible>false</Visible>
>> </Outline>
>> <Insets>
>> <Top>0.0</Top>
>> <Left>2.0</Left>
>> <Bottom>0.0</Bottom>
>> <Right>3.0</Right>
>> </Insets>
>> <Visible>false</Visible>
>> </Title>
>> <TitlePosition>Above</TitlePosition>
>> <ShowValue>true</ShowValue>
>> <WrappingSize>0.0</WrappingSize>
>> <MaxPercent>0.333</MaxPercent>
>> </Children>
>> <Bounds>
>> <Left>0.0</Left>
>> <Top>0.0</Top>
>> <Width>162.0</Width>
>> <Height>337.5</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>true</Visible>
>> </Outline>
>> <Visible>true</Visible>
>> </Block>
>> <Dimension>Two_Dimensional</Dimension>
>> <Units>Points</Units>
>> <SeriesThickness>10.0</SeriesThickness>
>> <ExtendedProperties>
>> <Name>enable.area.alt</Name>
>> <Value>false</Value>
>> </ExtendedProperties>
>> <SampleData>
>> <BaseSampleData>
>> <DataSetRepresentation>A, B, C</DataSetRepresentation>
>> </BaseSampleData>
>> <OrthogonalSampleData>
>> <DataSetRepresentation>5,4,12</DataSetRepresentation>
>> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>> </OrthogonalSampleData>
>> </SampleData>
>> <Interactivity/>
>> <EmptyMessage>
>> <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>false</Visible>
>> </EmptyMessage>
>> <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>
>> <Rotation>-69.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>254</Blue>
>> </Color>
>> <Visible>true</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>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>23.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>254</Blue>
>> </Color>
>> <Visible>true</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>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</Tran
|
|
|
|
Re: Using chart ellipsis for long labels [message #537181 is a reply to message #536612] |
Tue, 01 June 2010 14:33 |
|
It should fire once for the category series and once for every run time
series that is generated. If you group the design series or use
optional grouping this will generate multiple run time series.
Jason
On 5/28/2010 5:40 PM, Chris wrote:
> Fantastic! this provides exactly what I need. Thanks for your help.
>
> On a side note I did notice that the afterDataSetFilled seems to be
> firing twice for each series. Is this normal behavior?
>
> thanks again
> Chris
>
> On 5/28/2010 11:14 AM, Jason Weathersby wrote:
>> Chris,
>>
>> If you just want to get the label values you can do this in the
>> afterdataset filled. This event is fired for every series that is
>> created. It is first called for the category series and then for each
>> orthogonal series. So in your case the first series will be your labels.
>> To get the values use the dataSet.getValues() call.
>>
>> function afterDataSetFilled( series, dataSet, icsc )
>> {
>>
>> importPackage( Packages.java.io );
>> out = new PrintWriter( new FileWriter( "c:/test/events.txt", true ) );
>> var list = dataSet.getValues();
>> out.println("=="+series.getDisplayName());
>> for ( i=0; i<list.length; i=i+1)
>> {
>> out.println( list[i] );
>>
>> }
>> out.close();
>> }
>>
>> You can change a value like:
>> list[i] = "I changed this category value"
>>
>> You can also set the values using dataSet.setValues. For example I wrote
>> a script to add an extra data point to a simple bar chart like:
>>
>> function afterDataSetFilled(series, dataSet, icsc)
>> {
>> importPackage( Packages.java.io );
>> importPackage( Packages.java.util );
>>
>> importPackage( Packages.org.eclipse.birt.chart.model.type.impl );
>> var list = dataSet.getValues();
>> var narray1 = new ArrayList( );
>> var ll =list.length;
>> for ( i=0; i<ll; i=i+1)
>> {
>> narray1.add(list[i]);
>> }
>>
>> if( series.getClass() == BarSeriesImpl ){
>> narray1.add(400000);
>> }else{
>> narray1.add("Tanks");
>> }
>> dataSet.setValues(narray1);
>>
>> }
>>
>> Jason
>>
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04097 seconds