缺少数据（JasperReports Server报告） [英] Missing data (JasperReports Server reports)

问题描述

好的，当我在 iReport 中运行我的报告时，我只获得一行作为输出

Ok so when I run my report in iReport I only get one row as output

100 100 -   BA  -   7294    -   1   -   3

但是当我复制报告创建的查询时服务器日志并运行它我得到80行作为输出

But when I copy the query created by the report out of the server logs and run it I get 80 rows as output

100 100 -   BA  -   7294    -   1   -   3
100 101 -   BA  -   7294    -   1   -   3
100 102 -   BA  -   7294    -   1   -   3
100 103 -   BA  -   7294    -   1   -   3
100 104 -   BA  -   7294    -   1   -   3
100 106 -   BA  -   7294    -   1   -   3
100 107 -   BA  -   7294    -   1   -   3
100 108 -   BA  -   7294    -   1   -   3
100 109 -   BA  -   7294    -   1   -   3
100 110 -   BA  -   7294    -   1   -   3
etc...

我已经完成了这类报告一百次这种情况从未发生过，我似乎无法找到解决方案

I have done these kinds of reports a hundred times and this has never happened and I can't seem to find a solution

造成这种失踪的原因是什么？数据？

What can be the cause of this missing data ?

这是我从日志中复制的查询（这是一个简单的查询，没什么特别的）

Here is the query I copied from the logs (Its a simple query, nothing fancy)

select 
`quallev_qualificationlevel`.`quallev_fieldofstudy` as 
`quallev_qualificationlevel_quallev_fieldofstudy`,
`qde_qualificationdescription`.`qde_shortdescription` as `qde_qualificationdescription_qde_shortdescription`,
`qde_qualificationdescription`.`qde_namepurpose_cd_id` as `qde_qualificationdescription_qde_namepurpose_cd_id`,
`cn_campusname`.`cn_campusid` as `cn_campusname_cn_campusid`,
`qde_qualificationdescription`.`qde_langauge_id` as `qde_qualificationdescription_qde_langauge_id`,
`fv_factorvalue_ft`.`fv_1` as `fv_factorvalue_ft_fv_1`,
`fv_factorvalue_ft`.`fv_2` as `fv_factorvalue_ft_fv_2`,
`fv_factorvalue_ft`.`fv_3` as `fv_factorvalue_ft_fv_3`,
`fosfte_fieldofstudyftefactor`.`fosfte_factor_cd_id` as `fosfte_fieldofstudyftefactor_fosfte_factor_cd_id`,
`fv_factorvalue_ft`.`fv_4` as `fv_factorvalue_ft_fv_4`,
`fv_factorvalue_ft`.`fv_5` as `fv_factorvalue_ft_fv_5`,
`fv_factorvalue_ft`.`fv_6` as `fv_factorvalue_ft_fv_6`,
`fv_factorvalue_ft`.`fv_7` as `fv_factorvalue_ft_fv_7`,
`fv_factorvalue_ft`.`fv_8` as `fv_factorvalue_ft_fv_8`,
`fv_factorvalue_ft`.`fv_9` as `fv_factorvalue_ft_fv_9`,
`fos_fieldofstudy`.`fos_code` as `fos_fieldofstudy_fos_code`,
`fosfte_fieldofstudyftefactor`.`fosfte_ftefactorvalue` as `fosfte_fieldofstudyftefactor_fosfte_ftefactorvalue`,
`qual_qualification`.`qual_code` as `qual_qualification_qual_code`,
`oun_organisationunitname`.`oun_ou_id` as `oun_organisationunitname_oun_ou_id`,
`fos_fieldofstudy`.`fos_startdate` as `fos_fieldofstudy_fos_startdate`,
`qh_qualificationhemis`.`qh_weight` as `qh_qualificationhemis_qh_weight`
from `qo_qualificationorganisation`
inner join `quallev_qualificationlevel` on (`qo_qualificationorganisation`.`qo_quallev_id` = `quallev_qualificationlevel`.`quallev_id`)
inner join `org_organisation` on (`org_organisation`.`org_be_id` = `qo_qualificationorganisation`.`qo_org_be_id`)
inner join `oun_organisationunitname` on (`oun_organisationunitname`.`oun_ou_id` = `org_organisation`.`org_ou_id`)
inner join `cn_campusname` on (`org_organisation`.`org_campusid` = `cn_campusname`.`cn_campusid`)
inner join `fos_fieldofstudy` on (`quallev_qualificationlevel`.`quallev_fos_id` = `fos_fieldofstudy`.`fos_id`)
inner join `qual_qualification` on (`quallev_qualificationlevel`.`quallev_qual_id` =     `qual_qualification`.`qual_id`)
inner join `qh_qualificationhemis` on (`qh_qualificationhemis`.`qh_qual_id` = `qual_qualification`.`qual_id`)
inner join `fosfte_fieldofstudyftefactor` on (`fosfte_fieldofstudyftefactor`.`fosfte_fos_id` = `fos_fieldofstudy`.`fos_id`)
inner join `qde_qualificationdescription` on (`qde_qualificationdescription`.`qde_qual_id`     = `qual_qualification`.`qual_id`)
inner join `fv_factorvalue_ft` on (`fos_fieldofstudy`.`fos_id` = `fv_factorvalue_ft`.`fv_fos_id`)
where `qde_qualificationdescription`.`qde_langauge_id` = 3 
and `fos_fieldofstudy`.`fos_startdate` <= '2013-11-08' 
and `qde_qualificationdescription`.`qde_namepurpose_cd_id` = 7294 
and `cn_campusname`.`cn_campusid` = '1' 
and `oun_organisationunitname`.`oun_ou_id` = '11' 
and `fosfte_fieldofstudyftefactor`.`fosfte_factor_cd_id` = 7699
group by `quallev_qualificationlevel`.`quallev_fieldofstudy`

注意：我在 Win7 Pro 64位上为 JasperReports Server 5.0.1使用 iReport 5.0.0 on Tomcat 7

推荐答案

好的，所以我终于找到了解决方案

Ok so I finally found the solution

问题是jasperserver的默认行限制设置为200,000

The problem was jasperserver had a default row limit set of 200,000

我将这个限制提高到2,000,000和BOOOM！它现在有用:)

I raised that limmit to 2,000,000 and BOOOM !!! it works now :)

这篇关于缺少数据（JasperReports Server报告）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！