Home » Archived » BIRT » Chart with BIRT 1.0
| Chart with BIRT 1.0 [message #46535] |
Wed, 15 June 2005 12:20  |
Eclipse User |
|
|
|
Originally posted by: nospam.free.fr
Hi,
Does someone manage to create a simple chart with BIRT ?
I can't manage to do something as simple as :
- X axis : date data coming from dataset
- Y axis : numeric data summed on date grouping
I have a dataset containing
-date
-sells
-store
Do I need to group my data in my query or BIRT group management can ? (
without any performance consideration)
Can someone explain how to create simple dataset based charts ?
Best regards,
Bj
|
|
|
| Re: Chart with BIRT 1.0 [message #46847 is a reply to message #46535] |
Wed, 15 June 2005 18:48  |
| Eclipse User |
|
|
|
Originally posted by: mpadhye.actuate.com
Bj,
Creating a chart with grouping involves the following steps.
1. Bind the dataset with the chart. To do this, in the Chart Builder
(the dialog launched when you insert a chart into the report and select
the type), go to the 'Data' node in the tree. This will bring up the
data binding sheet. From the drop-down box, select the dataset from
those available in the report.
2a. Set the X Series data field. In the tree on the left, click on the
Data -> X Series node. This will bring up the data sheet for the X
series. In the text field, specify the field which will provide the data
for the X axis.
2b. Since your X Series data is comprised of dates, you will need to
change the X Axis type to DateTime. You can do this by going to the X
axis data sheet (Data -> X Axis node in the tree).
3. Set the Y Series data field. In the tree on the left, go to the Data
-> Y Series node. Like you did for the X series, specify the data field
for the Y Series in the text box.
4. Specify the grouping. The field on which the data is to be grouped
is specified in the Y Axis data sheet available from the Data->Y Axis
node in the tree (since this is where groups of series are defined). In
the text field for 'Series Grouping Key', specify the field you want to
group on.
5. Click on Ok in the dialog to finish creating the chart.
-Milind
Bj wrote:
> Hi,
>
> Does someone manage to create a simple chart with BIRT ?
> I can't manage to do something as simple as :
> - X axis : date data coming from dataset
> - Y axis : numeric data summed on date grouping
>
> I have a dataset containing -date
> -sells
> -store
>
> Do I need to group my data in my query or BIRT group management can ? (
> without any performance consideration)
>
> Can someone explain how to create simple dataset based charts ?
>
> Best regards,
>
> Bj
>
|
|
|
| Re: Chart with BIRT 1.0 [message #53807 is a reply to message #46847] |
Tue, 05 July 2005 20:43 |
| Eclipse User |
|
|
|
Originally posted by: Patrick.Lai.broadvision.com
This is a multi-part message in MIME format.
--------------080704080504050409020704
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
I tried the steps, but my report failed with this error message:
There are errors on the report page:
Error1:Failed to render Chart
$NO-RB$ Unexpected error
The app server console output (BIRT Web Viewer on JBoss) showed a
"java.lang.ArrayIndexOutOfBoundsException: 1" exception.
My X-series is simply 'row["X"]' (X an integer column), and my Y-series,
'Total.count()'. I use 'row["X"]' as the grouping key (for the Y-axis).
The report runs successfully (though not the result I want) if I take
out the grouping key.
Any suggestions? I'm enclosing my report, console output (from JBoss),
and SQL script to initlialize the table (for MySQL 4.1).
Thanks,
Patrick
Milind Padhye wrote:
> Bj,
>
> Creating a chart with grouping involves the following steps.
>
> 1. Bind the dataset with the chart. To do this, in the Chart Builder
> (the dialog launched when you insert a chart into the report and select
> the type), go to the 'Data' node in the tree. This will bring up the
> data binding sheet. From the drop-down box, select the dataset from
> those available in the report.
>
> 2a. Set the X Series data field. In the tree on the left, click on
> the Data -> X Series node. This will bring up the data sheet for the X
> series. In the text field, specify the field which will provide the data
> for the X axis.
>
> 2b. Since your X Series data is comprised of dates, you will need to
> change the X Axis type to DateTime. You can do this by going to the X
> axis data sheet (Data -> X Axis node in the tree).
>
> 3. Set the Y Series data field. In the tree on the left, go to the
> Data -> Y Series node. Like you did for the X series, specify the data
> field for the Y Series in the text box.
>
> 4. Specify the grouping. The field on which the data is to be
> grouped is specified in the Y Axis data sheet available from the Data->Y
> Axis node in the tree (since this is where groups of series are
> defined). In the text field for 'Series Grouping Key', specify the field
> you want to group on.
>
> 5. Click on Ok in the dialog to finish creating the chart.
>
> -Milind
>
> Bj wrote:
>
>> Hi,
>>
>> Does someone manage to create a simple chart with BIRT ?
>> I can't manage to do something as simple as :
>> - X axis : date data coming from dataset
>> - Y axis : numeric data summed on date grouping
>>
>> I have a dataset containing -date
>> -sells
>> -store
>>
>> Do I need to group my data in my query or BIRT group management can ?
>> ( without any performance consideration)
>>
>> Can someone explain how to create simple dataset based charts ?
>>
>> Best regards,
>>
>> Bj
>>
--------------080704080504050409020704
Content-Type: text/xml;
name="SimpleReport1.rptdesign"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="SimpleReport1.rptdesign"
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 1.0 -->
<report xmlns=" http://www.eclipse.org/birt/2005/design" version="1">
<property name="createdBy">Eclipse BIRT Designer Version 1.0.0 Build <20050628-0429></property>
<property name="units">in</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="MySQL (plai_db0)">
<property name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://localhost/plai_db0</property>
<property name="odaUser">plai</property>
<encrypted-property name="odaPassword">aWJwbGFp</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Test01">
<property name="dataSource">MySQL (plai_db0)</property>
<list-property name="columnHints">
<structure>
<property name="columnName">X</property>
<property name="displayName">XXX</property>
</structure>
<structure>
<property name="columnName">Y</property>
<property name="displayName">YYY</property>
</structure>
</list-property>
<property name="queryText">select birt_test1.X, birt_test1.Y
from birt_test1
order by birt_test1.X</property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Test02">
<property name="dataSource">MySQL (plai_db0)</property>
<list-property name="columnHints">
<structure>
<property name="columnName">X</property>
<property name="displayName">XXX</property>
</structure>
<structure>
<property name="columnName">Y</property>
<property name="displayName">YYY</property>
</structure>
</list-property>
<property name="queryText">select birt_test1.X, birt_test1.Y
from birt_test1
order by birt_test1.X</property>
</oda-data-set>
</data-sets>
<styles>
<style name="NewStyle">
<property name="fontFamily">Times New Roman</property>
<property name="fontSize">x-large</property>
<property name="fontWeight">bold</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage">
<page-footer>
<text>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table>
<property name="width">100%</property>
<property name="dataSet">Test01</property>
<column/>
<column/>
<column/>
<header>
<row>
<cell>
<label>
<text-property name="text">BIRT Test 1</text-property>
</label>
</cell>
<cell/>
<cell/>
</row>
</header>
<group>
<property name="groupName">ByX</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["X"]</expression>
<header>
<row>
<cell/>
<cell>
<data>
<property name="style">NewStyle</property>
<expression name="valueExpr">"XXX=" + row["X"]</expression>
</data>
</cell>
<cell/>
</row>
</header>
<footer>
<row>
<cell/>
<cell/>
<cell/>
</row>
</footer>
</group>
<detail>
<row>
<cell>
<data>
<expression name="valueExpr">row["Y"]</expression>
</data>
</cell>
<cell/>
<cell/>
</row>
</detail>
<footer>
<row>
<cell>
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
</cell>
</row>
</footer>
</table>
<extended-item extensionName="Chart">
<property name="height">250pt</property>
<property name="width">400pt</property>
<property name="dataSet">Test01</property>
<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>Stacked</SubType>
<Block>
<Children xsi:type="layout:TitleBlock">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<Label>
<Caption>
<Value>Line Chart Title</Value>
<Font>
<Name>SansSerif</Name>
<Size>24.0</Size>
<Bold>false</Bold>
<Italic>false</Italic>
<Strikethrough>false</Strikethrough>
<Underline>false</Underline>
<Alignment>
<horizontalAlignment>Left</horizontalAlignment>
<verticalAlignment>Top</verticalAlignment>
</Alignment>
<Rotation>0.0</Rotation>
</Font>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
</Children>
<Children xsi:type="layout:Plot">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<HorizontalSpacing>5</HorizontalSpacing>
<VerticalSpacing>5</VerticalSpacing>
<ClientArea>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>0.0</Left>
<Bottom>0.0</Bottom>
<Right>0.0</Right>
</Insets>
</ClientArea>
</Children>
<Children xsi:type="layout:Legend">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>2.0</Top>
<Left>2.0</Left>
<Bottom>2.0</Bottom>
<Right>2.0</Right>
</Insets>
</ClientArea>
<Text>
<Value><undefined></Value>
<Font>
<Name>SansSerif</Name>
<Size>12.0</Size>
<Bold>false</Bold>
<Italic>false</Italic>
<Strikethrough>false</Strikethrough>
<Underline>false</Underline>
<Alignment>
<horizontalAlignment>Left</horizontalAlignment>
<verticalAlignment>Top</verticalAlignment>
</Alignment>
<Rotation>0.0</Rotation>
</Font>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Text>
<Orientation>Vertical</Orientation>
<Direction>Top_Bottom</Direction>
<Position>Right</Position>
<ItemType>Series</ItemType>
</Children>
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>400.0</Width>
<Height>250.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Visible>true</Visible>
</Block>
<Dimension>Two_Dimensional</Dimension>
<Units>Points</Units>
<SeriesThickness>10.0</SeriesThickness>
<SampleData>
<BaseSampleData>
<DataSetRepresentation>A, B, C</DataSetRepresentation>
</BaseSampleData>
<OrthogonalSampleData>
<DataSetRepresentation>5,3,12</DataSetRepresentation>
<SeriesDefinitionIndex>0</SeriesDefinitionIndex>
</OrthogonalSampleData>
</SampleData>
<Axes>
<Type>Text</Type>
<Title>
<Caption>
<Value>X-Axis Title</Value>
<Font>
<Name>SansSerif</Name>
<Size>16.0</Size>
<Bold>true</Bold>
<Italic>false</Italic>
<Strikethrough>false</Strikethrough>
<Underline>false</Underline>
<Alignment>
<horizontalAlignment>Left</horizontalAlignment>
<verticalAlignment>Top</verticalAlignment>
</Alignment>
<Rotation>0.0</Rotation>
</Font>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Title>
<TitlePosition>Below</TitlePosition>
<AssociatedAxes>
<Type>Linear</Type>
<Title>
<Caption>
<Value>Y-Axis Title</Value>
<Font>
<Name>SansSerif</Name>
<Size>16.0</Size>
<Bold>true</Bold>
<Italic>false</Italic>
<Strikethrough>false</Strikethrough>
<Underline>false</Underline>
<Alignment>
<horizontalAlignment>Left</horizontalAlignment>
<verticalAlignment>Top</verticalAlignment>
</Alignment>
<Rotation>90.0</Rotation>
</Font>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Title>
<TitlePosition>Left</TitlePosition>
<SeriesDefinitions>
<Query>
<Definition>row["X"]</Definition>
</Query>
<SeriesPalette>
<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>128</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>0</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>
</SeriesPalette>
<Series xsi:type="type:BarSeries">
<Visible>true</Visible>
<Label>
<Caption>
<Value><undefined></Value>
<Font>
<Name>SansSerif</Name>
<Size>12.0</Size>
<Bold>false</Bold>
<Italic>false</Italic>
<Strikethrough>false</Strikethrough>
<Underline>false</Underline>
<Alignment>
<horizontalAlignment>Left</horizontalAlignment>
<verticalAlignment>Top</verticalAlignment>
</Alignment>
<Rotation>0.0</Rotation>
</Font>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
<DataDefinition>
<Definition>Total.count()</Definition>
</DataDefinition>
<SeriesIdentifier><undefined></SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Outside</LabelPosition>
<Stacked>true</Stacked>
<Riser>Rectangle</Riser>
<RiserOutline>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</RiserOutline>
</Series>
<Grouping>
<Enabled>false</Enabled>
<GroupingInterval>2</GroupingInterval>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</SeriesDefinitions>
<Orientation>Vertical</Orientation>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</LineAttributes>
<Label>
<Caption>
<Value><undefined></Value>
<Font>
<Name>SansSerif</Name>
<Size>12.0</Size>
<Bold>false</Bold>
<Italic>false</Italic>
<Strikethrough>false</Strikethrough>
<Underline>false</Underline>
<Alignment>
<horizontalAlignment>Left</horizontalAlignment>
<verticalAlignment>Top</verticalAlignment>
</Alignment>
<Rotation>0.0</Rotation>
</Font>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
<LabelPosition>Left</LabelPosition>
<MajorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>true</Visible>
</TickAttributes>
</MajorGrid>
<MinorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</TickAttributes>
</MinorGrid>
<Scale>
<MinorGridsPerUnit>5</MinorGridsPerUnit>
</Scale>
<Origin>
<Type>Min</Type>
<Value xsi:type="data:NumberDataElement">
<Value>0.0</Value>
</Value>
</Origin>
<PrimaryAxis>true</PrimaryAxis>
<Percent>false</Percent>
</AssociatedAxes>
<SeriesDefinitions>
<Query>
<Definition></Definition>
</Query>
<SeriesPalette>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>127</Red>
<Green>127</Green>
<Blue>127</Blue>
</Entries>
</SeriesPalette>
<Series>
<Visible>true</Visible>
<Label>
<Caption>
<Value><undefined></Value>
<Font>
<Name>SansSerif</Name>
<Size>12.0</Size>
<Bold>false</Bold>
<Italic>false</Italic>
<Strikethrough>false</Strikethrough>
<Underline>false</Underline>
<Alignment>
<horizontalAlignment>Left</horizontalAlignment>
<verticalAlignment>Top</verticalAlignment>
</Alignment>
<Rotation>0.0</Rotation>
</Font>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<DataDefinition>
<Definition>row["X"]</Definition>
</DataDefinition>
<SeriesIdentifier><undefined></SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Outside</LabelPosition>
<Stacked>false</Stacked>
</Series>
<Grouping>
<Enabled>false</Enabled>
<GroupingInterval>2</GroupingInterval>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</SeriesDefinitions>
<Orientation>Horizontal</Orientation>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</LineAttributes>
<Label>
<Caption>
<Value><undefined></Value>
<Font>
<Name>SansSerif</Name>
<Size>12.0</Size>
<Bold>false</Bold>
<Italic>false</Italic>
<Strikethrough>false</Strikethrough>
<Underline>false</Underline>
<Alignment>
<horizontalAlignment>Left</horizontalAlignment>
<verticalAlignment>Top</verticalAlignment>
</Alignment>
<Rotation>0.0</Rotation>
</Font>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
<LabelPosition>Below</LabelPosition>
<MajorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>true</Visible>
</TickAttributes>
</MajorGrid>
<MinorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</TickAttributes>
</MinorGrid>
<Scale>
<MinorGridsPerUnit>5</MinorGridsPerUnit>
</Scale>
<Origin>
<Type>Min</Type>
<Value xsi:type="data:NumberDataElement">
<Value>0.0</Value>
</Value>
</Origin>
<PrimaryAxis>true</PrimaryAxis>
<CategoryAxis>true</CategoryAxis>
<Percent>false</Percent>
</Axes>
<Orientation>Vertical</Orientation>
</model:ChartWithAxes>
]]></xml-property>
</extended-item>
</body>
</report>
--------------080704080504050409020704
Content-Type: text/plain;
name="SimpleReport1.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="SimpleReport1.txt"
17:16:14,373 INFO [STDOUT] [INFO]: getProperty(...) - chart.instance
17:16:14,373 INFO [STDOUT] [INFO]: ChartReportItemQueryImpl: getReportQueries(...) - start
17:16:14,373 INFO [STDOUT] [INFO]: ChartReportItemQueryImpl: getReportQueries(...) - end
17:16:14,413 INFO [STDOUT] [INFO]: getProperty(...) - chart.instance
17:16:14,413 INFO [STDOUT] [INFO]: ChartReportItemGenerationImpl: onRowSets(...) - start
17:16:14,413 INFO [STDOUT] 1,
17:16:14,413 INFO [STDOUT] 1,
17:16:14,413 INFO [STDOUT] 1,
17:16:14,413 INFO [STDOUT] 1,
17:16:14,413 INFO [STDOUT] 2,
17:16:14,413 INFO [STDOUT] 2,
17:16:14,413 INFO [STDOUT] 2,
17:16:14,413 INFO [STDOUT] 3,
17:16:14,413 INFO [STDOUT] 3,
17:16:14,413 INFO [STDOUT] 3,
17:16:14,413 INFO [STDOUT] 3,
17:16:14,413 INFO [STDOUT] 3,
17:16:14,413 INFO [STDOUT] 3,
17:16:14,413 INFO [STDOUT] [INFO]: (ECLIPSE-ENV) Creating dsp org.eclipse.birt.chart.datafeed.DataSetProcessorImpl
17:16:14,413 INFO [STDOUT] [INFO]: ChartReportItemPresentationImpl: onRowSets(...) - failed
17:16:14,413 INFO [STDOUT] [ERR]: java.lang.ArrayIndexOutOfBoundsException: 1
17:16:14,413 INFO [STDOUT] java.lang.ArrayIndexOutOfBoundsException: 1
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.chart.datafeed.ResultSetDataSet.getDataType (ResultSetDataSet.java:128)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.chart.datafeed.DataSetProcessorImpl.populat e(DataSetProcessorImpl.java:254)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.chart.reportitem.QueryHelper.fillSeriesData Set(QueryHelper.java:775)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.chart.reportitem.QueryHelper.generateRuntim eSeries(QueryHelper.java:715)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.chart.reportitem.QueryHelper.generateRuntim eSeries(QueryHelper.java:529)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.chart.reportitem.ChartReportItemPresentatio nImpl.onRowSets(ChartReportItemPresentationImpl.java:243)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor .execute(ExtendedItemExecutor.java:180)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitExtendedItem(ReportExecutorVisitor.java:239)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.engine.ir.ExtendedItemDesign.accept( ExtendedItemDesign.java:30)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:158)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:152)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.viewer.aggregation.layout.EngineFrag ment.doService(Unknown Source)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.viewer.aggregation.BaseFragment.serv ice(Unknown Source)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.viewer.servlets.ViewerServlet.doPost (Unknown Source)
17:16:14,413 INFO [STDOUT] at org.eclipse.birt.report.viewer.servlets.ViewerServlet.doGet( Unknown Source)
17:16:14,413 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
17:16:14,413 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:237)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:157)
17:16:14,413 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:75)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:186)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:157)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:214)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInternal (StandardContextValve.java:198)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:152)
17:16:14,413 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
17:16:14,413 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:66)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
17:16:14,423 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
17:16:14,423 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:54)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:137)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:118)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:109)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
17:16:14,423 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:929)
17:16:14,423 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapte r.java:160)
17:16:14,423 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:799)
17:16:14,423 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:705)
17:16:14,423 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:577)
17:16:14,423 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
17:16:14,423 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
17:16:14,423 INFO [STDOUT] [INFO]: ChartReportItemPresentationImpl: finish(...) - start
17:16:14,423 INFO [STDOUT] [INFO]: ChartReportItemPresentationImpl: finish(...) - end
17:16:14,423 INFO [STDOUT] line 1 column 1 - Warning: inserting missing 'title' element
--------------080704080504050409020704
Content-Type: text/plain;
name="SimpleReport1.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="SimpleReport1.sql"
/* Assume MySQL4.1 */
create table BIRT_Test1 ( X integer, Y integer );
insert into BIRT_Test1 values(1, 100);
insert into BIRT_Test1 values(1, 110);
insert into BIRT_Test1 values(1, 120);
insert into BIRT_Test1 values(1, 130);
insert into BIRT_Test1 values(2, 200);
insert into BIRT_Test1 values(2, 201);
insert into BIRT_Test1 values(2, 202);
insert into BIRT_Test1 values(3, 310);
insert into BIRT_Test1 values(3, 311);
insert into BIRT_Test1 values(3, 312);
insert into BIRT_Test1 values(3, 313);
insert into BIRT_Test1 values(3, 314);
insert into BIRT_Test1 values(3, 315);
--------------080704080504050409020704--
|
|
|
Goto Forum:
Current Time: Sat Jun 14 10:26:41 EDT 2025
Powered by FUDForum. Page generated in 0.15865 seconds |
Home