尽管查询有效，但Jasper iReport表返回一个空文档 [英] Jasper iReport table returns an empty document although query works
问题描述
我正在尝试使用Jasper iReport 4.5创建一个报告，我正在使用一个表来显示一些数据。该表由查询填充，当我在查询编辑器中检查查询的预览时，我得到了我想要的结果。
但是当我尝试创建报告的预览时，我得到的只是文档没有页面。甚至不显示表头中的静态文本。
I'm trying to create a report with Jasper iReport 4.5 and I'm using a table to show some of the data. The table is filled by a query, and when I check the preview of the query in the Query Editor, I get exactly the results that I wanted. But when I try to create the preview of the report, all I get is "The document has no pages". Not even the static text in the table header is displayed.
以下是报告的XML，但没有查询：
Here is the XML of the report, but without the query:
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="subReportTextManualCustomerRating" pageWidth="500" pageHeight="842" columnWidth="460" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="1.4641000000000008"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<style name="table">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TH" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_CH" mode="Opaque" backcolor="#FFBFBF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="CustomerType">
<parameter name="TEXT_MANUAL_OID" class="java.lang.String"/>
<queryString>
</queryString>
<field name="Anzahl" class="java.lang.Long"/>
<field name="Typ" class="java.lang.String"/>
<field name="Bezeichnung" class="java.lang.String"/>
</subDataset>
<parameter name="TEXT_MANUAL_OID" class="java.lang.String"/>
<queryString>
<![CDATA[]]>
</queryString>
<summary>
<band height="143">
<componentElement>
<reportElement key="table 1" style="table 1" x="0" y="0" width="460" height="143"/>
<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
<datasetRun subDataset="CustomerType">
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:column width="90">
<jr:tableHeader style="table 1_TH" height="30">
<staticText>
<reportElement x="0" y="0" width="90" height="30"/>
<textElement/>
<text><![CDATA[Kontakt Typen]]></text>
</staticText>
</jr:tableHeader>
<jr:detailCell style="table 1_TD" height="20">
<textField>
<reportElement x="0" y="0" width="90" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{Typ}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="90">
<jr:tableHeader style="table 1_TH" height="30">
<staticText>
<reportElement x="0" y="0" width="90" height="30"/>
<textElement/>
<text><![CDATA[Ergebniserklärung]]></text>
</staticText>
</jr:tableHeader>
<jr:detailCell style="table 1_TD" height="20">
<textField>
<reportElement x="0" y="0" width="90" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{Bezeichnung}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="90">
<jr:tableHeader style="table 1_TH" height="30">
<staticText>
<reportElement x="0" y="0" width="90" height="30"/>
<textElement/>
<text><![CDATA[Anzahl der Kontakte]]></text>
</staticText>
</jr:tableHeader>
<jr:detailCell style="table 1_TD" height="20">
<textField>
<reportElement x="0" y="0" width="90" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{Anzahl}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:table>
</componentElement>
</band>
</summary>
</jasperReport>
推荐答案
好的，我刚刚发现它是什么。我不得不为主报告创建一个查询，即使我在本报告的任何地方都没有使用它。所以我只是将select 1 as dummy_field添加为主报表的查询，现在该表显示了我想要的数据。
Ok, I just found out what it was. I had to create a query for the main report, even though I dont use it anywhere in this report. So I just added "select 1 as dummy_field" as query for the main report, and now the table shows the data I want.
这篇关于尽管查询有效，但Jasper iReport表返回一个空文档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
