Jaspererports iReport：在出口时将报告分成几个excel表 [英] Jaspererports iReport: split report into several excel sheets on export

问题描述

我有一个使用iReport设计器创建的报告。该报告包含3个数据集和3个表，这些表填充了这些数据集中的数据。每张桌子都位于细节带中。我们的企业主希望这些3个表在excel导出时显示在3个不同的Excel工作表上。我已经检查了几个教程和帖子，但它们似乎都不适合我。需要帮助！提前致谢！

I have a report which I created using iReport designer. The report contains 3 datasets and 3 tables, which get filled with data from those datasets. Each table is located in detail band. Our business owner wants these 3 tables to be displayed on 3 different excel sheets upon excel export. I have checked several tutorials and posts, but none of them seems to work for me. Help needed! Thanks in advance!

推荐答案

在每张表后添加 pagebreak ，然后设置物业

add pagebreak after each table, then set property

net.sf.jasperreports.export.xls.one.page.per.sheet to true

喜欢这个

<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/>

更多参考访问这个页面

这篇关于Jaspererports iReport：在出口时将报告分成几个excel表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！