Birt chart interaction to open detail of it

marcorossi · 2011-05-20T02:28:26+00:00

Hi and thanks for your time. I have to design a bar chart with Birt with a mininum of interaction on it. My dataset is the following: select id, score, hour from recording and on chart i have defined: <pre…

marcorossi

Hi and thanks for your time. 
 
I have to design a bar chart with Birt with a mininum of interaction on it. 
 
My dataset is the following: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>select id, score, hour from recording</pre>
 
and on chart i have defined: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
Y serie: row["score"]
X serie: row["hour"]</pre>
 
followin example on internet I've found that is possible to add some script on mouse click on Value(Y) Series, and I've defined this kind of script: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>ShowEventData(evt, categoryData, valueData, valueSeriesName, legendItemText, legendItemValue, axisLabel);
</pre>
where ShowEventData is on an hidden field below chart (and alert correctly): 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<script language="JavaScript">

function ShowEventData(evt, categoryData, valueData, valueSeriesName, legendItemText, legendItemValue, axisLabel) {

alert( "categoryData=" + categoryData +" valueData=" + valueData +" valueSeriesName=" + valueSeriesName+" legendItemText="+legendItemText+" legendItemValue="+legendItemValue+" axisLabel="+axisLabel);

}
</script></pre>
 
Now, finally the problem: How can I show on alert id from dataset? And use it to move weebapp navigation using this id? 
 
Thanks!

Find more posts tagged with

Comments

mwilliams

So, when you click on a bar in the chart, you want to be able to have access to the "id" data from the dataSet that is not in the chart? If so, you could always store this value in a persistentGlobalVariable named by another field in the dataSet that is in the table, if possible, and access it from within the chart script that way. Not sure if this will work in your situation or not unless hour or score is unique.