Jackeline161 Posted July 4, 2013 Share Posted July 4, 2013 Hello everybody , Please i have a problem with ireport designer, i want to edit my file xml in order to have a parameter with my sql query string, i have to pass the entiere query but it dosen't work . My jasper file is like this: <?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="report1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e50b86b1-ec0c-42dd-b31d-f2dedc5e3495"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="3"/><parameter name="dynamicQuery" class="java.lang.String"/> <querystring language="SQL"> <![CDATA[&P{dynamicQuery}]]> </querystring> <field class="java.lang.String" name="DUMMY"></field><variable name="titre" class="java.lang.String"/><background><band splitType="Stretch"/></background><title><band height="79" splitType="Stretch"><textField><reportElement uuid="bfdeca90-6237-40f6-9230-e63fb625786b" x="218" y="23" width="100" height="20"/><textElement/><textFieldExpression><![CDATA[$V{titre}]]></textFieldExpression></textField></band></title><pageHeader><band height="35" splitType="Stretch"><textField pattern="EEEEE dd MMMMM yyyy"><reportElement uuid="e5be40f6-b301-4c68-84ab-d64cf3f73e49" x="0" y="0" width="108" height="35"/><textElement/><textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression></textField></band></pageHeader><columnHeader><band height="61" splitType="Stretch"/></columnHeader><detail><band height="125" splitType="Stretch"/></detail><columnFooter><band height="45" splitType="Stretch"/></columnFooter><pageFooter><band height="54" splitType="Stretch"/></pageFooter><summary><band height="42" splitType="Stretch"><textField><reportElement uuid="33dac024-0bd8-4e6b-9849-4c74839ac0f1" x="438" y="42" width="117" height="20"/><textElement/><textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression></textField></band></summary></jasperReport>It gives me the bellow problem :Error loading the report template: org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'querystring'. One of '{"http://jasperreports.sourceforge.net/jasperreports":parameter, "http://jasperreports.sourceforge.net/jasperreports":queryString, "http://jasperreports.sourceforge.net/jasperreports":field, "http://jasperreports.sourceforge.net/jasperreports":sortField, "http://jasperreports.sourceforge.net/jasperreports":variable, "http://jasperreports.sourceforge.net/jasperreports":filterExpression, "http://jasperreports.sourceforge.net/jasperreports":group, "http://jasperreports.sourceforge.net/jasperreports":background, "http://jasperreports.sourceforge.net/jasperreports":title, "http://jasperreports.sourceforge.net/jasperreports":pageHeader, "http://jasperreports.sourceforge.net/jasperreports":columnHeader, "http://jasperreports.sourceforge.net/jasperreports":detail, "http://jasperreports.sourceforge.net/jasperreports":columnFooter, "http://jasperreports.sourceforge.net/jasperreports":pageFooter, "http://jasperreports.sourceforge.net/jasperreports":lastPageFooter, "http://jasperreports.sourceforge.net/jasperreports":summary, "http://jasperreports.sourceforge.net/jasperreports":noData}' is expected. Please i need ur help !! Thank you very much Link to comment Share on other sites More sharing options...
rsuddhala Posted July 5, 2013 Share Posted July 5, 2013 Hi ,I think you just change your querystring as below<queryString> <![CDATA[P{dynamicQuery}]]> </queryString> Link to comment Share on other sites More sharing options...
Jackeline161 Posted July 5, 2013 Author Share Posted July 5, 2013 It doesn't work , i think that the problem is from the order of tags but I don't know how to resolve it .. Link to comment Share on other sites More sharing options...
rsuddhala Posted July 5, 2013 Share Posted July 5, 2013 Hi I have removed some tags and get the out put check the below code .. <?xml version="1.0" encoding="UTF-8"?> P{dynamicQuery} Link to comment Share on other sites More sharing options...
Jackeline161 Posted July 5, 2013 Author Share Posted July 5, 2013 It works !! Thak youu very very much rsuddhala :) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now