<p>I am currently working with the crosstab and am trying to manipulate the records for a cell. The summary functions available do not do what I need. One of my requirements is that if there are more than one record for a cell, I show all the values for a data field (instead of LAST or FIRST, which do work but don't do what I need).</p>
<p> </p>
<p>It doesn't look like I can add my own aggregation functions to a crosstab, so I have tried scripting a solution using the onCreate and onRender methods for a cell. I can swap out the text to be displayed (using showDataValue) but can't find any way to get at the actual data from the dataSet/row.</p>
<p> </p>
<p>I know the data must be somewhere, but querying the available objects in the scripting methods come back with either empty data bindings or empty rows. The data has to be there somewhere, I mean the FIRST and LAST functions clearly operate on it. But where it is, and how to get it, alludes me.</p>
<p> </p>
<p>Any help would be appreciated.</p>
<p> </p>
<p>Using Birt Report Designer: 4.3.2 </p>
