Can not edit xml file when adding entire dynamic query

[Jackeline161]

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

[rsuddhala]

Hi ,

I think you just change your querystring as below

<queryString>
        <![CDATA[P{dynamicQuery}]]>
    </queryString>

[Jackeline161]

It doesn't work , i think that the problem is from the order of tags but I don't know how to resolve it ..

[rsuddhala]

Hi I have removed some tags and get the out put check the below code ..

 

<?xml version="1.0" encoding="UTF-8"?>

P{dynamicQuery}

 

 

 

 

 

 

 

 

 

[Jackeline161]

It works !! Thak youu very very much rsuddhala :)