How to deal with the problem of horizontal column separation by BIRT

This article mainly explains "BIRT how to deal with horizontal column problem", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's train of thought slowly in depth, together to study and learn "BIRT how to deal with horizontal column problem" bar!

For example, to deal with a scenario in which the data records are arranged horizontally into three columns. The effect picture is as follows:

BIRT can divide the data into vertical columns, but it is difficult to realize the layout of horizontal placement and column division of records. Some netizens have proposed: bind the dataset to List elements, arrange one or more data fields in the grid, and use means such as embedding subgrids to achieve, but they all belong to the theoretical stage and do not give complete examples. It is conceivable that even if it can be realized, it is necessary to write complex scripts and messy grid stitching. The workload is huge. The source data format is as follows:

Some special layout, it is difficult to directly achieve through the functions provided by the report tool itself, but if you prepare a suitable data source, you can greatly reduce the difficulty of report design, aggregator SPL can assist BIRT to prepare the data that has been divided into columns, BIRT just receives the processed data and shows it. The code is as follows:

A

B

C

one

= myDB.query ("select EId,Name,Dept from emp where EId > =? and EId