Another way to implement a field split into a table in Birt

Source: http://developer.actuate.com/community/forum/index.php?/topic/36204-split-data-row/.

Splitting a field into multiple records can be accomplished with a stored procedure or report script, but the code is more complex, in which case you can use the collector to aid the reporting tool, as illustrated below.

Library table data has two fields, and you need to split the Anomoalies field into multiple strings by space, each string and the original ID field to form a new record. The source data is as follows:

The Collector code:

A1: Querying the database.

A2: Splits the anomalies field to form a new two-dimensional table. The function Conj can merge the results of each member in the A1. "~" represents the current member in the collection. The results are as follows:

A3: Returns the result of the calculation to the report tool. The collector provides the JDBC interface externally, and the report tool recognizes the collector as a normal database.

The following is a simple list table designed with Birt:

preview:

The report calls the collector the same way you call a stored procedure, such as saving this script as BIRTSPLITROW.DFX, and you can invoke and enter parameters with call Birtsplitrow () in the Birt stored procedure designer.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Another way to implement a field split into a table in Birt