问题描述
我有一组数据以表格格式显示,使用jasper报告并且当前正在编写.jrxml文件。
I have a set to data to be shown in a tabular format using jasper report and currently writing the .jrxml file.
在我的数据集中,我有数据将使我们知道表的列数,从而使其成为表的动态列。
In my dataset, i have data which will serve us to know number of columns for the table, hereby making it dynamic columns for table.
因此,问题是从数据库获取的数据是特定于行的;那么我该如何才能将它转换为表格的列数呢?
So, the issue is Data fetched from database is row specific; so how can i make it work to convert it to no of columns for table?
我有一个dB表来从中提取数据:
I have a dB table from where data is pulled up:
TEST_ID LEVEL LOT_NUM MEAN UNITS PERCENT
--------- ------ -------- ------------- ----------- -------------
GLU 1 1212 2.1 10 22
GLU 2 1314 3.2 10 22
GLU 3 1414 3.3 10 22
我必须同样创建报告:
TEST_ID LEVEL:1 LEVEL:2 LEVEL:3 UNITS PERCENT
------- ------- ------- ------- ----- -------
GLU 2.1 3.2 3.3 10 22
- :LEVEL的数量变为特定测试的列数。
-: Number of LEVEL's becomes the number of columns for particular tests.
推荐答案
您的用例看起来像您的公司lumns只能在运行时识别。对于此类用例,您可以查看两个库中的任何一个 - 和。我已经看到动态jasper比动态报告更多的用法。
Your use case looks like your columns can only be identified at run time. For such use cases,you can look at either of two libraries - dynamic jasper and dynamic reports. I have seen more usage of dynamic jasper over dynamic reports though.
这篇关于如何在JRxml文件中创建动态列以生成jasper报告?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!