Eclipse Community Forums: BIRT » how-to-get-a-x-axis-label-value-by-parameter-in-bar-chart

Help

Home

Home » Archived » BIRT » how-to-get-a-x-axis-label-value-by-parameter-in-bar-chart

Show: Today's Messages :: Show Polls :: Message Navigator

how-to-get-a-x-axis-label-value-by-parameter-in-bar-chart [message #1059072]

Thu, 16 May 2013 14:05

4040 4040

Messages: 78
Registered: February 2013

Member

here i attached is a model example ...
like wise

my requirement

function beforeGeneration(chart, icsc)

{
importPackage( Packages.org.eclipse.birt.chart.model.attribute.impl );
importPackage( Packages.org.eclipse.birt.chart.model.attribute );
xAxis = chart.getBaseAxes()[0];

if ( xAxis.getType() == AxisType.TEXT_LITERAL){
var groupparm = icsc.getExternalContext().getScriptable().getParameterValue("geography");
if( groupparm == "zone")
{
xAxis.?( ?.create("?") );
}
else if( groupparm == "state" )
{
xAxis.?( ?.create("?") );
}
else if( groupparm == "city" )
{
xAxis.?( ?.create("?") );
}

}

like wise i have one table in that many columns are there zone,state,city,...its go on
so now my doubt is
for example:

if i click option "zone" in list box i have get value in bar chart south,west,east,north in x-axis and corresponding net sale in y axis....

if i click option "state" in list box i have get value in bar chart tamilnadu,kerala,chennai, in x-axis and corresponding net sale in y axis....

can u create a sample report for this....

how to change chart query based on the selection and make the column names generic

its urgent requirement