JasperServer: Remote XML Data Source as Parameter

[gkuehnberger]

Hello,

My target is to generate reports based on an external XML-Datasource, which should be handed over as parameter during runtime.

I've succeeded doing so with iReport, however fail to do so with Jasper-Server.

I understood that one could use a custom datasource, however I'm wondering wether this is really needed.

Anyone already solved the above task with or without a custom datasource, and how?

Thanks upfront
regards Georg
 

[gkuehnberger]

FYI I solved the above.
Apparently I misunderstood the queryexecuters logic a bit, and I especially stumbled upon jasperserver missing the xpath2 queryexector.

Anyway, as for reference, please find my solution below;
hth someone later on
regards Georg

### adding xpath2 query executer to jasperserver 3.5 without using a custom datasource

a) extended
/opt/jasperserver-3.5.0/apache-tomcat/webapps/jasperserver/WEB-INF/classes/jasperreports.properties
with
# addition for xpath2 queries
net.sf.jasperreports.query.executer.factory.xpath2=com.jaspersoft.jrx.query.JRXPathQueryExecuterFactory

b) copied jasperreports-extensions-3.5.3.jar (from iReport) to
/opt/jasperserver-3.5.0/apache-tomcat/webapps/jasperserver/WEB-INF/lib/jasperreports-extensions-3.5.3.jar

c) restarted jasperserver

d) within the main report I used something like:
<parameter name="p_xml_url" class="java.lang.String">
    <defaultValueExpression><![CDATA["http://mydomain/generate_xml.php"]]></defaultValueExpression>
</parameter>
<parameter name="XML_URL" class="java.lang.String" isForPrompting="false">
    <defaultValueExpression><![CDATA[$P{p_xml_url}]]></defaultValueExpression>
</parameter>
 

[stopbugginme]

 Could you please share the entire report, please. 

Thank's a lot

[sambathkumar]

Hi,

I stuck on creating the ireport with the query executor, could you please let me know the steps? Please let me know if you have any sample report.

 

Thanks Sambath

[spetty]

I was able to create a report in iReport and it runs fine. When I try to run the report on the JasperServer it returns "No Pages Found". I am running 3.7.5.