Home » Archived » BIRT » help me
| help me [message #184195] |
Thu, 10 August 2006 06:49  |
Eclipse User |
|
|
|
Originally posted by: karurkarthi.yahoo.co.in
Hello,
how to invoke a java script function at runtime.
i want to call a java script function at run time when clicking the chart.
kindly give me the solution for this.
thanks
karthikeyan
|
|
|
| Re: help me [message #184206 is a reply to message #184195] |
Thu, 10 August 2006 10:33  |
| Eclipse User |
|
|
|
Here is an example.
The bars are setup to drill to a detail report (which is not attached).
The marker line has a javascript function that just does an alert. Look at
the interactivity on the y-axis->markerlines.
Jason
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.1.0.N20060628-1351 Build <20060628-1537></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="Data Source" id="4">
<text-property name="displayName">Data Source</text-property>
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="5">
<text-property name="displayName">Data Set</text-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">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="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<list-property name="resultSetHints">
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERNUMBER_3</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">CUSTOMERNUMBER_3</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">select CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
sum(ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
from CUSTOMERS, ORDERS, ORDERDETAILS
where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER group by
CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER order by
CUSTOMERTOTAL</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="aggrQuery" id="8">
<text-property name="displayName">aggrQuery</text-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<list-property name="resultSetHints">
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER_4</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER_4</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">select CLASSICMODELS.CUSTOMERS.CREDITLIMIT,
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, CUSTOMERS.CUSTOMERNAME,
CUSTOMERS.CUSTOMERNUMBER, sum(ORDERDETAILS.QUANTITYORDERED *
ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
from CUSTOMERS, ORDERS, ORDERDETAILS
where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
CLASSICMODELS.CUSTOMERS.CREDITLIMIT
order by CUSTOMERTOTAL</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="salesbyproductline" id="13">
<text-property name="displayName">salesbyproductline</text-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRODUCTLINE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">TOTALREVENUE</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRODUCTLINE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">TOTALREVENUE</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">SELECT PRODUCTLINE,
SUM( PRICEEACH*QUANTITYORDERED ) AS "TOTALREVENUE"
FROM CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.PRODUCTS
WHERE CLASSICMODELS.ORDERDETAILS.PRODUCTCODE =
CLASSICMODELS.PRODUCTS.PRODUCTCODE
GROUP BY CLASSICMODELS.PRODUCTS.PRODUCTLINE</property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="orientation">landscape</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" id="6">
<property name="height">3.947in</property>
<property name="width">6.26in</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSTOMERNAME</property>
<expression name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CUSTOMERTOTAL</property>
<expression name="expression">dataSetRow["CUSTOMERTOTAL"]</expression >
<property name="dataType">float</property>
</structure>
</list-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>Side-by-side</SubType>
<Description>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Description>
<Block>
<Children xsi:type="layout:TitleBlock">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>Chart Title</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<Label>
<Caption>
<Value>Top Customers Link to Orders RptDocument</Value>
<Font>
<Size>16.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
</Children>
<Children xsi:type="layout:Plot">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<HorizontalSpacing>5</HorizontalSpacing>
<VerticalSpacing>5</VerticalSpacing>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>0.0</Left>
<Bottom>0.0</Bottom>
<Right>0.0</Right>
</Insets>
</ClientArea>
</Children>
<Children xsi:type="layout:Legend">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>Legend</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<Triggers>
<Condition>onclick</Condition>
<Action>
<Type>Toggle_Visibility</Type>
<Value xsi:type="attribute:SeriesValue">
<Name></Name>
</Value>
</Action>
</Triggers>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>2.0</Top>
<Left>2.0</Left>
<Bottom>2.0</Bottom>
<Right>2.0</Right>
</Insets>
</ClientArea>
<Text>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Text>
<Orientation>Vertical</Orientation>
<Direction>Top_Bottom</Direction>
<Separator>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</Separator>
<Position>Right</Position>
<ItemType>Series</ItemType>
<Title>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Above</TitlePosition>
</Children>
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>450.0</Width>
<Height>283.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>false</Visible>
</Outline>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Visible>true</Visible>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>Chart Area</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
</Block>
<Dimension>Two_Dimensional</Dimension>
<Script>/**
* The chart script methods provide control on the chart databinding,
generation and rendering.
*
* The methods have been commented in the following code, please uncomment
and implement the
* ones you need. Note that for simplicity the "after" methods have
not be included here.
*
* This script syntax follows JavaScript specifications, the Java classes
that are referred to
* in the comments can be accessed as JavaScript classes.
*
* Script examples are available in the org.eclipse.birt.chart.examples
plugin
*/
function beforeDrawAxisLabel( axis, label, context )
{
importPackage(Packages.java.lang);
importPackage(Packages.java.util);
importPackage(Packages.org.eclipse.birt.chart.model.attribut e);
if (axis.getType() == AxisType.TEXT_LITERAL){
dateTime = new Date();
var mth = dateTime.getMonth() + 1;
var yr = dateTime.getYear() + 1900;
newLabel = mth + '/' + yr;
label.getCaption().setValue(newLabel);
axis.setLabel(label);
}
}
/**
* Called before populating the series dataset using the DataSetProcessor.
*
* @param series
* Series
* @param dataSetProcessor
* DataSetProcessor
* @param context
* IChartScriptContext
*/
//function beforeDataSetFilled( series, dataSetProcessor, context ){}
/**
* Called before generation of chart model to GeneratedChartState.
*
* @param chart
* Chart Model
* @param context
* IChartScriptContext
*/
//function beforeGeneration( chart, context ){}
/**
* Called before the chart is rendered.
*
* @param gcs
* GeneratedChartState
* @param context
* IChartScriptContext
*/
//function beforeRendering( gcs, context ){}
/**
* Called before drawing each block.
*
* @param block
* Block
* @param context
* IChartScriptContext
*/
//function beforeDrawBlock( block, context ){}
/**
* Called before drawing each entry the legend.
*
* @param label
* Label
* @param context
* IChartScriptContext
*/
//function beforeDrawLegendEntry( label, context ){}
/**
* Called before rendering Series.
*
* @param series
* Series
* @param seriesRenderer
* ISeriesRenderer
* @param context
* IChartScriptContext
*/
//function beforeDrawSeries( series, seriesRenderer, context ){}
/**
* Called before rendering the title of a Series.
*
* @param series
* Series
* @param label
* Label
* @param context
* IChartScriptContext
*/
//function beforeDrawSeriesTitle( series, label, context ){}
/**
* Called before drawing each marker line in an Axis.
*
* @param axis
* Axis
* @param markerLine
* MarkerLine
* @param context
* IChartScriptContext
*/
//function beforeDrawMarkerLine( axis, markerLine, context ){}
/**
* Called before drawing each marker range in an Axis.
*
* @param axis
* Axis
* @param markerRange
* MarkerRange
* @param context
* IChartScriptContext
*/
//function beforeDrawMarkerRange( axis, markerRange, context ){}
/**
* Called before drawing each datapoint graphical representation or marker.
*
* @param dph
* DataPointHints
* @param fill
* Fill
* @param context
* IChartScriptContext
*/
//function beforeDrawDataPoint( dph, fill, context ){}
/**
* Called before rendering the label for each datapoint.
*
* @param dph
* DataPointHints
* @param label
* Label
* @param context
* IChartScriptContext
*/
//function beforeDrawDataPointLabel( dph, label, context ){}
/**
* Called before rendering curve fitting.
*
* @param cf
* CurveFitting
* @param context
* IChartScriptContext
*/
//function beforeDrawFittingCurve( cf, context ){}
/**
* Called before rendering each label on a given Axis.
*
* @param axis
* Axis
* @param label
* Label
* @param context
* IChartScriptContext
*/
/**
* Called before rendering the Title of an Axis.
*
* @param axis
* Axis
* @param label
* Title Label
* @param context
* IChartScriptContext
*/
//function beforeDrawAxisTitle( axis, label, context ){}
</Script>
<Units>Points</Units>
<SeriesThickness>40.0</SeriesThickness>
<SampleData>
<BaseSampleData>
<DataSetRepresentation>A, B, C</DataSetRepresentation>
</BaseSampleData>
<OrthogonalSampleData>
<DataSetRepresentation>5,4,12</DataSetRepresentation>
<SeriesDefinitionIndex>0</SeriesDefinitionIndex>
</OrthogonalSampleData>
</SampleData>
<Interactivity/>
<Axes>
<Type>Text</Type>
<Title>
<Caption>
<Value>X-Axis Title</Value>
<Font>
<Size>14.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Title>
<TitlePosition>Below</TitlePosition>
<AssociatedAxes>
<Type>Linear</Type>
<Title>
<Caption>
<Value>Y-Axis Title</Value>
<Font>
<Size>14.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
<Rotation>90.0</Rotation>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<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>
</Title>
<TitlePosition>Left</TitlePosition>
<SeriesDefinitions>
<Query>
<Definition>row["CUSTOMERNAME"]</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>
</SeriesPalette>
<FormatSpecifier xsi:type="attribute:NumberFormatSpecifier">
<Prefix></Prefix>
<Suffix></Suffix>
<FractionDigits>0</FractionDigits>
</FormatSpecifier>
<Series xsi:type="type:BarSeries">
<Visible>true</Visible>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<DataDefinition>
<Definition>row["CUSTOMERTOTAL"]</Definition >
</DataDefinition>
<SeriesIdentifier></SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Outside</LabelPosition>
<Stacked>true</Stacked>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>row["CUSTOMERTOTAL"].toFixed(2)</Text >
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<Triggers>
<Condition>onclick</Condition>
<Action>
<Type>URL_Redirect</Type>
<Value xsi:type="attribute:URLValue">
<BaseUrl><structure name="action">
<property name="formatType">html</property>
<property name="linkType">drill-through</property >
<property
name="reportName">CustomerOrders.rptdocument</property >
<expression
name="targetBookmark">row["CUSTOMERNAME"]</expression >
<property name="targetBookmarkType">toc</property >
<property name="targetWindow">_blank</property >
<property
name="targetFileType">report-document</property >
</structure>
</BaseUrl>
<BaseParameterName></BaseParameterName>
<ValueParameterName></ValueParameterName>
<SeriesParameterName></SeriesParameterName>
</Value>
</Action>
</Triggers>
<Translucent>true</Translucent>
<Riser>Rectangle</Riser>
</Series>
<Grouping>
<Enabled>false</Enabled>
<GroupingInterval>2</GroupingInterval>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</SeriesDefinitions>
<Orientation>Vertical</Orientation>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</LineAttributes>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<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>
<LabelPosition>Left</LabelPosition>
<MarkerLines>
<LineAttributes>
<Style>Dotted</Style>
<Thickness>2</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</LineAttributes>
<Value xsi:type="data:NumberDataElement">
<Value>400000.0</Value>
</Value>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<LabelAnchor>North_East</LabelAnchor>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>Marker Line</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<Triggers>
<Condition>onclick</Condition>
<Action>
<Type>Invoke_Script</Type>
<Value xsi:type="attribute:ScriptValue">
<Script>alert("Marker Clicked");</Script>
</Value>
</Action>
</Triggers>
</MarkerLines>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>Y Axis</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<MajorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>true</Visible>
</TickAttributes>
</MajorGrid>
<MinorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</TickAttributes>
</MinorGrid>
<Scale>
<MinorGridsPerUnit>5</MinorGridsPerUnit>
</Scale>
<Origin>
<Type>Min</Type>
<Value xsi:type="data:NumberDataElement">
<Value>0.0</Value>
</Value>
</Origin>
<PrimaryAxis>true</PrimaryAxis>
<Percent>false</Percent>
</AssociatedAxes>
<SeriesDefinitions>
<Query>
<Definition></Definition>
</Query>
<SeriesPalette>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>166</Green>
<Blue>218</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>242</Red>
<Green>88</Green>
<Blue>106</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>232</Red>
<Green>172</Green>
<Blue>57</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>64</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>170</Red>
<Green>85</Green>
<Blue>85</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
</SeriesPalette>
<Series>
<Visible>true</Visible>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<DataDefinition>
<Definition>row["CUSTOMERNAME"]</Definition >
</DataDefinition>
<SeriesIdentifier></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>
<Sorting>Descending</Sorting>
</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></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
<LabelPosition>Below</LabelPosition>
<Staggered>false</Staggered>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>X Axis</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<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>
<T
|
|
|
| Re: help me [message #184227 is a reply to message #184206] |
Fri, 11 August 2006 02:38 |
| Eclipse User |
|
|
|
Originally posted by: karurkarthi.yahoo.co.in
Thanks for your valuable reply.
I need one more help. Look at chart area interactivity in onclick event; I
need to call java script function. But I don't know where to write the java
script function.
Awaiting for your immediate response
Thanks
Karthikeyan
Modified report
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.1.0.N20060628-1351 Build <20060628-1537></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="Data Source" id="4">
<text-property name="displayName">Data Source</text-property>
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
<encrypted-property name="odaPassword"></encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="5">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">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="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<list-property name="resultSetHints">
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERNUMBER_3</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">CUSTOMERNUMBER_3</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">select
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
sum(ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
from CUSTOMERS, ORDERS, ORDERDETAILS
where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER group by
CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER order by
CUSTOMERTOTAL</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="aggrQuery" id="8">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<list-property name="resultSetHints">
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER_4</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CUSTOMERNUMBER_4</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">CUSTOMERTOTAL</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">select
CLASSICMODELS.CUSTOMERS.CREDITLIMIT,
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, CUSTOMERS.CUSTOMERNAME,
CUSTOMERS.CUSTOMERNUMBER, sum(ORDERDETAILS.QUANTITYORDERED *
ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
from CUSTOMERS, ORDERS, ORDERDETAILS
where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
CLASSICMODELS.CUSTOMERS.CREDITLIMIT
order by CUSTOMERTOTAL</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="salesbyproductline" id="13">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRODUCTLINE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">TOTALREVENUE</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRODUCTLINE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">TOTALREVENUE</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">SELECT PRODUCTLINE,
SUM( PRICEEACH*QUANTITYORDERED ) AS "TOTALREVENUE"
FROM CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.PRODUCTS
WHERE CLASSICMODELS.ORDERDETAILS.PRODUCTCODE =
CLASSICMODELS.PRODUCTS.PRODUCTCODE
GROUP BY CLASSICMODELS.PRODUCTS.PRODUCTLINE</property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new
Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<extended-item extensionName="Chart" id="6">
<property name="height">3.947in</property>
<property name="width">6.26in</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSTOMERNAME</property>
<expression
name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression
name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CUSTOMERTOTAL</property>
<expression
name="expression">dataSetRow["CUSTOMERTOTAL"]</expression >
<property name="dataType">float</property>
</structure>
</list-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>Side-by-side</SubType>
<Description>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Description>
<Block>
<Children xsi:type="layout:TitleBlock">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>Chart Title</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<Label>
<Caption>
<Value>Top Customers Link to Orders RptDocument</Value>
<Font>
<Size>16.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
</Children>
<Children xsi:type="layout:Plot">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<HorizontalSpacing>5</HorizontalSpacing>
<VerticalSpacing>5</VerticalSpacing>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>0.0</Left>
<Bottom>0.0</Bottom>
<Right>0.0</Right>
</Insets>
</ClientArea>
</Children>
<Children xsi:type="layout:Legend">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>Legend</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<Triggers>
<Condition>onclick</Condition>
<Action>
<Type>Toggle_Visibility</Type>
<Value xsi:type="attribute:SeriesValue">
<Name></Name>
</Value>
</Action>
</Triggers>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>2.0</Top>
<Left>2.0</Left>
<Bottom>2.0</Bottom>
<Right>2.0</Right>
</Insets>
</ClientArea>
<Text>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Text>
<Orientation>Vertical</Orientation>
<Direction>Top_Bottom</Direction>
<Separator>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</Separator>
<Position>Right</Position>
<ItemType>Series</ItemType>
<Title>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Above</TitlePosition>
</Children>
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>450.0</Width>
<Height>283.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>false</Visible>
</Outline>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Visible>true</Visible>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>Chart Area</Text>
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<Triggers>
<Condition>onclick</Condition>
<Action>
<Type>Invoke_Script</Type>
<Value xsi:type="attribute:ScriptValue">
<Script>javaScriptFunction();</Script>
</Value>
</Action>
</Triggers>
</Block>
<Dimension>Two_Dimensional</Dimension>
<Script>/**
* The chart script methods provide control on the chart databinding,
generation and rendering.
*
* The methods have been commented in the following code, please uncomment
and implement the
* ones you need. Note that for simplicity the "after" methods have
not be included here.
*
* This script syntax follows JavaScript specifications, the Java classes
that are referred to
* in the comments can be accessed as JavaScript classes.
*
* Script examples are available in the org.eclipse.birt.chart.examples
plugin
*/
function beforeDrawAxisLabel( axis, label, context )
{
importPackage(Packages.java.lang);
importPackage(Packages.java.util);
importPackage(Packages.org.eclipse.birt.chart.model.attribut e);
if (axis.getType() == AxisType.TEXT_LITERAL){
dateTime = new Date();
var mth = dateTime.getMonth() + 1;
var yr = dateTime.getYear() + 1900;
newLabel = mth + '/' + yr;
label.getCaption().setValue(newLabel);
axis.setLabel(label);
}
}
/**
* Called before populating the series dataset using the DataSetProcessor.
*
* @param series
* Series
* @param dataSetProcessor
* DataSetProcessor
* @param context
* IChartScriptContext
*/
//function beforeDataSetFilled( series, dataSetProcessor, context ){}
/**
* Called before generation of chart model to GeneratedChartState.
*
* @param chart
* Chart Model
* @param context
* IChartScriptContext
*/
//function beforeGeneration( chart, context ){}
/**
* Called before the chart is rendered.
*
* @param gcs
* GeneratedChartState
* @param context
* IChartScriptContext
*/
//function beforeRendering( gcs, context ){}
/**
* Called before drawing each block.
*
* @param block
* Block
* @param context
* IChartScriptContext
*/
//function beforeDrawBlock( block, context ){}
/**
* Called before drawing each entry the legend.
*
* @param label
* Label
* @param context
* IChartScriptContext
*/
//function beforeDrawLegendEntry( label, context ){}
/**
* Called before rendering Series.
*
* @param series
* Series
* @param seriesRenderer
* ISeriesRenderer
* @param context
* IChartScriptContext
*/
//function beforeDrawSeries( series, seriesRenderer, context ){}
/**
* Called before rendering the title of a Series.
*
* @param series
* Series
* @param label
* Label
* @param context
* IChartScriptContext
*/
//function beforeDrawSeriesTitle( series, label, context ){}
/**
* Called before drawing each marker line in an Axis.
*
* @param axis
* Axis
* @param markerLine
* MarkerLine
* @param context
* IChartScriptContext
*/
//function beforeDrawMarkerLine( axis, markerLine, context ){}
/**
* Called before drawing each marker range in an Axis.
*
* @param axis
* Axis
* @param markerRange
* MarkerRange
* @param context
* IChartScriptContext
*/
//function beforeDrawMarkerRange( axis, markerRange, context ){}
/**
* Called before drawing each datapoint graphical representation or marker.
*
* @param dph
* DataPointHints
* @param fill
* Fill
* @param context
* IChartScriptContext
*/
//function beforeDrawDataPoint( dph, fill, context ){}
/**
* Called before rendering the label for each datapoint.
*
* @param dph
* DataPointHints
* @param label
* Label
* @param context
* IChartScriptContext
*/
//function beforeDrawDataPointLabel( dph, label, context ){}
/**
* Called before rendering curve fitting.
*
* @param cf
* CurveFitting
* @param context
* IChartScriptContext
*/
//function beforeDrawFittingCurve( cf, context ){}
/**
* Called before rendering each label on a given Axis.
*
* @param axis
* Axis
* @param label
* Label
* @param context
* IChartScriptContext
*/
/**
* Called before rendering the Title of an Axis.
*
* @param axis
* Axis
* @param label
* Title Label
* @param context
* IChartScriptContext
*/
//function beforeDrawAxisTitle( axis, label, context ){}
</Script>
<Units>Points</Units>
<SeriesThickness>40.0</SeriesThickness>
<SampleData>
<BaseSampleData>
<DataSetRepresentation>A, B, C</DataSetRepresentation>
</BaseSampleData>
<OrthogonalSampleData>
<DataSetRepresentation>5,4,12</DataSetRepresentation>
<SeriesDefinitionIndex>0</SeriesDefinitionIndex>
</OrthogonalSampleData>
</SampleData>
<Interactivity/>
<Axes>
<Type>Text</Type>
<Title>
<Caption>
<Value>X-Axis Title</Value>
<Font>
<Size>14.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Title>
<TitlePosition>Below</TitlePosition>
<AssociatedAxes>
<Type>Linear</Type>
<Title>
<Caption>
<Value>Y-Axis Title</Value>
<Font>
<Size>14.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
<Rotation>90.0</Rotation>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<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>
</Title>
<TitlePosition>Left</TitlePosition>
<SeriesDefinitions>
<Query>
<Definition>row["CUSTOMERNAME"]</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>
</SeriesPalette>
<FormatSpecifier xsi:type="attribute:NumberFormatSpecifier">
<Prefix></Prefix>
<Suffix></Suffix>
<FractionDigits>0</FractionDigits>
</FormatSpecifier>
<Series xsi:type="type:BarSeries">
<Visible>true</Visible>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<DataDefinition>
<Definition>row["CUSTOMERTOTAL"]</Definition >
</DataDefinition>
<SeriesIdentifier></SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Outside</LabelPosition>
<Stacked>true</Stacked>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="attribute:TooltipValue">
<Text>row["CUSTOMERTOTAL"].toFixed(2)</Text >
<Delay>200</Delay>
</Value>
</Action>
</Triggers>
<Triggers>
<Condition>onclick</Condition>
<Action>
<Type>URL_Redirect</Type>
<Value xsi:type="attribute:URLValue">
<BaseUrl><structure name="action">
<property name="formatType">html</property>
<property name="linkType">drill-through</property >
<property
name="reportName">CustomerOrders.rptdocument</property >
<expression
name="targetBookmark">row["CUSTOMERNAME"]</expression >
<property name="targetBookmarkType">toc</property >
<property name="targetWindow">_blank</property >
<property
name="targetFileType">report-document</property >
</structure>
</BaseUrl>
<BaseParameterName></BaseParameterName>
<ValueParameterName></ValueParameterName>
<SeriesParameterName></SeriesParameterName>
</Value>
</Action>
</Triggers>
<Translucent>true</Translucent>
<Riser>Rectangle</Riser>
</Series>
<Grouping>
<Enabled>false</Enabled>
<GroupingInterval>2</GroupingInterval>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</SeriesDefinitions>
<Orientation>Vertical</Orientation>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</LineAttributes>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<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>
<LabelPosition>Left</LabelPosition>
<MarkerLines>
<LineAttributes>
<Style>Dotted</Style>
<Thickness>2</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</LineAttributes>
<Value xsi:type="data:NumberDataElement">
<Value>400000.0</Value>
</Value>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<LabelAnchor>North_East</LabelAnchor>
<Triggers>
<Condition>onmouseover</Condition>
<Action>
<Type>Show_Tooltip</Type>
<Value xsi:type="
|
|
|
| Re: help me [message #184242 is a reply to message #184227] |
Fri, 11 August 2006 11:15 |
| Eclipse User |
|
|
|
Take a look at the attached image.
Put the script in the script box.
Jason
"Karthikeyan" <karurkarthi@yahoo.co.in> wrote in message
news:ebh8lr$ff2$1@utils.eclipse.org...
> Thanks for your valuable reply.
>
>
>
> I need one more help. Look at chart area interactivity in onclick event; I
> need to call java script function. But I don't know where to write the
> java
> script function.
>
>
>
> Awaiting for your immediate response
>
>
>
> Thanks
>
> Karthikeyan
>
>
>
> Modified report
>
>
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <!-- Written by Eclipse BIRT 2.0 -->
>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2"
> id="1">
>
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.1.0.N20060628-1351 Build <20060628-1537></property>
>
> <property name="units">in</property>
>
> <property name="comments">Copyright (c) 2006 <<Your Company Name
> here>></property>
>
> <data-sources>
>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="4">
>
> <text-property name="displayName">Data Source</text-property>
>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
>
> <property name="odaUser">ClassicModels</property>
>
> <encrypted-property name="odaPassword"></encrypted-property>
>
> </oda-data-source>
>
> </data-sources>
>
> <data-sets>
>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="5">
>
> <list-property name="resultSet">
>
> <structure>
>
> <property name="position">1</property>
>
> <property name="name">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="dataType">string</property>
>
> <property name="nativeDataType">12</property>
>
> </structure>
>
> <structure>
>
> <property name="position">3</property>
>
> <property name="name">CUSTOMERNUMBER</property>
>
> <property name="dataType">integer</property>
>
> <property name="nativeDataType">4</property>
>
> </structure>
>
> <structure>
>
> <property name="position">4</property>
>
> <property name="name">CUSTOMERTOTAL</property>
>
> <property name="dataType">float</property>
>
> <property name="nativeDataType">8</property>
>
> </structure>
>
> </list-property>
>
> <list-property name="resultSetHints">
>
> <structure>
>
> <property name="position">3</property>
>
> <property name="name">CUSTOMERNUMBER_3</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">CUSTOMERNUMBER_3</property>
>
> <property name="dataType">integer</property>
>
> </structure>
>
> <structure>
>
> <property name="position">4</property>
>
> <property name="name">CUSTOMERTOTAL</property>
>
> <property name="dataType">float</property>
>
> </structure>
>
> </list-property>
>
> </structure>
>
> <property name="dataSource">Data Source</property>
>
> <property name="queryText">select
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
>
> CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
>
> sum(ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH) as
> CUSTOMERTOTAL
>
>
>
> from CUSTOMERS, ORDERS, ORDERDETAILS
>
>
>
> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
>
> ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER group by
>
> CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER order by
>
> CUSTOMERTOTAL</property>
>
> </oda-data-set>
>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="aggrQuery" id="8">
>
> <list-property name="resultSet">
>
> <structure>
>
> <property name="position">1</property>
>
> <property name="name">CREDITLIMIT</property>
>
> <property name="dataType">float</property>
>
> <property name="nativeDataType">8</property>
>
> </structure>
>
> <structure>
>
> <property name="position">2</property>
>
> <property name="name">CUSTOMERNUMBER</property>
>
> <property name="dataType">integer</property>
>
> <property name="nativeDataType">4</property>
>
> </structure>
>
> <structure>
>
> <property name="position">3</property>
>
> <property name="name">CUSTOMERNAME</property>
>
> <property name="dataType">string</property>
>
> <property name="nativeDataType">12</property>
>
> </structure>
>
> <structure>
>
> <property name="position">4</property>
>
> <property name="name">CUSTOMERNUMBER</property>
>
> <property name="dataType">integer</property>
>
> <property name="nativeDataType">4</property>
>
> </structure>
>
> <structure>
>
> <property name="position">5</property>
>
> <property name="name">CUSTOMERTOTAL</property>
>
> <property name="dataType">float</property>
>
> <property name="nativeDataType">8</property>
>
> </structure>
>
> </list-property>
>
> <list-property name="resultSetHints">
>
> <structure>
>
> <property name="position">4</property>
>
> <property name="name">CUSTOMERNUMBER_4</property>
>
> </structure>
>
> </list-property>
>
> <structure name="cachedMetaData">
>
> <list-property name="resultSet">
>
> <structure>
>
> <property name="position">1</property>
>
> <property name="name">CREDITLIMIT</property>
>
> <property name="dataType">float</property>
>
> </structure>
>
> <structure>
>
> <property name="position">2</property>
>
> <property name="name">CUSTOMERNUMBER</property>
>
> <property name="dataType">integer</property>
>
> </structure>
>
> <structure>
>
> <property name="position">3</property>
>
> <property name="name">CUSTOMERNAME</property>
>
> <property name="dataType">string</property>
>
> </structure>
>
> <structure>
>
> <property name="position">4</property>
>
> <property name="name">CUSTOMERNUMBER_4</property>
>
> <property name="dataType">integer</property>
>
> </structure>
>
> <structure>
>
> <property name="position">5</property>
>
> <property name="name">CUSTOMERTOTAL</property>
>
> <property name="dataType">float</property>
>
> </structure>
>
> </list-property>
>
> </structure>
>
> <property name="dataSource">Data Source</property>
>
> <property name="queryText">select
> CLASSICMODELS.CUSTOMERS.CREDITLIMIT,
>
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, CUSTOMERS.CUSTOMERNAME,
>
> CUSTOMERS.CUSTOMERNUMBER, sum(ORDERDETAILS.QUANTITYORDERED *
>
> ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
>
>
>
> from CUSTOMERS, ORDERS, ORDERDETAILS
>
>
>
> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
>
> ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
>
>
>
> group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
>
> CLASSICMODELS.CUSTOMERS.CREDITLIMIT
>
>
>
> order by CUSTOMERTOTAL</property>
>
> </oda-data-set>
>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="salesbyproductline" id="13">
>
> <list-property name="resultSet">
>
> <structure>
>
> <property name="position">1</property>
>
> <property name="name">PRODUCTLINE</property>
>
> <property name="dataType">string</property>
>
> <property name="nativeDataType">12</property>
>
> </structure>
>
> <structure>
>
> <property name="position">2</property>
>
> <property name="name">TOTALREVENUE</property>
>
> <property name="dataType">float</property>
>
> <property name="nativeDataType">8</property>
>
> </structure>
>
> </list-property>
>
> <structure name="cachedMetaData">
>
> <list-property name="resultSet">
>
> <structure>
>
> <property name="position">1</property>
>
> <property name="name">PRODUCTLINE</property>
>
> <property name="dataType">string</property>
>
> </structure>
>
> <structure>
>
> <property name="position">2</property>
>
> <property name="name">TOTALREVENUE</property>
>
> <property name="dataType">float</property>
>
> </structure>
>
> </list-property>
>
> </structure>
>
> <property name="dataSource">Data Source</property>
>
> <property name="queryText">SELECT PRODUCTLINE,
>
>
>
> SUM( PRICEEACH*QUANTITYORDERED ) AS "TOTALREVENUE"
>
>
>
> FROM CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.PRODUCTS
>
>
>
> WHERE CLASSICMODELS.ORDERDETAILS.PRODUCTCODE =
>
> CLASSICMODELS.PRODUCTS.PRODUCTCODE
>
>
>
> GROUP BY CLASSICMODELS.PRODUCTS.PRODUCTLINE</property>
>
> </oda-data-set>
>
> </data-sets>
>
> <page-setup>
>
> <simple-master-page name="Simple MasterPage" id="2">
>
> <page-footer>
>
> <text id="3">
>
> <property name="contentType">html</property>
>
> <text-property name="content"><![CDATA[<value-of>new
> Date()</value-of>]]></text-property>
>
> </text>
>
> </page-footer>
>
> </simple-master-page>
>
> </page-setup>
>
> <body>
>
> <extended-item extensionName="Chart" id="6">
>
> <property name="height">3.947in</property>
>
> <property name="width">6.26in</property>
>
> <property name="dataSet">Data Set</property>
>
> <list-property name="boundDataColumns">
>
> <structure>
>
> <property name="name">CUSTOMERNAME</property>
>
> <expression
> name="expression">dataSetRow["CUSTOMERNAME"]</expression >
>
> <property name="dataType">string</property>
>
> </structure>
>
> <structure>
>
> <property name="name">CUSTOMERNUMBER</property>
>
> <expression
> name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
>
> <property name="dataType">integer</property>
>
> </structure>
>
> <structure>
>
> <property name="name">CUSTOMERTOTAL</property>
>
> <expression
> name="expression">dataSetRow["CUSTOMERTOTAL"]</expression >
>
> <property name="dataType">float</property>
>
> </structure>
>
> </list-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>Side-by-side</SubType>
>
> <Description>
>
> <Value></Value>
>
> <Font>
>
> <Alignment/>
>
> </Font>
>
> </Description>
>
> <Block>
>
> <Children xsi:type="layout:TitleBlock">
>
> <Bounds>
>
> <Left>0.0</Left>
>
> <Top>0.0</Top>
>
> <Width>0.0</Width>
>
> <Height>0.0</Height>
>
> </Bounds>
>
> <Insets>
>
> <Top>3.0</Top>
>
> <Left>3.0</Left>
>
> <Bottom>3.0</Bottom>
>
> <Right>3.0</Right>
>
> </Insets>
>
> <Row>-1</Row>
>
> <Column>-1</Column>
>
> <Rowspan>-1</Rowspan>
>
> <Columnspan>-1</Columnspan>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> <Visible>false</Visible>
>
> </Outline>
>
> <Visible>true</Visible>
>
> <Triggers>
>
> <Condition>onmouseover</Condition>
>
> <Action>
>
> <Type>Show_Tooltip</Type>
>
> <Value xsi:type="attribute:TooltipValue">
>
> <Text>Chart Title</Text>
>
> <Delay>200</Delay>
>
> </Value>
>
> </Action>
>
> </Triggers>
>
> <Label>
>
> <Caption>
>
> <Value>Top Customers Link to Orders RptDocument</Value>
>
> <Font>
>
> <Size>16.0</Size>
>
> <Bold>true</Bold>
>
> <Alignment>
>
> <horizontalAlignment>Center</horizontalAlignment>
>
> <verticalAlignment>Center</verticalAlignment>
>
> </Alignment>
>
> </Font>
>
> </Caption>
>
> <Background xsi:type="attribute:ColorDefinition">
>
> <Transparency>0</Transparency>
>
> <Red>255</Red>
>
> <Green>255</Green>
>
> <Blue>255</Blue>
>
> </Background>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> </Outline>
>
> <Insets>
>
> <Top>0.0</Top>
>
> <Left>2.0</Left>
>
> <Bottom>0.0</Bottom>
>
> <Right>3.0</Right>
>
> </Insets>
>
> <Visible>true</Visible>
>
> </Label>
>
> </Children>
>
> <Children xsi:type="layout:Plot">
>
> <Bounds>
>
> <Left>0.0</Left>
>
> <Top>0.0</Top>
>
> <Width>0.0</Width>
>
> <Height>0.0</Height>
>
> </Bounds>
>
> <Insets>
>
> <Top>3.0</Top>
>
> <Left>3.0</Left>
>
> <Bottom>3.0</Bottom>
>
> <Right>3.0</Right>
>
> </Insets>
>
> <Row>-1</Row>
>
> <Column>-1</Column>
>
> <Rowspan>-1</Rowspan>
>
> <Columnspan>-1</Columnspan>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> <Visible>false</Visible>
>
> </Outline>
>
> <Visible>true</Visible>
>
> <HorizontalSpacing>5</HorizontalSpacing>
>
> <VerticalSpacing>5</VerticalSpacing>
>
> <ClientArea>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>0</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> <Visible>false</Visible>
>
> </Outline>
>
> <Insets>
>
> <Top>0.0</Top>
>
> <Left>0.0</Left>
>
> <Bottom>0.0</Bottom>
>
> <Right>0.0</Right>
>
> </Insets>
>
> </ClientArea>
>
> </Children>
>
> <Children xsi:type="layout:Legend">
>
> <Bounds>
>
> <Left>0.0</Left>
>
> <Top>0.0</Top>
>
> <Width>0.0</Width>
>
> <Height>0.0</Height>
>
> </Bounds>
>
> <Insets>
>
> <Top>3.0</Top>
>
> <Left>3.0</Left>
>
> <Bottom>3.0</Bottom>
>
> <Right>3.0</Right>
>
> </Insets>
>
> <Row>-1</Row>
>
> <Column>-1</Column>
>
> <Rowspan>-1</Rowspan>
>
> <Columnspan>-1</Columnspan>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> <Visible>false</Visible>
>
> </Outline>
>
> <Visible>true</Visible>
>
> <Triggers>
>
> <Condition>onmouseover</Condition>
>
> <Action>
>
> <Type>Show_Tooltip</Type>
>
> <Value xsi:type="attribute:TooltipValue">
>
> <Text>Legend</Text>
>
> <Delay>200</Delay>
>
> </Value>
>
> </Action>
>
> </Triggers>
>
> <Triggers>
>
> <Condition>onclick</Condition>
>
> <Action>
>
> <Type>Toggle_Visibility</Type>
>
> <Value xsi:type="attribute:SeriesValue">
>
> <Name></Name>
>
> </Value>
>
> </Action>
>
> </Triggers>
>
> <ClientArea>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>0</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> <Visible>false</Visible>
>
> </Outline>
>
> <Insets>
>
> <Top>2.0</Top>
>
> <Left>2.0</Left>
>
> <Bottom>2.0</Bottom>
>
> <Right>2.0</Right>
>
> </Insets>
>
> </ClientArea>
>
> <Text>
>
> <Value></Value>
>
> <Font>
>
> <Alignment/>
>
> </Font>
>
> </Text>
>
> <Orientation>Vertical</Orientation>
>
> <Direction>Top_Bottom</Direction>
>
> <Separator>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> <Visible>true</Visible>
>
> </Separator>
>
> <Position>Right</Position>
>
> <ItemType>Series</ItemType>
>
> <Title>
>
> <Caption>
>
> <Value></Value>
>
> <Font>
>
> <Alignment/>
>
> </Font>
>
> </Caption>
>
> <Background xsi:type="attribute:ColorDefinition">
>
> <Transparency>0</Transparency>
>
> <Red>255</Red>
>
> <Green>255</Green>
>
> <Blue>255</Blue>
>
> </Background>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> <Visible>false</Visible>
>
> </Outline>
>
> <Insets>
>
> <Top>0.0</Top>
>
> <Left>2.0</Left>
>
> <Bottom>0.0</Bottom>
>
> <Right>3.0</Right>
>
> </Insets>
>
> <Visible>false</Visible>
>
> </Title>
>
> <TitlePosition>Above</TitlePosition>
>
> </Children>
>
> <Bounds>
>
> <Left>0.0</Left>
>
> <Top>0.0</Top>
>
> <Width>450.0</Width>
>
> <Height>283.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>false</Visible>
>
> </Outline>
>
> <Background xsi:type="attribute:ColorDefinition">
>
> <Transparency>255</Transparency>
>
> <Red>255</Red>
>
> <Green>255</Green>
>
> <Blue>255</Blue>
>
> </Background>
>
> <Visible>true</Visible>
>
> <Triggers>
>
> <Condition>onmouseover</Condition>
>
> <Action>
>
> <Type>Show_Tooltip</Type>
>
> <Value xsi:type="attribute:TooltipValue">
>
> <Text>Chart Area</Text>
>
> <Delay>200</Delay>
>
> </Value>
>
> </Action>
>
> </Triggers>
>
> <Triggers>
>
> <Condition>onclick</Condition>
>
> <Action>
>
> <Type>Invoke_Script</Type>
>
> <Value xsi:type="attribute:ScriptValue">
>
> <Script>javaScriptFunction();</Script>
>
> </Value>
>
> </Action>
>
> </Triggers>
>
> </Block>
>
> <Dimension>Two_Dimensional</Dimension>
>
> <Script>/**
>
>
>
> * The chart script methods provide control on the chart databinding,
>
> generation and rendering.
>
>
>
> *
>
>
>
> * The methods have been commented in the following code, please uncomment
>
> and implement the
>
>
>
> * ones you need. Note that for simplicity the "after" methods
> have
>
> not be included here.
>
>
>
> *
>
>
>
> * This script syntax follows JavaScript specifications, the Java classes
>
> that are referred to
>
>
>
> * in the comments can be accessed as JavaScript classes.
>
>
>
> *
>
>
>
> * Script examples are available in the org.eclipse.birt.chart.examples
>
> plugin
>
>
>
> */
>
>
>
> function beforeDrawAxisLabel( axis, label, context )
>
>
>
> {
>
>
>
>
>
> importPackage(Packages.java.lang);
>
>
>
> importPackage(Packages.java.util);
>
>
>
> importPackage(Packages.org.eclipse.birt.chart.model.attribut e);
>
>
>
>
>
> if (axis.getType() == AxisType.TEXT_LITERAL){
>
>
>
> dateTime = new Date();
>
>
>
> var mth = dateTime.getMonth() + 1;
>
>
>
> var yr = dateTime.getYear() + 1900;
>
>
>
> newLabel = mth + '/' + yr;
>
>
>
> label.getCaption().setValue(newLabel);
>
>
>
> axis.setLabel(label);
>
>
>
> }
>
>
>
>
>
> }
>
>
>
>
>
> /**
>
>
>
> * Called before populating the series dataset using the DataSetProcessor.
>
>
>
> *
>
>
>
> * @param series
>
>
>
> * Series
>
>
>
> * @param dataSetProcessor
>
>
>
> * DataSetProcessor
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDataSetFilled( series, dataSetProcessor, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before generation of chart model to GeneratedChartState.
>
>
>
> *
>
>
>
> * @param chart
>
>
>
> * Chart Model
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeGeneration( chart, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before the chart is rendered.
>
>
>
> *
>
>
>
> * @param gcs
>
>
>
> * GeneratedChartState
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeRendering( gcs, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before drawing each block.
>
>
>
> *
>
>
>
> * @param block
>
>
>
> * Block
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawBlock( block, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before drawing each entry the legend.
>
>
>
> *
>
>
>
> * @param label
>
>
>
> * Label
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawLegendEntry( label, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before rendering Series.
>
>
>
> *
>
>
>
> * @param series
>
>
>
> * Series
>
>
>
> * @param seriesRenderer
>
>
>
> * ISeriesRenderer
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawSeries( series, seriesRenderer, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before rendering the title of a Series.
>
>
>
> *
>
>
>
> * @param series
>
>
>
> * Series
>
>
>
> * @param label
>
>
>
> * Label
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawSeriesTitle( series, label, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before drawing each marker line in an Axis.
>
>
>
> *
>
>
>
> * @param axis
>
>
>
> * Axis
>
>
>
> * @param markerLine
>
>
>
> * MarkerLine
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawMarkerLine( axis, markerLine, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before drawing each marker range in an Axis.
>
>
>
> *
>
>
>
> * @param axis
>
>
>
> * Axis
>
>
>
> * @param markerRange
>
>
>
> * MarkerRange
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawMarkerRange( axis, markerRange, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before drawing each datapoint graphical representation or marker.
>
>
>
> *
>
>
>
> * @param dph
>
>
>
> * DataPointHints
>
>
>
> * @param fill
>
>
>
> * Fill
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawDataPoint( dph, fill, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before rendering the label for each datapoint.
>
>
>
> *
>
>
>
> * @param dph
>
>
>
>
>
> * DataPointHints
>
>
>
> * @param label
>
>
>
> * Label
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawDataPointLabel( dph, label, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before rendering curve fitting.
>
>
>
> *
>
>
>
> * @param cf
>
>
>
> * CurveFitting
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawFittingCurve( cf, context ){}
>
>
>
>
>
> /**
>
>
>
> * Called before rendering each label on a given Axis.
>
>
>
> *
>
>
>
> * @param axis
>
>
>
> * Axis
>
>
>
> * @param label
>
>
>
> * Label
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> /**
>
>
>
> * Called before rendering the Title of an Axis.
>
>
>
> *
>
>
>
> * @param axis
>
>
>
> * Axis
>
>
>
> * @param label
>
>
>
> * Title Label
>
>
>
> * @param context
>
>
>
> * IChartScriptContext
>
>
>
> */
>
>
>
> //function beforeDrawAxisTitle( axis, label, context ){}
>
>
>
> </Script>
>
> <Units>Points</Units>
>
> <SeriesThickness>40.0</SeriesThickness>
>
> <SampleData>
>
> <BaseSampleData>
>
> <DataSetRepresentation>A, B, C</DataSetRepresentation>
>
> </BaseSampleData>
>
> <OrthogonalSampleData>
>
> <DataSetRepresentation>5,4,12</DataSetRepresentation>
>
> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>
> </OrthogonalSampleData>
>
> </SampleData>
>
> <Interactivity/>
>
> <Axes>
>
> <Type>Text</Type>
>
> <Title>
>
> <Caption>
>
> <Value>X-Axis Title</Value>
>
> <Font>
>
> <Size>14.0</Size>
>
> <Bold>true</Bold>
>
> <Alignment>
>
> <horizontalAlignment>Center</horizontalAlignment>
>
> <verticalAlignment>Center</verticalAlignment>
>
> </Alignment>
>
> </Font>
>
> </Caption>
>
> <Background xsi:type="attribute:ColorDefinition">
>
> <Transparency>0</Transparency>
>
> <Red>255</Red>
>
> <Green>255</Green>
>
> <Blue>255</Blue>
>
> </Background>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> </Outline>
>
> <Insets>
>
> <Top>0.0</Top>
>
> <Left>2.0</Left>
>
> <Bottom>0.0</Bottom>
>
> <Right>3.0</Right>
>
> </Insets>
>
> <Visible>true</Visible>
>
> </Title>
>
> <TitlePosition>Below</TitlePosition>
>
> <AssociatedAxes>
>
> <Type>Linear</Type>
>
> <Title>
>
> <Caption>
>
> <Value>Y-Axis Title</Value>
>
> <Font>
>
> <Size>14.0</Size>
>
> <Bold>true</Bold>
>
> <Alignment>
>
> <horizontalAlignment>Center</horizontalAlignment>
>
> <verticalAlignment>Center</verticalAlignment>
>
> </Alignment>
>
> <Rotation>90.0</Rotation>
>
> </Font>
>
> </Caption>
>
> <Background xsi:type="attribute:ColorDefinition">
>
> <Transparency>0</Transparency>
>
> <Red>255</Red>
>
> <Green>255</Green>
>
> <Blue>255</Blue>
>
> </Background>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
> </Color>
>
> <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>
>
> </Title>
>
> <TitlePosition>Left</TitlePosition>
>
> <SeriesDefinitions>
>
> <Query>
>
> <Definition>row["CUSTOMERNAME"]</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>
>
> </SeriesPalette>
>
> <FormatSpecifier xsi:type="attribute:NumberFormatSpecifier">
>
> <Prefix></Prefix>
>
> <Suffix></Suffix>
>
> <FractionDigits>0</FractionDigits>
>
> </FormatSpecifier>
>
> <Series xsi:type="type:BarSeries">
>
> <Visible>true</Visible>
>
> <Label>
>
> <Caption>
>
> <Value></Value>
>
> <Font>
>
> <Alignment/>
>
> </Font>
>
> </Caption>
>
> <Background xsi:type="attribute:ColorDefinition">
>
> <Transparency>0</Transparency>
>
> <Red>255</Red>
>
> <Green>255</Green>
>
> <Blue>255</Blue>
>
> </Background>
>
> <Outline>
>
> <Style>Solid</Style>
>
> <Thickness>1</Thickness>
>
> <Color>
>
> <Transparency>255</Transparency>
>
> <Red>0</Red>
>
> <Green>0</Green>
>
> <Blue>0</Blue>
>
Attachment: script.bmp
(Size: 550.18KB, Downloaded 89 times)
|
|
|
| Re: help me [message #184416 is a reply to message #184242] |
Sat, 12 August 2006 00:22 |
| Eclipse User |
|
|
|
Originally posted by: karurkarthi.yahoo.co.in
I want to zoom the chart and then want to pad the chart; is this possible to
do?
Is it possible to set the chart size dynamic and change the location at run
time.
Otherwise give me some solution to do.....
Thanks
Karthikeyan
"Jason Weathersby" <jweathersby@actuate.com> wrote in message
news:ebi6u7$2ad$1@utils.eclipse.org...
> Take a look at the attached image.
> Put the script in the script box.
>
> Jason
>
>
> "Karthikeyan" <karurkarthi@yahoo.co.in> wrote in message
> news:ebh8lr$ff2$1@utils.eclipse.org...
>> Thanks for your valuable reply.
>>
>>
>>
>> I need one more help. Look at chart area interactivity in onclick event;
>> I
>> need to call java script function. But I don't know where to write the
>> java
>> script function.
>>
>>
>>
>> Awaiting for your immediate response
>>
>>
>>
>> Thanks
>>
>> Karthikeyan
>>
>>
>>
>> Modified report
>>
>>
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>>
>> <!-- Written by Eclipse BIRT 2.0 -->
>>
>> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2"
>> id="1">
>>
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.1.0.N20060628-1351 Build <20060628-1537></property>
>>
>> <property name="units">in</property>
>>
>> <property name="comments">Copyright (c) 2006 <<Your Company Name
>> here>></property>
>>
>> <data-sources>
>>
>> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc"
>> name="Data Source" id="4">
>>
>> <text-property name="displayName">Data Source</text-property>
>>
>> <property
>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>
>> <property name="odaURL">jdbc:classicmodels:sampledb</property>
>>
>> <property name="odaUser">ClassicModels</property>
>>
>> <encrypted-property name="odaPassword"></encrypted-property>
>>
>> </oda-data-source>
>>
>> </data-sources>
>>
>> <data-sets>
>>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Data Set" id="5">
>>
>> <list-property name="resultSet">
>>
>> <structure>
>>
>> <property name="position">1</property>
>>
>> <property name="name">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="dataType">string</property>
>>
>> <property name="nativeDataType">12</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">3</property>
>>
>> <property name="name">CUSTOMERNUMBER</property>
>>
>> <property name="dataType">integer</property>
>>
>> <property name="nativeDataType">4</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">4</property>
>>
>> <property name="name">CUSTOMERTOTAL</property>
>>
>> <property name="dataType">float</property>
>>
>> <property name="nativeDataType">8</property>
>>
>> </structure>
>>
>> </list-property>
>>
>> <list-property name="resultSetHints">
>>
>> <structure>
>>
>> <property name="position">3</property>
>>
>> <property name="name">CUSTOMERNUMBER_3</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">CUSTOMERNUMBER_3</property>
>>
>> <property name="dataType">integer</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">4</property>
>>
>> <property name="name">CUSTOMERTOTAL</property>
>>
>> <property name="dataType">float</property>
>>
>> </structure>
>>
>> </list-property>
>>
>> </structure>
>>
>> <property name="dataSource">Data Source</property>
>>
>> <property name="queryText">select
>> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
>>
>> CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
>>
>> sum(ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH) as
>> CUSTOMERTOTAL
>>
>>
>>
>> from CUSTOMERS, ORDERS, ORDERDETAILS
>>
>>
>>
>> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
>>
>> ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER group by
>>
>> CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER order by
>>
>> CUSTOMERTOTAL</property>
>>
>> </oda-data-set>
>>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="aggrQuery" id="8">
>>
>> <list-property name="resultSet">
>>
>> <structure>
>>
>> <property name="position">1</property>
>>
>> <property name="name">CREDITLIMIT</property>
>>
>> <property name="dataType">float</property>
>>
>> <property name="nativeDataType">8</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">2</property>
>>
>> <property name="name">CUSTOMERNUMBER</property>
>>
>> <property name="dataType">integer</property>
>>
>> <property name="nativeDataType">4</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">3</property>
>>
>> <property name="name">CUSTOMERNAME</property>
>>
>> <property name="dataType">string</property>
>>
>> <property name="nativeDataType">12</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">4</property>
>>
>> <property name="name">CUSTOMERNUMBER</property>
>>
>> <property name="dataType">integer</property>
>>
>> <property name="nativeDataType">4</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">5</property>
>>
>> <property name="name">CUSTOMERTOTAL</property>
>>
>> <property name="dataType">float</property>
>>
>> <property name="nativeDataType">8</property>
>>
>> </structure>
>>
>> </list-property>
>>
>> <list-property name="resultSetHints">
>>
>> <structure>
>>
>> <property name="position">4</property>
>>
>> <property name="name">CUSTOMERNUMBER_4</property>
>>
>> </structure>
>>
>> </list-property>
>>
>> <structure name="cachedMetaData">
>>
>> <list-property name="resultSet">
>>
>> <structure>
>>
>> <property name="position">1</property>
>>
>> <property name="name">CREDITLIMIT</property>
>>
>> <property name="dataType">float</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">2</property>
>>
>> <property name="name">CUSTOMERNUMBER</property>
>>
>> <property name="dataType">integer</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">3</property>
>>
>> <property name="name">CUSTOMERNAME</property>
>>
>> <property name="dataType">string</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">4</property>
>>
>> <property name="name">CUSTOMERNUMBER_4</property>
>>
>> <property name="dataType">integer</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">5</property>
>>
>> <property name="name">CUSTOMERTOTAL</property>
>>
>> <property name="dataType">float</property>
>>
>> </structure>
>>
>> </list-property>
>>
>> </structure>
>>
>> <property name="dataSource">Data Source</property>
>>
>> <property name="queryText">select
>> CLASSICMODELS.CUSTOMERS.CREDITLIMIT,
>>
>> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, CUSTOMERS.CUSTOMERNAME,
>>
>> CUSTOMERS.CUSTOMERNUMBER, sum(ORDERDETAILS.QUANTITYORDERED *
>>
>> ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
>>
>>
>>
>> from CUSTOMERS, ORDERS, ORDERDETAILS
>>
>>
>>
>> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
>>
>> ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
>>
>>
>>
>> group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
>>
>> CLASSICMODELS.CUSTOMERS.CREDITLIMIT
>>
>>
>>
>> order by CUSTOMERTOTAL</property>
>>
>> </oda-data-set>
>>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="salesbyproductline" id="13">
>>
>> <list-property name="resultSet">
>>
>> <structure>
>>
>> <property name="position">1</property>
>>
>> <property name="name">PRODUCTLINE</property>
>>
>> <property name="dataType">string</property>
>>
>> <property name="nativeDataType">12</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">2</property>
>>
>> <property name="name">TOTALREVENUE</property>
>>
>> <property name="dataType">float</property>
>>
>> <property name="nativeDataType">8</property>
>>
>> </structure>
>>
>> </list-property>
>>
>> <structure name="cachedMetaData">
>>
>> <list-property name="resultSet">
>>
>> <structure>
>>
>> <property name="position">1</property>
>>
>> <property name="name">PRODUCTLINE</property>
>>
>> <property name="dataType">string</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="position">2</property>
>>
>> <property name="name">TOTALREVENUE</property>
>>
>> <property name="dataType">float</property>
>>
>> </structure>
>>
>> </list-property>
>>
>> </structure>
>>
>> <property name="dataSource">Data Source</property>
>>
>> <property name="queryText">SELECT PRODUCTLINE,
>>
>>
>>
>> SUM( PRICEEACH*QUANTITYORDERED ) AS "TOTALREVENUE"
>>
>>
>>
>> FROM CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.PRODUCTS
>>
>>
>>
>> WHERE CLASSICMODELS.ORDERDETAILS.PRODUCTCODE =
>>
>> CLASSICMODELS.PRODUCTS.PRODUCTCODE
>>
>>
>>
>> GROUP BY CLASSICMODELS.PRODUCTS.PRODUCTLINE</property>
>>
>> </oda-data-set>
>>
>> </data-sets>
>>
>> <page-setup>
>>
>> <simple-master-page name="Simple MasterPage" id="2">
>>
>> <page-footer>
>>
>> <text id="3">
>>
>> <property name="contentType">html</property>
>>
>> <text-property name="content"><![CDATA[<value-of>new
>> Date()</value-of>]]></text-property>
>>
>> </text>
>>
>> </page-footer>
>>
>> </simple-master-page>
>>
>> </page-setup>
>>
>> <body>
>>
>> <extended-item extensionName="Chart" id="6">
>>
>> <property name="height">3.947in</property>
>>
>> <property name="width">6.26in</property>
>>
>> <property name="dataSet">Data Set</property>
>>
>> <list-property name="boundDataColumns">
>>
>> <structure>
>>
>> <property name="name">CUSTOMERNAME</property>
>>
>> <expression
>> name="expression">dataSetRow["CUSTOMERNAME"]</expression >
>>
>> <property name="dataType">string</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="name">CUSTOMERNUMBER</property>
>>
>> <expression
>> name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
>>
>> <property name="dataType">integer</property>
>>
>> </structure>
>>
>> <structure>
>>
>> <property name="name">CUSTOMERTOTAL</property>
>>
>> <expression
>> name="expression">dataSetRow["CUSTOMERTOTAL"]</expression >
>>
>> <property name="dataType">float</property>
>>
>> </structure>
>>
>> </list-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>Side-by-side</SubType>
>>
>> <Description>
>>
>> <Value></Value>
>>
>> <Font>
>>
>> <Alignment/>
>>
>> </Font>
>>
>> </Description>
>>
>> <Block>
>>
>> <Children xsi:type="layout:TitleBlock">
>>
>> <Bounds>
>>
>> <Left>0.0</Left>
>>
>> <Top>0.0</Top>
>>
>> <Width>0.0</Width>
>>
>> <Height>0.0</Height>
>>
>> </Bounds>
>>
>> <Insets>
>>
>> <Top>3.0</Top>
>>
>> <Left>3.0</Left>
>>
>> <Bottom>3.0</Bottom>
>>
>> <Right>3.0</Right>
>>
>> </Insets>
>>
>> <Row>-1</Row>
>>
>> <Column>-1</Column>
>>
>> <Rowspan>-1</Rowspan>
>>
>> <Columnspan>-1</Columnspan>
>>
>> <Outline>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>1</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue>
>>
>> </Color>
>>
>> <Visible>false</Visible>
>>
>> </Outline>
>>
>> <Visible>true</Visible>
>>
>> <Triggers>
>>
>> <Condition>onmouseover</Condition>
>>
>> <Action>
>>
>> <Type>Show_Tooltip</Type>
>>
>> <Value xsi:type="attribute:TooltipValue">
>>
>> <Text>Chart Title</Text>
>>
>> <Delay>200</Delay>
>>
>> </Value>
>>
>> </Action>
>>
>> </Triggers>
>>
>> <Label>
>>
>> <Caption>
>>
>> <Value>Top Customers Link to Orders RptDocument</Value>
>>
>> <Font>
>>
>> <Size>16.0</Size>
>>
>> <Bold>true</Bold>
>>
>> <Alignment>
>>
>> <horizontalAlignment>Center</horizontalAlignment>
>>
>> <verticalAlignment>Center</verticalAlignment>
>>
>> </Alignment>
>>
>> </Font>
>>
>> </Caption>
>>
>> <Background xsi:type="attribute:ColorDefinition">
>>
>> <Transparency>0</Transparency>
>>
>> <Red>255</Red>
>>
>> <Green>255</Green>
>>
>> <Blue>255</Blue>
>>
>> </Background>
>>
>> <Outline>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>1</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue>
>>
>> </Color>
>>
>> </Outline>
>>
>> <Insets>
>>
>> <Top>0.0</Top>
>>
>> <Left>2.0</Left>
>>
>> <Bottom>0.0</Bottom>
>>
>> <Right>3.0</Right>
>>
>> </Insets>
>>
>> <Visible>true</Visible>
>>
>> </Label>
>>
>> </Children>
>>
>> <Children xsi:type="layout:Plot">
>>
>> <Bounds>
>>
>> <Left>0.0</Left>
>>
>> <Top>0.0</Top>
>>
>> <Width>0.0</Width>
>>
>> <Height>0.0</Height>
>>
>> </Bounds>
>>
>> <Insets>
>>
>> <Top>3.0</Top>
>>
>> <Left>3.0</Left>
>>
>> <Bottom>3.0</Bottom>
>>
>> <Right>3.0</Right>
>>
>> </Insets>
>>
>> <Row>-1</Row>
>>
>> <Column>-1</Column>
>>
>> <Rowspan>-1</Rowspan>
>>
>> <Columnspan>-1</Columnspan>
>>
>> <Outline>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>1</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue>
>>
>> </Color>
>>
>> <Visible>false</Visible>
>>
>> </Outline>
>>
>> <Visible>true</Visible>
>>
>> <HorizontalSpacing>5</HorizontalSpacing>
>>
>> <VerticalSpacing>5</VerticalSpacing>
>>
>> <ClientArea>
>>
>> <Outline>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>0</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue>
>>
>> </Color>
>>
>> <Visible>false</Visible>
>>
>> </Outline>
>>
>> <Insets>
>>
>> <Top>0.0</Top>
>>
>> <Left>0.0</Left>
>>
>> <Bottom>0.0</Bottom>
>>
>> <Right>0.0</Right>
>>
>> </Insets>
>>
>> </ClientArea>
>>
>> </Children>
>>
>> <Children xsi:type="layout:Legend">
>>
>> <Bounds>
>>
>> <Left>0.0</Left>
>>
>> <Top>0.0</Top>
>>
>> <Width>0.0</Width>
>>
>> <Height>0.0</Height>
>>
>> </Bounds>
>>
>> <Insets>
>>
>> <Top>3.0</Top>
>>
>> <Left>3.0</Left>
>>
>> <Bottom>3.0</Bottom>
>>
>> <Right>3.0</Right>
>>
>> </Insets>
>>
>> <Row>-1</Row>
>>
>> <Column>-1</Column>
>>
>> <Rowspan>-1</Rowspan>
>>
>> <Columnspan>-1</Columnspan>
>>
>> <Outline>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>1</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue>
>>
>> </Color>
>>
>> <Visible>false</Visible>
>>
>> </Outline>
>>
>> <Visible>true</Visible>
>>
>> <Triggers>
>>
>> <Condition>onmouseover</Condition>
>>
>> <Action>
>>
>> <Type>Show_Tooltip</Type>
>>
>> <Value xsi:type="attribute:TooltipValue">
>>
>> <Text>Legend</Text>
>>
>> <Delay>200</Delay>
>>
>> </Value>
>>
>> </Action>
>>
>> </Triggers>
>>
>> <Triggers>
>>
>> <Condition>onclick</Condition>
>>
>> <Action>
>>
>> <Type>Toggle_Visibility</Type>
>>
>> <Value xsi:type="attribute:SeriesValue">
>>
>> <Name></Name>
>>
>> </Value>
>>
>> </Action>
>>
>> </Triggers>
>>
>> <ClientArea>
>>
>> <Outline>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>0</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue>
>>
>> </Color>
>>
>> <Visible>false</Visible>
>>
>> </Outline>
>>
>> <Insets>
>>
>> <Top>2.0</Top>
>>
>> <Left>2.0</Left>
>>
>> <Bottom>2.0</Bottom>
>>
>> <Right>2.0</Right>
>>
>> </Insets>
>>
>> </ClientArea>
>>
>> <Text>
>>
>> <Value></Value>
>>
>> <Font>
>>
>> <Alignment/>
>>
>> </Font>
>>
>> </Text>
>>
>> <Orientation>Vertical</Orientation>
>>
>> <Direction>Top_Bottom</Direction>
>>
>> <Separator>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>1</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue>
>>
>> </Color>
>>
>> <Visible>true</Visible>
>>
>> </Separator>
>>
>> <Position>Right</Position>
>>
>> <ItemType>Series</ItemType>
>>
>> <Title>
>>
>> <Caption>
>>
>> <Value></Value>
>>
>> <Font>
>>
>> <Alignment/>
>>
>> </Font>
>>
>> </Caption>
>>
>> <Background xsi:type="attribute:ColorDefinition">
>>
>> <Transparency>0</Transparency>
>>
>> <Red>255</Red>
>>
>> <Green>255</Green>
>>
>> <Blue>255</Blue>
>>
>> </Background>
>>
>> <Outline>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>1</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue>
>>
>> </Color>
>>
>> <Visible>false</Visible>
>>
>> </Outline>
>>
>> <Insets>
>>
>> <Top>0.0</Top>
>>
>> <Left>2.0</Left>
>>
>> <Bottom>0.0</Bottom>
>>
>> <Right>3.0</Right>
>>
>> </Insets>
>>
>> <Visible>false</Visible>
>>
>> </Title>
>>
>> <TitlePosition>Above</TitlePosition>
>>
>> </Children>
>>
>> <Bounds>
>>
>> <Left>0.0</Left>
>>
>> <Top>0.0</Top>
>>
>> <Width>450.0</Width>
>>
>> <Height>283.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>false</Visible>
>>
>> </Outline>
>>
>> <Background xsi:type="attribute:ColorDefinition">
>>
>> <Transparency>255</Transparency>
>>
>> <Red>255</Red>
>>
>> <Green>255</Green>
>>
>> <Blue>255</Blue>
>>
>> </Background>
>>
>> <Visible>true</Visible>
>>
>> <Triggers>
>>
>> <Condition>onmouseover</Condition>
>>
>> <Action>
>>
>> <Type>Show_Tooltip</Type>
>>
>> <Value xsi:type="attribute:TooltipValue">
>>
>> <Text>Chart Area</Text>
>>
>> <Delay>200</Delay>
>>
>> </Value>
>>
>> </Action>
>>
>> </Triggers>
>>
>> <Triggers>
>>
>> <Condition>onclick</Condition>
>>
>> <Action>
>>
>> <Type>Invoke_Script</Type>
>>
>> <Value xsi:type="attribute:ScriptValue">
>>
>> <Script>javaScriptFunction();</Script>
>>
>> </Value>
>>
>> </Action>
>>
>> </Triggers>
>>
>> </Block>
>>
>> <Dimension>Two_Dimensional</Dimension>
>>
>> <Script>/**
>>
>>
>>
>> * The chart script methods provide control on the chart databinding,
>>
>> generation and rendering.
>>
>>
>>
>> *
>>
>>
>>
>> * The methods have been commented in the following code, please uncomment
>>
>> and implement the
>>
>>
>>
>> * ones you need. Note that for simplicity the "after" methods
>> have
>>
>> not be included here.
>>
>>
>>
>> *
>>
>>
>>
>> * This script syntax follows JavaScript specifications, the Java classes
>>
>> that are referred to
>>
>>
>>
>> * in the comments can be accessed as JavaScript classes.
>>
>>
>>
>> *
>>
>>
>>
>> * Script examples are available in the org.eclipse.birt.chart.examples
>>
>> plugin
>>
>>
>>
>> */
>>
>>
>>
>> function beforeDrawAxisLabel( axis, label, context )
>>
>>
>>
>> {
>>
>>
>>
>>
>>
>> importPackage(Packages.java.lang);
>>
>>
>>
>> importPackage(Packages.java.util);
>>
>>
>>
>> importPackage(Packages.org.eclipse.birt.chart.model.attribut e);
>>
>>
>>
>>
>>
>> if (axis.getType() == AxisType.TEXT_LITERAL){
>>
>>
>>
>> dateTime = new Date();
>>
>>
>>
>> var mth = dateTime.getMonth() + 1;
>>
>>
>>
>> var yr = dateTime.getYear() + 1900;
>>
>>
>>
>> newLabel = mth + '/' + yr;
>>
>>
>>
>> label.getCaption().setValue(newLabel);
>>
>>
>>
>> axis.setLabel(label);
>>
>>
>>
>> }
>>
>>
>>
>>
>>
>> }
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before populating the series dataset using the DataSetProcessor.
>>
>>
>>
>> *
>>
>>
>>
>> * @param series
>>
>>
>>
>> * Series
>>
>>
>>
>> * @param dataSetProcessor
>>
>>
>>
>> * DataSetProcessor
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDataSetFilled( series, dataSetProcessor, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before generation of chart model to GeneratedChartState.
>>
>>
>>
>> *
>>
>>
>>
>> * @param chart
>>
>>
>>
>> * Chart Model
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeGeneration( chart, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before the chart is rendered.
>>
>>
>>
>> *
>>
>>
>>
>> * @param gcs
>>
>>
>>
>> * GeneratedChartState
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeRendering( gcs, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before drawing each block.
>>
>>
>>
>> *
>>
>>
>>
>> * @param block
>>
>>
>>
>> * Block
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawBlock( block, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before drawing each entry the legend.
>>
>>
>>
>> *
>>
>>
>>
>> * @param label
>>
>>
>>
>> * Label
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawLegendEntry( label, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before rendering Series.
>>
>>
>>
>> *
>>
>>
>>
>> * @param series
>>
>>
>>
>> * Series
>>
>>
>>
>> * @param seriesRenderer
>>
>>
>>
>> * ISeriesRenderer
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawSeries( series, seriesRenderer, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before rendering the title of a Series.
>>
>>
>>
>> *
>>
>>
>>
>> * @param series
>>
>>
>>
>> * Series
>>
>>
>>
>> * @param label
>>
>>
>>
>> * Label
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawSeriesTitle( series, label, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before drawing each marker line in an Axis.
>>
>>
>>
>> *
>>
>>
>>
>> * @param axis
>>
>>
>>
>> * Axis
>>
>>
>>
>> * @param markerLine
>>
>>
>>
>> * MarkerLine
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawMarkerLine( axis, markerLine, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before drawing each marker range in an Axis.
>>
>>
>>
>> *
>>
>>
>>
>> * @param axis
>>
>>
>>
>> * Axis
>>
>>
>>
>> * @param markerRange
>>
>>
>>
>> * MarkerRange
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawMarkerRange( axis, markerRange, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before drawing each datapoint graphical representation or
>> marker.
>>
>>
>>
>> *
>>
>>
>>
>> * @param dph
>>
>>
>>
>> * DataPointHints
>>
>>
>>
>> * @param fill
>>
>>
>>
>> * Fill
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawDataPoint( dph, fill, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before rendering the label for each datapoint.
>>
>>
>>
>> *
>>
>>
>>
>> * @param dph
>>
>>
>>
>>
>>
>> * DataPointHints
>>
>>
>>
>> * @param label
>>
>>
>>
>> * Label
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawDataPointLabel( dph, label, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before rendering curve fitting.
>>
>>
>>
>> *
>>
>>
>>
>> * @param cf
>>
>>
>>
>> * CurveFitting
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawFittingCurve( cf, context ){}
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before rendering each label on a given Axis.
>>
>>
>>
>> *
>>
>>
>>
>> * @param axis
>>
>>
>>
>> * Axis
>>
>>
>>
>> * @param label
>>
>>
>>
>> * Label
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> /**
>>
>>
>>
>> * Called before rendering the Title of an Axis.
>>
>>
>>
>> *
>>
>>
>>
>> * @param axis
>>
>>
>>
>> * Axis
>>
>>
>>
>> * @param label
>>
>>
>>
>> * Title Label
>>
>>
>>
>> * @param context
>>
>>
>>
>> * IChartScriptContext
>>
>>
>>
>> */
>>
>>
>>
>> //function beforeDrawAxisTitle( axis, label, context ){}
>>
>>
>>
>> </Script>
>>
>> <Units>Points</Units>
>>
>> <SeriesThickness>40.0</SeriesThickness>
>>
>> <SampleData>
>>
>> <BaseSampleData>
>>
>> <DataSetRepresentation>A, B, C</DataSetRepresentation>
>>
>> </BaseSampleData>
>>
>> <OrthogonalSampleData>
>>
>> <DataSetRepresentation>5,4,12</DataSetRepresentation>
>>
>> <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
>>
>> </OrthogonalSampleData>
>>
>> </SampleData>
>>
>> <Interactivity/>
>>
>> <Axes>
>>
>> <Type>Text</Type>
>>
>> <Title>
>>
>> <Caption>
>>
>> <Value>X-Axis Title</Value>
>>
>> <Font>
>>
>> <Size>14.0</Size>
>>
>> <Bold>true</Bold>
>>
>> <Alignment>
>>
>> <horizontalAlignment>Center</horizontalAlignment>
>>
>> <verticalAlignment>Center</verticalAlignment>
>>
>> </Alignment>
>>
>> </Font>
>>
>> </Caption>
>>
>> <Background xsi:type="attribute:ColorDefinition">
>>
>> <Transparency>0</Transparency>
>>
>> <Red>255</Red>
>>
>> <Green>255</Green>
>>
>> <Blue>255</Blue>
>>
>> </Background>
>>
>> <Outline>
>>
>> <Style>Solid</Style>
>>
>> <Thickness>1</Thickness>
>>
>> <Color>
>>
>> <Transparency>255</Transparency>
>>
>> <Red>0</Red>
>>
>> <Green>0</Green>
>>
>> <Blue>0</Blue
|
|
|
| Re: help me [message #184853 is a reply to message #184416] |
Tue, 15 August 2006 01:04 |
| Eclipse User |
|
|
|
You can do zoom in any chart thats output is svg and you have an svg viewer
installed.
If you want to do this in preview make sure you check the following
preference:
Window->preferences->Report Design->Preview->Enable SVG chart.
I am pretty sure in the beforeGeneration script that the size of a chart can
be changed.
I will check with the developers to try and get a code sample.
Jason
"Karthikeyan" <karurkarthi@yahoo.co.in> wrote in message
news:ebjl3a$oop$1@utils.eclipse.org...
>I want to zoom the chart and then want to pad the chart; is this possible
>to do?
>
>
>
> Is it possible to set the chart size dynamic and change the location at
> run time.
>
>
>
> Otherwise give me some solution to do.....
>
>
>
> Thanks
>
> Karthikeyan
>
>
>
> "Jason Weathersby" <jweathersby@actuate.com> wrote in message
> news:ebi6u7$2ad$1@utils.eclipse.org...
>> Take a look at the attached image.
>> Put the script in the script box.
>>
>> Jason
>>
>>
>> "Karthikeyan" <karurkarthi@yahoo.co.in> wrote in message
>> news:ebh8lr$ff2$1@utils.eclipse.org...
>>> Thanks for your valuable reply.
>>>
>>>
>>>
>>> I need one more help. Look at chart area interactivity in onclick event;
>>> I
>>> need to call java script function. But I don't know where to write the
>>> java
>>> script function.
>>>
>>>
>>>
>>> Awaiting for your immediate response
>>>
>>>
>>>
>>> Thanks
>>>
>>> Karthikeyan
>>>
>>>
>>>
>>> Modified report
>>>
>>>
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>>
>>> <!-- Written by Eclipse BIRT 2.0 -->
>>>
>>> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2"
>>> id="1">
>>>
>>> <property name="createdBy">Eclipse BIRT Designer Version
>>> 2.1.0.N20060628-1351 Build <20060628-1537></property>
>>>
>>> <property name="units">in</property>
>>>
>>> <property name="comments">Copyright (c) 2006 <<Your Company
>>> Name
>>> here>></property>
>>>
>>> <data-sources>
>>>
>>> <oda-data-source
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc"
>>> name="Data Source" id="4">
>>>
>>> <text-property name="displayName">Data Source</text-property>
>>>
>>> <property
>>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>>
>>> <property
>>> name="odaURL">jdbc:classicmodels:sampledb</property>
>>>
>>> <property name="odaUser">ClassicModels</property>
>>>
>>> <encrypted-property name="odaPassword"></encrypted-property>
>>>
>>> </oda-data-source>
>>>
>>> </data-sources>
>>>
>>> <data-sets>
>>>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="Data Set" id="5">
>>>
>>> <list-property name="resultSet">
>>>
>>> <structure>
>>>
>>> <property name="position">1</property>
>>>
>>> <property name="name">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="dataType">string</property>
>>>
>>> <property name="nativeDataType">12</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">3</property>
>>>
>>> <property name="name">CUSTOMERNUMBER</property>
>>>
>>> <property name="dataType">integer</property>
>>>
>>> <property name="nativeDataType">4</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">4</property>
>>>
>>> <property name="name">CUSTOMERTOTAL</property>
>>>
>>> <property name="dataType">float</property>
>>>
>>> <property name="nativeDataType">8</property>
>>>
>>> </structure>
>>>
>>> </list-property>
>>>
>>> <list-property name="resultSetHints">
>>>
>>> <structure>
>>>
>>> <property name="position">3</property>
>>>
>>> <property name="name">CUSTOMERNUMBER_3</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">CUSTOMERNUMBER_3</property>
>>>
>>> <property name="dataType">integer</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">4</property>
>>>
>>> <property name="name">CUSTOMERTOTAL</property>
>>>
>>> <property name="dataType">float</property>
>>>
>>> </structure>
>>>
>>> </list-property>
>>>
>>> </structure>
>>>
>>> <property name="dataSource">Data Source</property>
>>>
>>> <property name="queryText">select
>>> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
>>>
>>> CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
>>>
>>> sum(ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH) as
>>> CUSTOMERTOTAL
>>>
>>>
>>>
>>> from CUSTOMERS, ORDERS, ORDERDETAILS
>>>
>>>
>>>
>>> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
>>>
>>> ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER group by
>>>
>>> CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER order by
>>>
>>> CUSTOMERTOTAL</property>
>>>
>>> </oda-data-set>
>>>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="aggrQuery" id="8">
>>>
>>> <list-property name="resultSet">
>>>
>>> <structure>
>>>
>>> <property name="position">1</property>
>>>
>>> <property name="name">CREDITLIMIT</property>
>>>
>>> <property name="dataType">float</property>
>>>
>>> <property name="nativeDataType">8</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">2</property>
>>>
>>> <property name="name">CUSTOMERNUMBER</property>
>>>
>>> <property name="dataType">integer</property>
>>>
>>> <property name="nativeDataType">4</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">3</property>
>>>
>>> <property name="name">CUSTOMERNAME</property>
>>>
>>> <property name="dataType">string</property>
>>>
>>> <property name="nativeDataType">12</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">4</property>
>>>
>>> <property name="name">CUSTOMERNUMBER</property>
>>>
>>> <property name="dataType">integer</property>
>>>
>>> <property name="nativeDataType">4</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">5</property>
>>>
>>> <property name="name">CUSTOMERTOTAL</property>
>>>
>>> <property name="dataType">float</property>
>>>
>>> <property name="nativeDataType">8</property>
>>>
>>> </structure>
>>>
>>> </list-property>
>>>
>>> <list-property name="resultSetHints">
>>>
>>> <structure>
>>>
>>> <property name="position">4</property>
>>>
>>> <property name="name">CUSTOMERNUMBER_4</property>
>>>
>>> </structure>
>>>
>>> </list-property>
>>>
>>> <structure name="cachedMetaData">
>>>
>>> <list-property name="resultSet">
>>>
>>> <structure>
>>>
>>> <property name="position">1</property>
>>>
>>> <property name="name">CREDITLIMIT</property>
>>>
>>> <property name="dataType">float</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">2</property>
>>>
>>> <property name="name">CUSTOMERNUMBER</property>
>>>
>>> <property name="dataType">integer</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">3</property>
>>>
>>> <property name="name">CUSTOMERNAME</property>
>>>
>>> <property name="dataType">string</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">4</property>
>>>
>>> <property name="name">CUSTOMERNUMBER_4</property>
>>>
>>> <property name="dataType">integer</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">5</property>
>>>
>>> <property name="name">CUSTOMERTOTAL</property>
>>>
>>> <property name="dataType">float</property>
>>>
>>> </structure>
>>>
>>> </list-property>
>>>
>>> </structure>
>>>
>>> <property name="dataSource">Data Source</property>
>>>
>>> <property name="queryText">select
>>> CLASSICMODELS.CUSTOMERS.CREDITLIMIT,
>>>
>>> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, CUSTOMERS.CUSTOMERNAME,
>>>
>>> CUSTOMERS.CUSTOMERNUMBER, sum(ORDERDETAILS.QUANTITYORDERED *
>>>
>>> ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL
>>>
>>>
>>>
>>> from CUSTOMERS, ORDERS, ORDERDETAILS
>>>
>>>
>>>
>>> where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and
>>>
>>> ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
>>>
>>>
>>>
>>> group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,
>>>
>>> CLASSICMODELS.CUSTOMERS.CREDITLIMIT
>>>
>>>
>>>
>>> order by CUSTOMERTOTAL</property>
>>>
>>> </oda-data-set>
>>>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="salesbyproductline" id="13">
>>>
>>> <list-property name="resultSet">
>>>
>>> <structure>
>>>
>>> <property name="position">1</property>
>>>
>>> <property name="name">PRODUCTLINE</property>
>>>
>>> <property name="dataType">string</property>
>>>
>>> <property name="nativeDataType">12</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">2</property>
>>>
>>> <property name="name">TOTALREVENUE</property>
>>>
>>> <property name="dataType">float</property>
>>>
>>> <property name="nativeDataType">8</property>
>>>
>>> </structure>
>>>
>>> </list-property>
>>>
>>> <structure name="cachedMetaData">
>>>
>>> <list-property name="resultSet">
>>>
>>> <structure>
>>>
>>> <property name="position">1</property>
>>>
>>> <property name="name">PRODUCTLINE</property>
>>>
>>> <property name="dataType">string</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="position">2</property>
>>>
>>> <property name="name">TOTALREVENUE</property>
>>>
>>> <property name="dataType">float</property>
>>>
>>> </structure>
>>>
>>> </list-property>
>>>
>>> </structure>
>>>
>>> <property name="dataSource">Data Source</property>
>>>
>>> <property name="queryText">SELECT PRODUCTLINE,
>>>
>>>
>>>
>>> SUM( PRICEEACH*QUANTITYORDERED ) AS "TOTALREVENUE"
>>>
>>>
>>>
>>> FROM CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.PRODUCTS
>>>
>>>
>>>
>>> WHERE CLASSICMODELS.ORDERDETAILS.PRODUCTCODE =
>>>
>>> CLASSICMODELS.PRODUCTS.PRODUCTCODE
>>>
>>>
>>>
>>> GROUP BY CLASSICMODELS.PRODUCTS.PRODUCTLINE</property>
>>>
>>> </oda-data-set>
>>>
>>> </data-sets>
>>>
>>> <page-setup>
>>>
>>> <simple-master-page name="Simple MasterPage" id="2">
>>>
>>> <page-footer>
>>>
>>> <text id="3">
>>>
>>> <property name="contentType">html</property>
>>>
>>> <text-property name="content"><![CDATA[<value-of>new
>>> Date()</value-of>]]></text-property>
>>>
>>> </text>
>>>
>>> </page-footer>
>>>
>>> </simple-master-page>
>>>
>>> </page-setup>
>>>
>>> <body>
>>>
>>> <extended-item extensionName="Chart" id="6">
>>>
>>> <property name="height">3.947in</property>
>>>
>>> <property name="width">6.26in</property>
>>>
>>> <property name="dataSet">Data Set</property>
>>>
>>> <list-property name="boundDataColumns">
>>>
>>> <structure>
>>>
>>> <property name="name">CUSTOMERNAME</property>
>>>
>>> <expression
>>> name="expression">dataSetRow["CUSTOMERNAME"]</expression >
>>>
>>> <property name="dataType">string</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="name">CUSTOMERNUMBER</property>
>>>
>>> <expression
>>> name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
>>>
>>> <property name="dataType">integer</property>
>>>
>>> </structure>
>>>
>>> <structure>
>>>
>>> <property name="name">CUSTOMERTOTAL</property>
>>>
>>> <expression
>>> name="expression">dataSetRow["CUSTOMERTOTAL"]</expression >
>>>
>>> <property name="dataType">float</property>
>>>
>>> </structure>
>>>
>>> </list-property>
>>>
>>> <xml-property
>>> name="xmlRepresentation"><
Home