纵向分栏
【问题】
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 脚本】。
