<p>So I found this script here <a data-ipb='nomediaparse' href='
http://birtworld.blogspot.com/2010/02/birt-crosstab-scripting.html'>http://birtworld.blogspot.com/2010/02/birt-crosstab-scripting.html</a>that I think will do what I need it to do.</p>
<pre class="_prettyXprint _lang-">
function onCreateCell( cellInst, reportContext )
{
if( cellInst.getCellType() == "aggregation"){
//Can refernce value using getDataValue or
if( cellInst.getDataValue("PRODUCTLINE") == "Planes" ){
//set color to bluegray
cellInst.getStyle().setBackgroundColor("RGB(169,170,226)");
}
//by using reportContext.evaluate
//if( reportContext.evaluate("measure['amount']") > 50000 )
if( cellInst.getDataValue("amount_DateGroup/quarter_ProductGroup/PRODUCTLINE") > 50000 ){
cellInst.getStyle().setBackgroundColor("Green");
cellInst.getStyle().setColor("White");
}
}
}</pre>
<p>So now that I have this script what now? where do I place it and how do I tell birt that I want to use this script at the appropriate time(after the <span style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:15px;">design phase and before the report gets saved.)?</span></p>