Creating Pie Charts using java - RE API

<p>Hello,</p>
<p> </p>
<p>I need to create Pie Charts from the data available in a table in BIRT.</p>
<p>Could someone give me a working example for a pie chart generated from static data?</p>
<p> </p>
<p>I checked the Chart Examples in BIRT. But I don't know how to use it in a report.</p>
<p> </p>
<p>Here is the code mentioned:</p>
<p> </p>
<div>/***********************************************************************</div>
<div> * Copyright (c) 2004, 2005 Actuate Corporation.</div>
<div> * All rights reserved. This program and the accompanying materials</div>
<div> * are made available under the terms of the Eclipse Public License v1.0</div>
<div> * which accompanies this distribution, and is available at</div>
<div> * <a data-ipb='nomediaparse' href='http://www.eclipse.org/legal/epl-v10.html'>http://www.eclipse.org/legal/epl-v10.html</a></div>
<div> *</div>
<div> * Contributors:</div>
<div> * Actuate Corporation - initial API and implementation</div>
<div> ***********************************************************************/</div>
<div> </div>
<div>package org.eclipse.birt.chart.examples.view.models;</div>
<div> </div>
<div>import org.eclipse.birt.chart.model.Chart;</div>
<div>import org.eclipse.birt.chart.model.ChartWithoutAxes;</div>
<div>import org.eclipse.birt.chart.model.attribute.ChartDimension;</div>
<div>import org.eclipse.birt.chart.model.component.Series;</div>
<div>import org.eclipse.birt.chart.model.component.impl.SeriesImpl;</div>
<div>import org.eclipse.birt.chart.model.data.BaseSampleData;</div>
<div>import org.eclipse.birt.chart.model.data.DataFactory;</div>
<div>import org.eclipse.birt.chart.model.data.NumberDataSet;</div>
<div>import org.eclipse.birt.chart.model.data.OrthogonalSampleData;</div>
<div>import org.eclipse.birt.chart.model.data.SampleData;</div>
<div>import org.eclipse.birt.chart.model.data.SeriesDefinition;</div>
<div>import org.eclipse.birt.chart.model.data.TextDataSet;</div>
<div>import org.eclipse.birt.chart.model.data.impl.NumberDataSetImpl;</div>
<div>import org.eclipse.birt.chart.model.data.impl.SeriesDefinitionImpl;</div>
<div>import org.eclipse.birt.chart.model.data.impl.TextDataSetImpl;</div>
<div>import org.eclipse.birt.chart.model.impl.ChartWithoutAxesImpl;</div>
<div>import org.eclipse.birt.chart.model.layout.Legend;</div>
<div>import org.eclipse.birt.chart.model.type.PieSeries;</div>
<div>import org.eclipse.birt.chart.model.type.impl.PieSeriesImpl;</div>
<div> </div>
<div>public class Pie</div>
<div>{</div>
<div> </div>
<div>public static final Chart createPie( )</div>
<div>{</div>
<div>ChartWithoutAxes cwoaPie = ChartWithoutAxesImpl.create( );</div>
<div>cwoaPie.setDimension( ChartDimension.TWO_DIMENSIONAL_WITH_DEPTH_LITERAL );</div>
<div>cwoaPie.setType( "Pie Chart" ); //$NON-NLS-1$<span> </span></div>
<div>cwoaPie.setSubType( "Standard Pie Chart" ); //$NON-NLS-1$</div>
<div> </div>
<div>// Plot</div>
<div>cwoaPie.setSeriesThickness( 10 );</div>
<div> </div>
<div>// Legend</div>
<div>Legend lg = cwoaPie.getLegend( );</div>
<div>lg.getOutline( ).setVisible( true );</div>
<div> </div>
<div>// Title</div>
<div>cwoaPie.getTitle( ).getLabel( ).getCaption( ).setValue( "Pie Chart" );//$NON-NLS-1$</div>
<div> </div>
<div>// Data Set</div>
<div>TextDataSet categoryValues = TextDataSetImpl.create( new String[]{</div>
<div>"New York", "Boston", "Chicago", "San Francisco", "Dallas"} );//$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$</div>
<div>NumberDataSet seriesOneValues = NumberDataSetImpl.create( new double[]{</div>
<div>54.65, 21, 75.95, 91.28, 37.43</div>
<div>} );</div>
<div> </div>
<div>SampleData sdata = DataFactory.eINSTANCE.createSampleData( );</div>
<div>BaseSampleData sdBase = DataFactory.eINSTANCE.createBaseSampleData( );</div>
<div>sdBase.setDataSetRepresentation( "" );//$NON-NLS-1$</div>
<div>sdata.getBaseSampleData( ).add( sdBase );</div>
<div> </div>
<div>OrthogonalSampleData sdOrthogonal = DataFactory.eINSTANCE.createOrthogonalSampleData( );</div>
<div>sdOrthogonal.setDataSetRepresentation( "" );//$NON-NLS-1$</div>
<div>sdOrthogonal.setSeriesDefinitionIndex( 0 );</div>
<div>sdata.getOrthogonalSampleData( ).add( sdOrthogonal );</div>
<div> </div>
<div>cwoaPie.setSampleData( sdata );</div>
<div> </div>
<div>// Base Series</div>
<div>Series seCategory = SeriesImpl.create( );</div>
<div>seCategory.setDataSet( categoryValues );</div>
<div> </div>
<div>SeriesDefinition sd = SeriesDefinitionImpl.create( );</div>
<div>cwoaPie.getSeriesDefinitions( ).add( sd );</div>
<div>sd.getSeriesPalette( ).shift( 0 );</div>
<div>sd.getSeries( ).add( seCategory );</div>
<div> </div>
<div>// Orthogonal Series</div>
<div>PieSeries sePie = (PieSeries) PieSeriesImpl.create( );</div>
<div>sePie.setDataSet( seriesOneValues );</div>
<div>sePie.setSeriesIdentifier( "Cities" );//$NON-NLS-1$ </div>
<div>sePie.setExplosion( 5 );</div>
<div> </div>
<div>SeriesDefinition sdCity = SeriesDefinitionImpl.create( );</div>
<div>sd.getSeriesDefinitions( ).add( sdCity );</div>
<div>sdCity.getSeries( ).add( sePie );</div>
<div> </div>
<div>return cwoaPie;</div>
<div>}</div>
<div> </div>
<div>}</div>
<div> </div>
<div> </div>
<div>I also have to create a pdf of the report. I know I have to use IRunAndRenderTask,</div>
<div>but again, I need a complete sample code.</div>
<div> </div>
<div>Thanks in advance

</div>

Find more posts tagged with

Comments

JFreeman

<p>Are you wanting to use this code in a report design itself through the scripting within the report or are you wanting to use this in conjunction with DEAPI while dynamically creating the report?</p>
<p> </p>
<p>Based on our previous discussion, I'm guessing you are wanting this in your Java application that is using DEAPI to dynamically generate reports. However, please confirm your use case as that can change the implementation.</p>

Richa Raj

<p>Thank you for understanding my somewhat hazy question!

</p>
<p> </p>
<p>As you said, I want to create the pie chart using the DEAPI in my java application to dynamically generate the reports.</p>

JFreeman

<p>Take a look at this DEAPI sample code: <a data-ipb='nomediaparse' href='https://www.eclipse.org/birt/resources/documentation/integrating/DeDemo.java'>https://www.eclipse.org/birt/resources/documentation/integrating/DeDemo.java</a></p>
<p> </p>
<p>Think you may have referenced this code already. Within the sample DEAPI code, it is creating a label and adding it into a grid cell. I believe you should be able to do the same thing but instead of a label, use the object created by your pie chart code to place the chart into the grid cell.</p>

Richa Raj

<p>I actually wanted to refer to a code that will help me create a pie chart for my existing data set using the REAPI.</p>
<p>I'm looking for the code for pie chart generation.</p>

JFreeman

<p>Take a look at this sample I put together. It creates a Data Source/Set with Classic Models, creates a pie chart using this Data Source/Set and then adds the pie chart into the body of the report.</p>
<pre class="_prettyXprint _lang-js">
package com.actuate.sample;

import com.ibm.icu.util.ULocale;
import java.io.IOException;

import org.eclipse.birt.chart.model.ChartWithoutAxes;
import org.eclipse.birt.chart.model.attribute.ChartDimension;
import org.eclipse.birt.chart.model.attribute.DataType;
import org.eclipse.birt.chart.model.attribute.LegendItemType;
import org.eclipse.birt.chart.model.attribute.Position;
import org.eclipse.birt.chart.model.attribute.impl.BoundsImpl;
import org.eclipse.birt.chart.model.attribute.impl.ColorDefinitionImpl;
import org.eclipse.birt.chart.model.component.Series;
import org.eclipse.birt.chart.model.component.impl.SeriesImpl;
import org.eclipse.birt.chart.model.data.Query;
import org.eclipse.birt.chart.model.data.SeriesDefinition;
import org.eclipse.birt.chart.model.data.SeriesGrouping;
import org.eclipse.birt.chart.model.data.impl.QueryImpl;
import org.eclipse.birt.chart.model.data.impl.SeriesDefinitionImpl;
import org.eclipse.birt.chart.model.impl.ChartWithoutAxesImpl;
import org.eclipse.birt.chart.model.layout.Legend;
import org.eclipse.birt.chart.model.layout.Plot;
import org.eclipse.birt.chart.model.type.impl.PieSeriesImpl;
import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.model.api.DesignConfig;
import org.eclipse.birt.report.model.api.DesignEngine;
import org.eclipse.birt.report.model.api.ElementFactory;
import org.eclipse.birt.report.model.api.ExtendedItemHandle;
import org.eclipse.birt.report.model.api.IDesignEngine;
import org.eclipse.birt.report.model.api.IDesignEngineFactory;
import org.eclipse.birt.report.model.api.OdaDataSetHandle;
import org.eclipse.birt.report.model.api.OdaDataSourceHandle;
import org.eclipse.birt.report.model.api.PropertyHandle;
import org.eclipse.birt.report.model.api.ReportDesignHandle;
import org.eclipse.birt.report.model.api.SessionHandle;
import org.eclipse.birt.report.model.api.StructureFactory;
import org.eclipse.birt.report.model.api.activity.SemanticException;
import org.eclipse.birt.report.model.api.elements.structures.ComputedColumn;
import org.eclipse.birt.report.model.api.metadata.IMetaDataDictionary;

public class DeapiSample {

static ElementFactory elementFactory = null;
static ReportDesignHandle reportDesignHandle = null;
static IMetaDataDictionary dict = null;

private static void createReport(){
DesignConfig config = new DesignConfig();
config.setBIRTHome("C:/BIRT_Runtime");

IDesignEngine engine = null;

try{
Platform.startup(config);
IDesignEngineFactory factory = (IDesignEngineFactory) Platform.createFactoryObject(IDesignEngineFactory.EXTENSION_DESIGN_ENGINE_FACTORY);
engine = factory.createDesignEngine(config);
}catch(Exception ex){
ex.printStackTrace();
}

SessionHandle session = engine.newSessionHandle(ULocale.ENGLISH);

reportDesignHandle = session.createDesign();
elementFactory = reportDesignHandle.getElementFactory();
dict = new DesignEngine(null).getMetaData();

try {
createDataSource();
createDataSet();
ExtendedItemHandle pieChart = createPieChart();
reportDesignHandle.getBody().add(pieChart);

} catch (SemanticException ex) {
ex.printStackTrace();
}

try {
reportDesignHandle.saveAs("C:/temp/Reports/sampleReport.rptdesign");
} catch (IOException ex) {
ex.printStackTrace();
}
}

private static void createDataSource() throws SemanticException{
OdaDataSourceHandle dataSourceHandle = elementFactory.newOdaDataSource("Classic Models Data Source", "org.eclipse.birt.report.data.oda.jdbc");
dataSourceHandle.setProperty("odaDriverClass", "org.eclipse.birt.report.data.oda.sampledb.Driver");
dataSourceHandle.setProperty("odaURL", "jdbc:classicmodels:sampledb");
dataSourceHandle.setProperty("odaUser", "ClassicModels");
dataSourceHandle.setProperty("odaPassword", "");

reportDesignHandle.getDataSources().add(dataSourceHandle);
}

private static void createDataSet() throws SemanticException{
OdaDataSetHandle dataSetHandle = elementFactory.newOdaDataSet("Classic Models Data Set", "org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet");
dataSetHandle.setDataSource("Classic Models Data Source");
dataSetHandle.setQueryText("SELECT * FROM CLASSICMODELS.ORDERS");

reportDesignHandle.getDataSets().add(dataSetHandle);
}

private static ExtendedItemHandle createPieChart() throws SemanticException{
ExtendedItemHandle eih = reportDesignHandle.getElementFactory().newExtendedItem(null, "Chart");
eih.setProperty(ExtendedItemHandle.DATA_SET_PROP, "Classic Models Data Set");
eih.setProperty("outputFormat", "SVG");
eih.setWidth("500pt");
eih.setHeight("500pt");

ComputedColumn c1 = StructureFactory.createComputedColumn();
c1.setName("category");
c1.setDataType("string");
c1.setExpression("dataSetRow[\"STATUS\"]");

ComputedColumn c2 = StructureFactory.createComputedColumn();
c2.setName("surface");
c2.setDataType("integer");
c2.setExpression("dataSetRow[\"ORDERNUMBER\"]");

PropertyHandle bindings = eih.getColumnBindings();
bindings.addItem(c1);
bindings.addItem(c2);

ChartWithoutAxes cwoaPie = ChartWithoutAxesImpl.create();
cwoaPie.setDimension(ChartDimension.TWO_DIMENSIONAL_LITERAL);
cwoaPie.getBlock( ).setBackground( ColorDefinitionImpl.WHITE() );
cwoaPie.getBlock().setBounds(BoundsImpl.create(0, 0, 500, 500));
cwoaPie.setType("Pie Chart");
cwoaPie.setSubType("Standard Pie Chart");
cwoaPie.setSeriesThickness(10);

Plot plot = cwoaPie.getPlot();
plot.getClientArea().setBackground(ColorDefinitionImpl.WHITE());

Legend legend = cwoaPie.getLegend();
legend.setItemType(LegendItemType.CATEGORIES_LITERAL);
legend.getTitle().setVisible(false);

cwoaPie.getTitle().getLabel().getCaption().setValue("Pie Chart Title");
cwoaPie.getTitle().getOutline().setVisible(false);

SeriesDefinition sd = SeriesDefinitionImpl.create();
Query categoryQuery = QueryImpl.create("row[\"category\"]");
Series seriesCategory = SeriesImpl.create();
seriesCategory.getDataDefinition().add(categoryQuery);
sd.getSeries().add(seriesCategory);
cwoaPie.getSeriesDefinitions().add(sd);

SeriesGrouping grouping = sd.getGrouping();
grouping.setEnabled(true);
grouping.setGroupType(DataType.TEXT_LITERAL);
grouping.setGroupingInterval(1);
grouping.setAggregateExpression("Count");
sd.setGrouping(grouping);

SeriesDefinition sdSurface = SeriesDefinitionImpl.create();
sd.getSeriesDefinitions().add(sdSurface);
Series pieSeries = PieSeriesImpl.create();

Query seriesQuery = QueryImpl.create("row[\"surface\"]");
pieSeries.getDataDefinition().add(seriesQuery);
pieSeries.setLabelPosition(Position.OUTSIDE_LITERAL);

sdSurface.getSeries().add(pieSeries);
eih.getReportItem().setProperty("chart.instance", cwoaPie);

return eih;
}

public static void main( String[] args ){
createReport();

}

}
</pre>

Richa Raj

<p>I tried running the above example..</p>
<p>It gives me the following errors:</p>
<p> </p>
<div>org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.</div>
<div>securityDomain should be null if setSecurityController() was never called</div>
<div> </div>
<div>at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)</div>
<div> </div>
<div>at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:183)</div>
<div> </div>
<div>at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:222)</div>
<div> </div>
<div>at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:157)</div>
<div> </div>
<div>at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:69)</div>
<div> </div>
<div>at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:366)</div>
<div> </div>
<div>at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)</div>
<div> </div>
<div>Caused by: org.eclipse.birt.core.exception.BirtException: securityDomain should be null if setSecurityController() was never called</div>
<div> </div>
<div>... 6 more</div>

JFreeman

<p>It looks like this is an issue with the configuration of your Security Manager for your JVM.</p>
<p> </p>
<p>From what I have found you should be able to resolve issue by setting the security manager to null. This should only need to be done once per JVM instance.</p>
<pre class="_prettyXprint _lang-js">
System.setSecurityManager(null);
</pre>