<p>I'm working on a project to develop a report wrapper that leverages BIRT's Java API as the underlying generation tool. The underlying queries in the report sometimes result in datasets holding data that is not always displayed in the same manner (or at all) when output. For example, i might get a row that looks like:</p>
<p> </p>
<p>"2014-01-01";"2014-01-14";"653443118056";"1";"$3 CROSSWORD TICKET";189;538.650;567.00;0.0500<br><br>
While the display output of the row is:<br><br>
$3 CROSSWORD TICKET 653443118056-1 198 $564.30 $594.00 $29.70 5.00%</p>
<p> </p>
<p>In the generated output, no dates are displayed in the row and two result set columns are concatenated into a single display column. <br><br>
One of the project specs is the ability to export to CSV with accurate header information. Unfortunately, the display headers are complex with nested rows and columns (and there may be more headers than columns), so the headers generated by the emitter do not properly align with the data fields.<br><br>
I have managed to retrieve the database column names by obtaining a CachedMetaDataHandle and iterating the columns, but this seems to only contain the database columns name. What (i think) i need is to programmatically retrieve the metadata used to bind the result set to the display table prior to output. When i try Google, i find lots of information about obtainingg the mapping data using the JavaScript API, but not so much about using the Java API. Can it be done using just the Java API? If so, how? If not, is there some kind of workaround other than creating the mappings for each report manually?<br><br>
</p>
