How to use a dataset result's field as title for a chart ?

estebi

Hello,

in fact everything is in the title, but here comes more explanations :

I have a dataset with a query inside. Every record contains a field "title" that has been prepared in the view and containing the exact title I want to put in my chart. Every record contains the same title.

What I don't know is :
-How to get the title value
-Where to put my script (beforeGeneration of the chart ?)

Thank you for your help

mwilliams

Hi Estebi,

You should be able to set a persistentGlobalVariable in your dataset's onFetch method by using something like:

reportContext.setPersistentGlobalVariable("charttitle", row["title"]);

Then, in the chart script, you use the beforeGeneration funtion like you mentioned and you get and set the title from you dataset by saying:

var ctitle = icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("charttitle"); //gets the global variable
chart.getTitle().getLabel().getCaption().setValue(ctitle); //sets the chart title

Hope this helps.