Not able to generate Min Slice Pie chart using Birt API java program.

<div>Hi, I am trying to generate Min Slice Pie chart using the below java program-</div>
<div> </div>
<div>public static void createMinSlice( ReportDesignHandle designHandle ) throws Exception</div>
<div>{</div>
<div>ExtendedItemHandle eih = designHandle.getElementFactory().newExtendedItem(null, "Chart");</div>
<div> </div>
<div>eih.setProperty("outputFormat", "SVG");</div>
<div> eih.setWidth("500pt");</div>
<div> eih.setHeight("500pt");</div>
<div> </div>
<div> applyDesign(eih);</div>
<div> </div>
<div> ChartWithoutAxes cwoaPie = ChartWithoutAxesImpl.create( );</div>
<div>cwoaPie.setType( "Pie Chart" ); //$NON-NLS-1$<span> </span></div>
<div>cwoaPie.setSubType( "Standard Pie Chart" ); //$NON-NLS-1$</div>
<div>cwoaPie.getBlock( ).setBackground( ColorDefinitionImpl.WHITE( ));</div>
<div> </div>
<div>// Plot</div>
<div>cwoaPie.getPlot( )</div>
<div>.getClientArea( )</div>
<div>.setBackground( ColorDefinitionImpl.create( 255, 255, 225 ) );</div>
<div> </div>
<div>// Legend</div>
<div>Legend lg = cwoaPie.getLegend( );</div>
<div>lg.setItemType( LegendItemType.CATEGORIES_LITERAL );</div>
<div>lg.getClientArea( ).getOutline( ).setVisible( true );</div>
<div>lg.getTitle( ).setVisible( false );</div>
<div> </div>
<div>// Title</div>
<div>cwoaPie.getTitle( )</div>
<div>.getLabel( )</div>
<div>.getCaption( )</div>
<div>.setValue( "Min Slice Pie Chart" ); //$NON-NLS-1$</div>
<div>cwoaPie.getTitle( ).getOutline( ).setVisible( false );</div>
<div> </div>
<div>// Data Set</div>
<div>TextDataSet categoryValues = TextDataSetImpl.create( new String[]{</div>
<div>"New York", "Boston", "Chicago", "San Francisco", "Dallas", "Miami"//$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$//$NON-NLS-6$</div>
<div>} );</div>
<div>NumberDataSet seriesOneValues = NumberDataSetImpl.create( new double[]{</div>
<div>24, 9, 30, 36, 8, 51</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>SeriesDefinition sd = SeriesDefinitionImpl.create( );</div>
<div>cwoaPie.getSeriesDefinitions( ).add( sd );</div>
<div> </div>
<div>Series seCategory = (Series) SeriesImpl.create( );</div>
<div> </div>
<div>final Fill[] fiaBase = {</div>
<div>ColorDefinitionImpl.ORANGE( ),</div>
<div>GradientImpl.create( ColorDefinitionImpl.create( 225, 225, 255 ),</div>
<div>ColorDefinitionImpl.create( 255, 255, 225 ),</div>
<div>-35,</div>
<div>false ),</div>
<div>ColorDefinitionImpl.CREAM( ),</div>
<div>ColorDefinitionImpl.RED( ),</div>
<div>ColorDefinitionImpl.GREEN( ),</div>
<div>ColorDefinitionImpl.BLUE( ).brighter( ),</div>
<div>ColorDefinitionImpl.CYAN( ).darker( ),</div>
<div>};</div>
<div>sd.getSeriesPalette( ).getEntries( ).clear( );</div>
<div>for ( int i = 0; i < fiaBase.length; i++ )</div>
<div>{</div>
<div>sd.getSeriesPalette( ).getEntries( ).add( fiaBase );</div>
<div>}</div>
<div> </div>
<div>seCategory.setDataSet( categoryValues );</div>
<div>sd.getSeries( ).add( seCategory );</div>
<div> </div>
<div>// Orthogonal Series</div>
<div>SeriesDefinition sdCity = SeriesDefinitionImpl.create( );</div>
<div>sd.getSeriesDefinitions( ).add( sdCity );</div>
<div> </div>
<div>PieSeries sePie = (PieSeries) PieSeriesImpl.create( );</div>
<div>sePie.setDataSet( seriesOneValues );</div>
<div>sePie.setLabelPosition( Position.INSIDE_LITERAL );</div>
<div> </div>
<div>// Explosion</div>
<div>sePie.setExplosion( 10 );</div>
<div>sePie.setExplosionExpression( "valueData<20 ||valueData>50" );//$NON-NLS-1$</div>
<div> </div>
<div>sdCity.getSeries( ).add( sePie );</div>
<div> </div>
<div>// Min Slice</div>
<div>cwoaPie.setMinSlice( 10 );</div>
<div>cwoaPie.setMinSlicePercent( false );</div>
<div>cwoaPie.setMinSliceLabel( "Others" );//$NON-NLS-1$</div>
<div> </div>
<div> </div>
<div>eih.getReportItem().setProperty("chart.instance", cwoaPie); </div>
<div> </div>
<div> designHandle.getBody( ).add( eih ); </div>
<div> </div>
<div>}<span> </span></div>
<div> </div>
<div>I am getting "NullPointerException" in the above method-</div>
<div>
<div>java.lang.NullPointerException</div>
<div>at org.eclipse.birt.chart.factory.Generator.getRowExpressions(Generator.java:1566)</div>
<div>at org.eclipse.birt.chart.factory.Generator.getRowExpressions(Generator.java:593)</div>
<div>at org.eclipse.birt.chart.reportitem.ChartReportItemImpl.getRowExpressions(ChartReportItemImpl.java:978)</div>
<div>at org.eclipse.birt.report.model.util.BoundColumnsMgr.dealExtendedItem(BoundColumnsMgr.java:219)</div>
<div>at org.eclipse.birt.report.model.writer.BoundColumnsWriterMgr.dealExtendedItem(BoundColumnsWriterMgr.java:426)</div>
<div>at org.eclipse.birt.report.model.writer.ModuleWriterImpl.visitExtendedItem(ModuleWriterImpl.java:1875)</div>
<div>at org.eclipse.birt.report.model.writer.ModuleWriter.visitExtendedItem(ModuleWriter.java:1)</div>
<div>at org.eclipse.birt.report.model.writer.DesignWriter.visitExtendedItem(DesignWriter.java:1)</div>
<div>at org.eclipse.birt.report.model.elements.ExtendedItem.apply(ExtendedItem.java:136)</div>
<div>at org.eclipse.birt.report.model.writer.ModuleWriterImpl.writeChildren(ModuleWriterImpl.java:2966)</div>
<div>at org.eclipse.birt.report.model.writer.ModuleWriterImpl.writeContents(ModuleWriterImpl.java:2951)</div>
<div>at org.eclipse.birt.report.model.writer.ModuleWriterImpl.writeContents(ModuleWriterImpl.java:2985)</div>
<div>at org.eclipse.birt.report.model.writer.DesignWriterImpl.writeSlot(DesignWriterImpl.java:174)</div>
<div>at org.eclipse.birt.report.model.writer.DesignWriterImpl.visitReportDesign(DesignWriterImpl.java:78)</div>
<div>at org.eclipse.birt.report.model.elements.ReportDesign.apply(ReportDesign.java:65)</div>
<div>at org.eclipse.birt.report.model.writer.ModuleWriterImpl.writeFile(ModuleWriterImpl.java:320)</div>
<div>at org.eclipse.birt.report.model.writer.ModuleWriterImpl.write(ModuleWriterImpl.java:288)</div>
<div>at org.eclipse.birt.report.model.writer.ModuleWriter.write(ModuleWriter.java:1)</div>
<div>at org.eclipse.birt.report.model.writer.DesignWriter.write(DesignWriter.java:1)</div>
<div>at org.eclipse.birt.report.model.api.ModuleHandleImpl.save(ModuleHandleImpl.java:1456)</div>
<div>at org.eclipse.birt.report.model.api.ModuleHandleImpl.saveAs(ModuleHandleImpl.java:1476)</div>
<div>at CreateDynamicTable.setUp(CreateDynamicTable.java:130)</div>
<div> </div>
<div>
<div>SEVERE: Line Number:250 Error Code:Error.XMLParserException.SAX_ERROR Exception:org.xml.sax.SAXParseException; lineNumber: 250; columnNumber: 1; XML document structures must start and end within the same entity. Message:SAX detected an error with the basic XML syntax of the file. </div>
<div>Jun 08, 2015 11:15:31 AM org.eclipse.birt.report.engine.api.impl.ReportEngineHelper getReportDesignHandle...........</div>
<div> </div>
<div> </div>
<div>Can you please tell where I am going wrong. Thanks.</div>
</div>
</div>
<div> </div>
<div> </div>

Find more posts tagged with

Comments

JFreeman

<p>What's the piece of code that is happening on line 130 of your code?</p>
<p>That is where the stack trace is pointing.</p>

Kartik Sharma

<p>This is my setUp() method-</p>
<p> </p>
<div> private static void setUp(ArrayList<String> userInputs) </div>
<div>{</div>
<div>IDesignEngine engine = null;</div>
<div>DesignConfig config = null;</div>
<div> </div>
<div>// Configure the Engine and start the Platform</div>
<div>try</div>
<div>{</div>
<div>config = new DesignConfig();</div>
<div>Platform.startup(config);</div>
<div>IDesignEngineFactory factory = (IDesignEngineFactory) Platform.createFactoryObject(IDesignEngineFactory.EXTENSION_DESIGN_ENGINE_FACTORY);</div>
<div>engine = factory.createDesignEngine(config);</div>
<div>SessionHandle session = engine.newSessionHandle(ULocale.ENGLISH);</div>
<div>ReportDesignHandle design = session.createDesign( );</div>
<div>ElementFactory elemFactory = design.getElementFactory( );</div>
<div> </div>
<div>GridHandle grid = defineTable(design, elemFactory);</div>
<div> </div>
<div>designTable(elemFactory, grid);</div>
<div> </div>
<div>addTableContent(userInputs,elemFactory,design);</div>
<div> </div>
<div>// Save the design and close it.</div>
<div>design.saveAs( REPORT_BASE_PATH + REPORT_FILE_PATH );</div>
<div>design.close( );</div>
<div>System.out.println("Report design successfully saved at : " + REPORT_BASE_PATH + REPORT_FILE_PATH );</div>
<div> </div>
<div>} </div>
<div>catch (Exception ex) </div>
<div>{</div>
<div>ex.printStackTrace();</div>
<div>}</div>
<div>}</div>
<div> </div>
<div> </div>
<div>and the 130 line is --</div>
<div> </div>
<div>design.saveAs( REPORT_BASE_PATH + REPORT_FILE_PATH ); // 130th line</div>
<div> </div>
<div>When opening the design it's showing that the document has invalid design.. Please help..</div>

JFreeman

<p>Nothing is jumping out at me in that method that would cause there to be an error in the document structure of the output.</p>
<p>My guess is there is something happening in one of the methods where you are adding content to the report that is causing the issue.</p>
<p> </p>
<p>If you remove the method calls that add content to the report, does it successfully create/save the blank report?</p>
<p>That will establish if the issue is with adding content or not and if so, you can then narrow it down to a specific method that is causing the issue.</p>

Kartik Sharma

<p>Hi,</p>
<p>I checked all the functions out there but didn't get where the problem is. Can you please provide a sample program for creating Min Slice Pie Chart in which the data is retrieved from database, using BIRT api Java program. </p>
<p>Thanks.</p>

Kartik Sharma

<div>Hi,</div>
<div>On debugging, I found that "getDataSet()" function (in BIRT api) is returning "null". I think there is some problem with the code written in this package - </div>
<div>Package -</div>
<div> org.eclipse.birt.chart.model.data.impl.SeriesDefinitionImpl</div>
<div> </div>
<div>public final Series getDesignTimeSeries()</div>
<div> </div>
<div> EList el = getSeries();</div>
<div> for (int i = 0; i < el.size(); i++)</div>
<div> {</div>
<div> Series se = (Series)el.get(i);</div>
<div> if (se.getDataSet() == null) // Here getDataSet() can't be null because I am setting it in my class file.</div>
<div> {</div>
<div> return se;</div>
<div> }</div>
<div> }</div>
<div> return null;</div>
<div> }<br>
</div>
<div>

</div>
<div>
<div>Series seBase = categorySD.getDesignTimeSeries(); // Here seBase is set to null, that's why program is throwing Null pointer Exception</div>
<div>EList elBaseSeries = seBase.getDataDefinition();</div>
<div> </div>
<div>

</div>
</div>
<p> </p>

JFreeman

<p>If you can reproduce the issue with sample code, you can see about filing a bug report.</p>
<p>I would need to see more the code and be able to replicate the issue.</p>
<p> </p>
<p>Here is a quick sample I created that creates a report with a pie chart that uses the min slice setting and creates the data source/set as the classic models sample data base:</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.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;

public class DeapiSample {

static ElementFactory elementFactory = null;
static ReportDesignHandle reportDesignHandle = 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();

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);
cwoaPie.setMinSlice(10);
cwoaPie.setMinSlicePercent(false);
cwoaPie.setMinSliceLabel("Others");

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>

Kartik Sharma

<p>I got my mistake. Thanks a lot for the sample program.</p>

JFreeman

<p>You're welcome.</p>
<p>I'm glad to hear you got it resolved.</p>
<p> </p>
<p>Let us know if you have additional questions.</p>

Ãlvaro

<blockquote class="ipsBlockquote" data-author="Kartik Sharma" data-cid="137224" data-time="1434606871">
<div>
<p>I got my mistake. Thanks a lot for the sample program.</p>
</div>
</blockquote>
<p>Hi!</p>
<p> </p>
<p>I have the same error but I can't fix it. What did you do? My code is very similar to yours.</p>
<p> </p>
<p>Thanks!</p>