Dynamix Y-axis max scale chart

Hello,

I want to be able to have my chart, take the max value, in the scale option, from a dataset value, that's pulled in at run time.

Right now I can only hard input a value in for the max in the scale options when you double click the chart, format chart, Y-axis, scale button.

Thanks.

Find more posts tagged with

Comments

mwilliams

Hi msolovyov,

What version of BIRT are you using?

msolovyov

2.3.1 is the version I'm running.

mwilliams

msolovyov, 
 
This <a class='bbc_url' href='http://www.birt-exchange.com/forum/eclipse-birt-newsgroup-mirror/11431-chart-y-axis-limiting.html'>post</a> from the Eclipse Newsgroup Mirror may help you with that.

msolovyov

Is there a set max y axis scale function that would take a value from a data set result I can call as a script pre-generation of the chart?

---edit

after looking through that linked thread, I've progressed to this:

function beforeGeneration(chart, icsc)
{
importPackage( Packages.org.eclipse.birt.chart.model.data.impl );

xAxis = chart.getBaseAxes()[0];

yAxis1 = chart.getOrthogonalAxes( xAxis, true)[0]
yscale1 = yAxis1.getScale();
yscale1.setMin( NumberDataElementImpl.create(0) );
yscale1.setMax(NumberDataElementImpl.create(dataSetRow["name"]) );
yAxis1.setScale(yscale1); //yscale1

}
dataSetRow["name"] doesn't exist, exception is produced; when I put a number such as 10 in there, it works.

How do I link the datasetrow value properly?

msolovyov

Any ideas on how to access data returned by a query from the dataset in a chart script?

Virgil Dodson

This post should help <a class='bbc_url' href='http://www.birt-exchange.com/forum/designing-birt-reports/12847-how-draw-dynamic-marker.html'>http://www.birt-exchange.com/forum/designing-birt-reports/12847-how-draw-dynamic-marker.html</a>

msolovyov

Thanks, I found your post earlier today at <a class='bbc_url' href='http://www.birt-exchange.com/blog/2008-02-01/birt-chart-scripting-dynamic-markers/'>BIRT Chart Scripting: Dynamic Markers » Blog - BIRT Exchange</a> 
 
it helped a lot, it works now. 
 
the final onrender script for the chart looks like this: function beforeGeneration(chart, icsc) 
{ 
importPackage( Packages.org.eclipse.birt.chart.model.data.impl ); 
importPackage(Packages.org.eclipse.birt.chart.model.component.impl); 
 
importPackage(Packages.org.eclipse.birt.chart.model.attribute); 
importPackage(Packages.org.eclipse.birt.chart.model.attribute.impl); 
var chart = icsc.getChartInstance(); 
var trunkVar = icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("trunk"); 
xAxis = chart.getBaseAxes()[0]; 
 
yAxis1 = chart.getOrthogonalAxes( xAxis, true)[0] 
yscale1 = yAxis1.getScale(); 
yscale1.setMin( NumberDataElementImpl.create(0) ); 
yscale1.setMax(NumberDataElementImpl.create(trunkVar) ); 
yAxis1.setScale(yscale1); //yscale1 
 
 
} 
 
 
I had to create a table from the data set and then make a script in it for the set global variable statement. Have to figure out how to make the chart hidden now. Thanks so much for your article. I wish there was a big book on birt scripting.