纵向分栏

【问题】

Hi i have a single list of employees. Each employee will have his name and salary.

i have given the list of employees to a table but it appears as follows

Employee Name      Salary 
harish        3000
kiran         4000
Emili         6000
harsha        7000
vardhana      8000
siri          9000

i mean each employee details appears in a single row . but i want them to appear side by side on the same page as shown below.

Employee Name     Salary         Employee Name        Salary
harish            3000           harsha               7000
kiran             4000           vardhana             8000
Emili             6000           siri                 9000

----- 技术支持给的解法：代码实现

on table one filtering, the following code is written
pageBreakInterval=21;
blockNumber=Math.floor(row.__rownum/ pageBreakInterval)+1;
totalColumns=3;
columnNumber=1;
((blockNumber- columnNumber)>=0)&&(((blockNumber- columnNumber)% totalColumns)==0)
on table-2 filter the following code is written
pageBreakInterval=21;
blockNumber=Math.floor(row.__rownum/ pageBreakInterval)+1;
totalColumns=3;
columnNumber=2;
((blockNumber- columnNumber)>=0)&&(((blockNumber- columnNumber)% totalColumns)==0)
on table-3 filter the following code is written
pageBreakInterval=21;
blockNumber=Math.floor(row.__rownum/ pageBreakInterval)+1;
totalColumns=3;
columnNumber=3;
((blockNumber- columnNumber)>=0)&&(((blockNumber- columnNumber)% totalColumns)==0)

hi with the above code in 3 table filters i guess the first table will be filled with first 21 records and the next 21 records will be filled in the second table and the next to next 21 records will be filled in the third table. Is this right?

【回答】

BIRT 有分栏打印的功能，具体在 master page 标签页的 columns 属性，可以试一下。如果这种方法无效，则可以用 SPL 准备好已分栏后的数据，然后作为不分栏的表呈现即可，可以通用地解决这个问题：

	A
1	=demo.query(“select orderID,customer from orders”)
2	=create(${Col.((t=~,A1.fname().(~ +string(t)))).conj().concat@c()})
3	>Row.run(A2.record(A1.m(to(Col*( ~ -1)+1,Col*~ )).conj(~.array()))

运行结果：

A1：查找数据

A2：创建表，并根据参数 Col 设置分栏数目

A3：将源数据按参数 Row，每 Row 行分成一组，拼成 Col 列生成新数据集

BIRT 可以通过 JDBC 连接集算器，调用脚本方法和调用存储过程一样，详情参考【BIRT 调用 SPL 脚本​】。