hi everyone I have a problem nose how to insert a query more, in my ireport when I try to enter a query in this way
<queryString>............</queryString>
I get error, I stress that I already have a query that works but when I want to insert one more it is where I get error I think I'm doing it wrong I hope your help thanks
I leave the code that works, where I have to put the new query or how I can put more than one query thanks
<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="report name" columnCount="2" printOrder="Horizontal" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="420" columnSpacing="2" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA["D:\Pits02\PitsErp\src\m_rpt_imp_img\"]]></defaultValueExpression>
</parameter>
<parameter name="id_usuario" class="java.lang.String"/>
<parameter name="id_ip" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT ruta_img,serie,orden,correlativo from tab_temp_impresion_img WHERE usuario=$P{id_usuario} and ip_pc=$P{id_ip}]]>
</queryString>
<field name="ruta_img" class="java.lang.String"/>
<field name="serie" class="java.lang.String"/>
<field name="orden" class="java.lang.String"/>
<field name="correlativo" class="java.lang.String"/>
<columnHeader>
<band/>
</columnHeader>
<detail>
<band height="198">
<image scaleImage="RealSize" isLazy="true">
<reportElement stretchType="RelativeToBandHeight" x="9" y="14" width="410" height="182"/>
<imageExpression class="java.lang.String"><![CDATA[$F{ruta_img}]]></imageExpression>
</image>
<textField>
<reportElement x="9" y="14" width="298" height="13"/>
<textElement verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{serie}+'-'+$F{orden}+'-'+$F{correlativo}]]></textFieldExpression>
</textField>
</band>
</detail>