dynamic chart resize through scripting

Hello All, 
 
I'm trying to work my way through doing some scripting to dynamically resize a chart based on the number of rows in the dataSet the chart uses. I was trying to do something like this but it totally fails: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>

var chart1 = this.getReportElement("chartAccountSummary");
var rowCount = AccountSummary.getRowCount("account_id");
var height = 5;
var finalHeight = "";

for(var counter=0;counter<rowCount;counter++){
height += 1;
}
finalHeight = height + "in";
chart1.setHeight(finalHeight);

</pre>
 
It fails because it doesn't know what "AccountSummary" is. That is the name of the dataset that I'm trying to retrieve row count from. I may just be completely off. I currently have this code in the beforeFactory() of the report. 
 
Any information would be very helpful. Thanks

Amanda

Find more posts tagged with

Comments

DreamCoder

I figured it out thanks to a very helpful article I found here. For future reference (in case someone else searches this one out): 
 
article: 
<a class='bbc_url' href='http://www.goneeded.com/javas/articles/20080425/a915661193.html'>Birt World: BIRT Resizing Charts</a> 
 
My personalized resolution: 
I added the following code in the script tab of the chart: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
function afterDataSetFilled( series, dataSet, icsc )
{
if( series.getSeriesIdentifier() == "seriesone" ){
var count = dataSet.getValues().length;
var height = 50;
for( var i=0; i<count; i++){
height += 20;
}
icsc.getChartInstance().getBlock().getBounds().setHeight(height);
}
}
</pre>
 
Happy coding!

probs

Hi,
 
The above code works fine with normal charts.
But for Flash chart the same code doesnt work.
 
function afterDataSetFilled( series, dataSet, fcsc )
{
importPackage(Packages.org.eclipse.birt.chart.model.type.impl); 
importPackage(Packages.org.eclipse.birt.chart.util);
importPackage(Packages.java.util);
importPackage(Packages.java.io);
if ( series.getSeriesIdentifier() == "Series 1" )
{
if ( dataSet.getValues().length > 0 )
{ 
fcsc.getChartInstance().getBlock().getBounds().setWidth(295);
//fcsc.getFlashChartInstance().getChart().getBlock().getBounds().setWidth(20.26);
//fcsc.getFlashChartInstance().getChart().getBlock().getBounds().setHeight(1254.32);
}
}
 
}
 
Any solutions for this.
thanks

JFreeman

Which version of the designer are you using?

probs

eclipse version is 3.6.2.
actuate version is 11.0.3
 
Thanks,
Prabal

JFreeman

From what I can tell the bounds properties for the chart instance are not what is used to determine the width/height for a flash chart. I have been able to modify its width/height by hooking the chart in the beforeRender of the report design.
 
For Example(myFlashChart is the name of the chart):
<pre class="_prettyXprint _lang-js">
reportContext.getDesignHandle().findElement("myFlashChart").setStringProperty("width","900px");
reportContext.getDesignHandle().findElement("myFlashChart").setStringProperty("height","700px");
</pre>
I've attached a sample based on classic models for your reference.

probs

Hi JFreeman,
 
Thank you very much for looking into this.
This works fine.
 
But if we are selecting the height and width dynamically based on the number of data returned by the dataset then this doesn't work.
for eg: I am using below code to set the height of my chart.
 
icsc.getChartInstance().getBlock().getBounds().setHeight((dataSet.getValues().length * 13)+3);
 
Can you please let me know how can we acheive this for flash charts.
Thanks,
Prabal

JFreeman

You can move the script into the beforeFactory and then use the Data Engine API to query the data source to determine the number of rows that will be returned to the data set.
 
For Example:
<pre class="_prettyXprint _lang-js">
importPackage(Packages.org.eclipse.birt.report.model.api);
importPackage(Packages.java.util);
importPackage(Packages.org.eclipse.birt.data.engine.api);
importPackage(Packages.org.eclipse.birt.report.model.api);
importPackage(Packages.org.eclipse.birt.data.engine.api.querydefn);
importPackage(Packages.org.eclipse.birt.data.engine.core);
importPackage(Packages.org.eclipse.birt.core.data);

var myconfig = reportContext.getReportRunnable().getReportEngine().getConfig();
var de = DataEngine.newDataEngine( myconfig, null );
var dsrc = reportContext.getDesignHandle().findDataSource("Data Source");
var dset = reportContext.getDesignHandle().findDataSet("Data Set");
var odaDataSource = new OdaDataSourceDesign( "Test Data Source" );

odaDataSource.setExtensionID( "org.eclipse.birt.report.data.oda.jdbc" );
odaDataSource.addPublicProperty( "odaURL", dsrc.getProperty("odaURL").toString() );
odaDataSource.addPublicProperty( "odaDriverClass", dsrc.getProperty("odaDriverClass").toString());
odaDataSource.addPublicProperty( "odaUser", dsrc.getProperty("odaUser").toString() );
odaDataSource.addPublicProperty( "odaPassword", "" );

var odaDataSet = new OdaDataSetDesign( "Test Data Set" );
odaDataSet.setDataSource( odaDataSource.getName( ) );
odaDataSet.setExtensionID( "org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" );
odaDataSet.setQueryText( dset.getQueryText() );

de.defineDataSource( odaDataSource );
de.defineDataSet( odaDataSet );
queryDefinition = new QueryDefinition( );
queryDefinition.setDataSetName( odaDataSet.getName() );
queryDefinition.setAutoBinding(true);

var pq = de.prepare( queryDefinition );
var qr = pq.execute( null );
var rowcount = 0;
var ri = qr.getResultIterator( );

while ( ri.next( ) ) {
rowcount++;
}

ri.close( );
qr.close( );
de.shutdown( );

var newHeight = ((rowcount * 2) + 3).toString();

reportContext.getDesignHandle().findElement("myFlashChart").setStringProperty("width","900px");
reportContext.getDesignHandle().findElement("myFlashChart").setStringProperty("height",( newHeight + "px"));

</pre>
Attached is a new version of the sample report with this code for reference.

probs

Hi JFreeman, 
 
Thanks again for the quick reply. 
This works but not the way intended. 
 
For eg: 
In the above report, the dataset returns 23 rows (because of the filter added). 
But still the "rowcount" is 326 i,e, number of rows without the filter. 
even if I try to add a filter using the below code , it is added after the resultset is retrived for the dataset. And the "rowcount" is still 326. 
 
fc = StructureFactory.createFilterCond(); 
fc.setExpr("row[\"STATUS\"]"); 
fc.setOperator(DesignChoiceConstants.MAP_OPERATOR_EQ); 
fc.setValue1("\"Cancelled\""); 
ph = dset.getPropertyHandle("filter"); 
ph.addItem(fc); 

if we need to add any filter or aggregate to the dataset then we have to do it below way
 
while( ri.next( ) ) {
if(ri.getString("STATUS") != "Shipped")
{
rowcount++;
}
}
And it is not always feasible to do an aggregation in the resultset (java) level.
 
 
But if you create a normal bar chart in the same report with the same series and catagory values , and add the below code in onRender of the chart.
 
function afterDataSetFilled( series, dataSet, icsc )
{
importPackage(Packages.org.eclipse.birt.chart.model.type.impl);
importPackage(Packages.org.eclipse.birt.chart.util);
importPackage(Packages.java.util);
importPackage(Packages.java.io);
 
if( series.getSeriesIdentifier() == "Series 1" )
{
if( dataSet.getValues().length > 0 )
{
icsc.getChartInstance().getBlock().getBounds().setWidth((dataSet.getValues().length * 30)+3);
icsc.getChartInstance().getBlock().getBounds().setHeight(230);
}
}
 
}
 
This will set the width of the chart to be (5*30)+3px i,e, 153px
But in the above code given by you this aggregated dataset value is not available.
 
Moreover this code will only work if the datasource is a JDBC datasource.
But if we are using an Actuate Data Object Data Source then how do we prequery a dataset and get the result ?
 
Can you please help me out in acheiving this.
 
Thanks,
Prabal

probs

please find the report file attached
 
Thanks,
Prabal

JFreeman

Here is a different way to query the data set that will query the existing data set with all filters, etc. in place on the data set. It also determines the data source/set type dynamically so it will work with any data source type.
<pre class="_prettyXprint _lang-js">

QueryDataSet("Data Set");

function resizeFlashChart(rowcount){
var newHeight = ((rowcount * 30) + 3).toString() + "px";
reportContext.getDesignHandle().findElement("myFlashChart").setStringProperty("width","900px");
reportContext.getDesignHandle().findElement("myFlashChart").setStringProperty("height",newHeight);
}

function ResultLogic(ri) {
var rowcount = 0;
while (ri.next()){
rowcount++;
}
resizeFlashChart(rowcount);
}

function QueryDataSet(dataSetName) {

//Gather Data Source Info
var dataSourceName = reportContext.getDesignHandle().findDataSet(dataSetName).getDataSourceName();

//Import Classes
importClass(org.eclipse.birt.data.engine.api.querydefn.QueryDefinition);
importClass(org.eclipse.birt.report.data.adapter.api.DataRequestSession);
importClass(org.eclipse.birt.report.data.adapter.api.DataSessionContext);

//Prepare preQuery
var engineConfig = reportContext.getReportRunnable().getReportEngine().getConfig();
var dataSourceHandle = reportContext.getDesignHandle().findDataSource(dataSourceName);
var dataSetHandle = reportContext.getDesignHandle().findDataSet(dataSetName);

var iScriptContext = _jsContext.getScriptContext();
var dataSessionContext = new DataSessionContext(DataSessionContext.MODE_DIRECT_PRESENTATION, reportContext.getDesignHandle(), iScriptContext, null);
var dataRequestSession = DataRequestSession.newSession(engineConfig, dataSessionContext);

var DataModelAdapter = dataRequestSession.getModelAdaptor();
var odaDataSourceAdapter = DataModelAdapter.adaptDataSource(dataSourceHandle);
var odaDataSetAdapter = DataModelAdapter.adaptDataSet(dataSetHandle);

odaDataSetAdapter.setDataSource(dataSourceName);
dataRequestSession.defineDataSource( odaDataSourceAdapter );
dataRequestSession.defineDataSet( odaDataSetAdapter );

iQueryDefinition = new QueryDefinition( );
iQueryDefinition.setAutoBinding(true);
iQueryDefinition.setDataSetName( odaDataSetAdapter.getName() );

//Run Query
var iPreparedQuery = dataRequestSession.prepare( iQueryDefinition );
var iQueryResults = iPreparedQuery.execute( null );
var iResultIterator = iQueryResults.getResultIterator( );

ResultLogic(iResultIterator);

//Close up
iResultIterator.close( );
iQueryResults.close( );
dataRequestSession.shutdown( );
}

</pre>
Attached is the sample report with this code in place for reference.

probs

Hi JFreeman,
 
The above query does not query the existing dataset with all filters, etc. in place on the dataset.
Also as I mentioned earlier, this does not work with Actuate Data Object Datasource(.data files as datasource).
Please find attached the sample report . Please generate a data object and try to run the report.
 
Also this code does not work if the datasource and dataset are included from a Report library .
Also if we are using any script in the dataset(before Open) then also it throws an error.
 
Please help me out.
 
Thanks,
prabal

JFreeman

Here is a different approach to obtaining the row count that doesn't involve using the DEAPI in beforeFactory.
 
Instead the attached sample has an aggregate computed column in the data set. The aggregate value is a count of the rows and is passed into a report variable in the onCreate of a hidden text element. Then in the beforeRender of the report design the value is obtained from the report variable to be used in the calculation to set the charts dimensions.

probs

Hi Jesse,
 
This approach works perfectly and is faster also.
Thank you very much for the solution.
 
But I still wonder, can we use DEAPI for quering Actuate Data Object Datasource(.data files as datasource).
and also is there any document from which we can know all the functions that can be used with flash charts , with some examples.
 
for example to get the minimum value of a chart series i am using the following code
 
function afterDataSetFilled( series, dataSet, icsc ) 
{ 
importPackage(Packages.org.eclipse.birt.chart.model.type.impl); 
importPackage(Packages.org.eclipse.birt.chart.util);
 ps=PluginSettings.instance(); 
dps=ps.getDataSetProcessor(series.getClass()); 
var mmin=dps.getMinimum(dataSet); 
}
 
will this work with Actuate Data Object Datasource and flash charts.
 
thanks,
Prabal

JFreeman

It is possible to use DEAPI to query a Data Object Data Source/Set. I've attached a new version of the sample report that includes the modifications needed to query a Data Object.
 
Regarding documentation for flash charts, details can be found in the "Using Actuate BIRT Designer Professional" documentation for 11SP3 here: <a data-ipb='nomediaparse' href='http://developer.actuate.com/be/documentation/Manuals11SP3/using-actuate-bdpro.pdf'>http://developer.actuate.com/be/documentation/Manuals11SP3/using-actuate-bdpro.pdf</a>
Chapter 12 covers the Flash charts and gadgets.

probs

Hi Jesse,
 
Thank you verymuch for the example.
This works really fine and this is very very helpful to me.
 
But again I am stuck in one more step, i,e, can we use DEAPI to query a joined dataset that uses an actuate dataobject datasource.
 
please find attached the sample report.
 
Please help me on this.
 
Thanks,
Prabal

probs

Hi Jesse,
 
Sorry for posting this in this thread, but I am not able to create a new topic.
The DEAPI script in the earlier post which is used to query a Data Object Data Source/Set does not return a resultsetIterator object.
 
Please find the sample report and datadesign files attached.
Please help me in achieving this.
 
Thanks,
Prabal

probs

Hi,
 
Can anyone please help me on the above query.
 
Thanks,
Prabal

probs

Hi,
I am still waiting for a solution. Can anyone please help me out on this.