chart axis vs dataset columns

nikodem38

Hi,

I need to create a scripted chart but I don't want to use any dataset results.

All I have is a list of values that I want to use for category and series in the chart.

How can I do that?

Thanks for your feedback.

Nicolas

kclark

I've attached a rptdesign that takes values from a dataset and puts them into an array. The script then iterates through the arrays and adds the values to the chart. <br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
function beforeGeneration( chart, icsc )

{

importPackage(Packages.java.util);

importPackage(Packages.org.eclipse.birt.chart.model.data.impl);
importPackage(Packages.org.eclipse.birt.chart.model.attribute);
importPackage(Packages.org.eclipse.birt.chart.model.component.impl);
importPackage(Packages.org.eclipse.birt.chart.model.attribute.impl);
importPackage(Packages.org.eclipse.birt.chart.model.type.impl);
importPackage(Packages.org.eclipse.birt.chart.util);
importPackage(Packages.java.util);

var xAxis = chart.getAxes().get(0);

var yAxis = xAxis.getAssociatedAxes().get(0);


var xSerieDef = xAxis.getSeriesDefinitions().get(0);

var ySerieDef = yAxis.getSeriesDefinitions().get(0);


// create custom data

var xData = new ArrayList( );
ydata1 =icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("pricearry");
xdata1 =icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("dtarry");


var cal = new GregorianCalendar();
for( i=0;i<xdata1.size();i++){
cal.setTime(xdata1.get(i));

var cdt = new CDateTime( cal.get(Calendar.YEAR), cal.get(Calendar.MONTH)+1, cal.get(Calendar.DAY_OF_MONTH) );
xData.add( cdt);
}


var categoryValues = DateTimeDataSetImpl.create( xData );

var orthoValues = NumberDataSetImpl.create( ydata1 );


// create custom series

var seCategory = SeriesImpl.create( );

// or just change existing series

// var seCategory = xSerieDef.getRuntimeSeries().get(0);

seCategory.setDataSet( categoryValues );


var bs = LineSeriesImpl.create( );

// or just change existing series

// var bs = ySerieDef.getRuntimeSeries().get(0);

bs.setSeriesIdentifier( "Dynamic\r\nBar Series" ); //$NON-NLS-1$

bs.setDataSet( orthoValues );


// clear existing series

xSerieDef.getSeries().clear();

ySerieDef.getSeries().clear();


// bind new sereis to chart

xSerieDef.getSeries().add(seCategory);

ySerieDef.getSeries().add(bs);

//This is processed before
ttv = TooltipValueImpl.create( 50,"\"tefffst\"");
a = ActionImpl.create( ActionType.SHOW_TOOLTIP_LITERAL,ttv );
t = TriggerImpl.create( TriggerCondition.ONMOUSEOVER_LITERAL,a );
//myseries.getTriggers().clear();
bs.getTriggers().add(t);

}
</pre>
<br />
You should be able to do the same thing with your report, create an array and loop through your data, then add it to the chart. Let me know if this helps or if you have any questions