how to put more than one query (querys) in an ireport?

1

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>

    
asked by ingswsm 23.01.2017 в 18:26
source

1 answer

1

You can not put more than one datasource in each report. If you need another query you will have to create a subreport and add your query there.

    
answered by 24.01.2017 в 17:20