Report with XPath configured not working. Help!?

[bernardopina]

Hey guys,

I have a servlet that receives two parameters: Report Name (example.jrxml) and a xml (on text, not on a file). The servlet have to return a compiled report on .pdf extension.

The problem is that i am configuring the XPath within the .jrxml, but the report is not being generated correctly. The report is generated only with the first node of three of the XML.

See the files attached for more info.

Any clue? Thanks!

Post Edited by bernardopina at 05/03/2010 19:37

[pablodc]

Hi,

    The fields XPath expressions are wrong. You have:

 

    <field name="nome" class="java.lang.String">
        <fieldDescription><![CDATA[/funcionarios/funcionario/nome]]></fieldDescription>
    </field>
    <field name="matricula" class="java.lang.String">
        <fieldDescription><![CDATA[/funcionarios/funcionario/matricula]]></fieldDescription>
    </field>
    <field name="cargo" class="java.lang.String">
        <fieldDescription><![CDATA[/funcionarios/funcionario/cargo]]></fieldDescription>
    </field>

     Try with:

    <field name="nome" class="java.lang.String">
        <fieldDescription><![CDATA[nome]]></fieldDescription>
    </field>
    <field name="matricula" class="java.lang.String">
        <fieldDescription><![CDATA[matricula]]></fieldDescription>
    </field>
    <field name="cargo" class="java.lang.String">
        <fieldDescription><![CDATA[cargo]]></fieldDescription>
    </field>

    You can change the fields XPath from its properties in the IDE.

Good luck!

grettings from Argentina!

 

 

[bernardopina]

 Unfortunately i have already tried that with no success. When i do what you said, i just got "null" on every field, and still just one register instead of 3. =/

[lucianc]

When you have an XPath query in the report, you should fill the report by passing a org.w3c.dom.Document value for the JRXPathQueryExecuterFactory.PARAMETER_XML_DATA_DOCUMENT parameter, as below.

Is that what you are doing?

Regards,

Lucian

Code:

parameters.put(JRXPathQueryExecuterFactory.PARAMETER_XML_DATA_DOCUMENT, JRXmlUtils.parse(xmlFile));JasperPrint print = JasperFillManager.fillReport(report, parameters);

[bernardopina]

 I made this with still no success:

Code:

HashMap parameters = new HashMap();			JasperDesign jasperDesign = JRXmlLoader.load(xmlString);			JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);			parameters.put(JRXPathQueryExecuterFactory.PARAMETER_XML_DATA_DOCUMENT, JRXmlUtils.parse(xmlString));			print = JasperFillManager.fillReport(jasperReport, parameters, ds);

[lucianc]

Don't pass a data source when you have a query in the report.

HTH,

Lucian

[bernardopina]

 I have already tried to remove the DataSource from the call, and the code became this:

print = JasperFillManager.fillReport(jasperReport, parameters);

 

The problem is... With that change, i get a blank report, with no info (static or dinamic).

[lucianc]

JRXmlUtils.parse(String) takes a string URI as argument.

If you want to parse an XML string, do JRXmlUtils.parse(new ByteArrayInputStream(xmlString.getBytes("UTF-8")))

[bernardopina]

About 5 minutes ago i solved the puzzle...

The problem was that when i did not receive the xpath as a parameter on the servlet, there were no report path seted on the DataSource. All i did was to get the report path from the .jrxml with the line above and set it on the DataSource.

The code became this, and now it works perfectly.

Thanks A LOT for all the help. =)

Code:

		InputStream inRegistry = (InputStream) new ByteArrayInputStream(xmlRegistry.getBytes());		JasperDesign jasperDesign = JRXmlLoader.load(template);		JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);		JRXmlDataSource ds = null;		if(xPath != null && !xPath.equals("")) {			ds = new JRXmlDataSource(inRegistry,xPath);		} else {			ds = new JRXmlDataSource(inRegistry,jasperReport.getQuery().getText());		}				JasperPrint print = JasperFillManager.fillReport(jasperReport, null, ds);		return print;