Jump to content
Changes to the Jaspersoft community edition download ×

data fields not coming in the table when connected with xml datasource in ireport 4.6.0


heenas

Recommended Posts

hi,

i am creating a report in ireport 4.6.0 .The report is showing the null fields instead of taking values from xml file.please help me out with this.

 

I am aatching the

1)xml file of the report

2)the aml file used as a datasource

3)pdf that is generated in the end

Code:
<?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="report21" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ff9f90d4-2f61-498b-af9d-7b4889650185">	<property name="ireport.zoom" value="1.0"/>	<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>	<subDataset name="testdataset" uuid="755ff0b4-3dd2-4588-a2b0-e72e786f471e">		<queryString language="xPath">			<![CDATA[/order/orderhead]]>		</queryString>		<field name="customer" class="java.lang.String">			<fieldDescription><![CDATA[customer]]></fieldDescription>		</field>		<field name="ref" class="java.lang.String">			<fieldDescription><![CDATA[ref]]></fieldDescription>		</field>		<field name="deliveryDate" class="java.lang.String">			<fieldDescription><![CDATA[deliveryDate]]></fieldDescription>		</field>	</subDataset>	<queryString language="xPath">		<![CDATA[/order/orderhead]]>	</queryString>	<field name="customer" class="java.lang.String">		<fieldDescription><![CDATA[customer]]></fieldDescription>	</field>	<field name="ref" class="java.lang.String">		<fieldDescription><![CDATA[ref]]></fieldDescription>	</field>	<field name="deliveryDate" class="java.lang.String">		<fieldDescription><![CDATA[deliveryDate]]></fieldDescription>	</field>	<background>		<band splitType="Stretch"/>	</background>	<title>		<band height="79" splitType="Stretch"/>	</title>	<pageHeader>		<band height="35" splitType="Stretch"/>	</pageHeader>	<columnHeader>		<band height="61" splitType="Stretch"/>	</columnHeader>	<detail>		<band height="125" splitType="Stretch">			<componentElement>				<reportElement uuid="e276b75d-d767-4638-99a3-39d5c28acc7b" key="table" style="table" x="0" y="0" width="555" height="125"/>				<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="testdataset" uuid="193cbcaa-a9f8-4aff-b5f5-e308ed2ccfa1">						<dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.JREmptyDataSource(1)]]></dataSourceExpression>					</datasetRun>					<jr:column uuid="0724c815-5152-4ce3-b86d-481e71fb4912" width="90">						<jr:tableHeader style="table_TH" height="30"/>						<jr:tableFooter style="table_TH" height="30"/>						<jr:columnHeader style="table_CH" height="30">							<staticText>								<reportElement uuid="0ab5f051-88c1-4418-972a-262b3f500e57" x="0" y="0" width="90" height="30"/>								<textElement/>								<text><![CDATA[customer]]></text>							</staticText>						</jr:columnHeader>						<jr:columnFooter style="table_CH" height="30"/>						<jr:detailCell style="table_TD" height="20">							<textField>								<reportElement uuid="dbbee7df-d153-4220-8dd9-ae863c35c56a" x="0" y="0" width="90" height="20"/>								<textElement/>								<textFieldExpression><![CDATA[$F{customer}]]></textFieldExpression>							</textField>						</jr:detailCell>					</jr:column>					<jr:column uuid="da412d83-d85e-4f0f-8a45-6d49a8228d10" width="90">						<jr:tableHeader style="table_TH" height="30"/>						<jr:tableFooter style="table_TH" height="30"/>						<jr:columnHeader style="table_CH" height="30">							<staticText>								<reportElement uuid="ef851731-6898-496b-9034-17d05944dc69" x="0" y="0" width="90" height="30"/>								<textElement/>								<text><![CDATA[ref]]></text>							</staticText>						</jr:columnHeader>						<jr:columnFooter style="table_CH" height="30"/>						<jr:detailCell style="table_TD" height="20">							<textField>								<reportElement uuid="9faba008-9caf-4aeb-ae34-1edd2f32c2df" x="0" y="0" width="90" height="20"/>								<textElement/>								<textFieldExpression><![CDATA[$F{ref}]]></textFieldExpression>							</textField>						</jr:detailCell>					</jr:column>					<jr:column uuid="66ec4252-7bd9-42ef-9668-da6d8b0fc70f" width="90">						<jr:tableHeader style="table_TH" height="30"/>						<jr:tableFooter style="table_TH" height="30"/>						<jr:columnHeader style="table_CH" height="30">							<staticText>								<reportElement uuid="ca3ce4b0-1883-47da-a568-5c8250fdc6cf" x="0" y="0" width="90" height="30"/>								<textElement/>								<text><![CDATA[deliveryDate]]></text>							</staticText>						</jr:columnHeader>						<jr:columnFooter style="table_CH" height="30"/>						<jr:detailCell style="table_TD" height="20">							<textField>								<reportElement uuid="c535d87d-82fc-4199-b32b-c3ebfa9b116f" x="0" y="0" width="90" height="20"/>								<textElement/>								<textFieldExpression><![CDATA[$F{deliveryDate}]]></textFieldExpression>							</textField>						</jr:detailCell>					</jr:column>				</jr:table>			</componentElement>		</band>	</detail>	<columnFooter>		<band height="45" splitType="Stretch"/>	</columnFooter>	<pageFooter>		<band height="54" splitType="Stretch"/>	</pageFooter>	<summary>		<band height="42" splitType="Stretch"/>	</summary></jasperReport>
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...