details:   https://code.openbravo.com/erp/devel/pi/rev/e1200e4d3eb9
changeset: 15521:e1200e4d3eb9
user:      David Miguelez <david.miguelez <at> openbravo.com>
date:      Fri Feb 17 12:37:10 2012 +0100
summary:   Fixes issue 0019800: It does not print more than one requisition.

diffstat:

 src/org/openbravo/erpReports/RptM_Requisition.java  |  2 +-
 src/org/openbravo/erpReports/RptM_Requisition.jrxml |  9 ++++++---
 2 files changed, 7 insertions(+), 4 deletions(-)

diffs (40 lines):

diff -r 6409589a6ef9 -r e1200e4d3eb9 
src/org/openbravo/erpReports/RptM_Requisition.java
--- a/src/org/openbravo/erpReports/RptM_Requisition.java        Fri Feb 17 
11:34:33 2012 +0100
+++ b/src/org/openbravo/erpReports/RptM_Requisition.java        Fri Feb 17 
12:37:10 2012 +0100
@@ -74,7 +74,7 @@
       e.printStackTrace();
       throw new ServletException(e.getMessage());
     }
-    strmRequisitionId = strmRequisitionId.replaceAll("\\(|\\)|'", "");
+
     parameters.put("SR_LINES", jasperReportLines);
     parameters.put("REQUISITION_ID", strmRequisitionId);
     renderJR(vars, response, null, "pdf", parameters, null, null);
diff -r 6409589a6ef9 -r e1200e4d3eb9 
src/org/openbravo/erpReports/RptM_Requisition.jrxml
--- a/src/org/openbravo/erpReports/RptM_Requisition.jrxml       Fri Feb 17 
11:34:33 2012 +0100
+++ b/src/org/openbravo/erpReports/RptM_Requisition.jrxml       Fri Feb 17 
12:37:10 2012 +0100
@@ -2,6 +2,9 @@
 <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="RptM_Requisition" pageWidth="595" pageHeight="842" columnWidth="483" 
leftMargin="56" rightMargin="56" topMargin="56" bottomMargin="56">
        <property name="ireport.scriptlethandling" value="0"/>
        <property name="ireport.encoding" value="UTF-8"/>
+       <property name="ireport.zoom" value="1.0"/>
+       <property name="ireport.x" value="0"/>
+       <property name="ireport.y" value="0"/>
        <import value="net.sf.jasperreports.engine.*"/>
        <import value="java.util.*"/>
        <import value="net.sf.jasperreports.engine.data.*"/>
@@ -59,11 +62,11 @@
                
<defaultValueExpression><![CDATA["en_US"]]></defaultValueExpression>
        </parameter>
        <queryString>
-               <![CDATA[SELECT M_REQUISITION.M_REQUISITION_ID, 
M_REQUISITION.DOCUMENTNO, 
-       AD_COLUMN_IDENTIFIER(to_char('AD_User'), 
to_char(M_REQUISITION.AD_USER_ID), $P{LANGUAGE}) AS REQUESTER, 
+               <![CDATA[SELECT M_REQUISITION.M_REQUISITION_ID, 
M_REQUISITION.DOCUMENTNO,
+       AD_COLUMN_IDENTIFIER(to_char('AD_User'), 
to_char(M_REQUISITION.AD_USER_ID), $P{LANGUAGE}) AS REQUESTER,
        REPLACE(M_REQUISITION.DESCRIPTION, CHR(10), '') AS DESCRIPTION
        FROM M_REQUISITION
-       WHERE M_REQUISITION.M_REQUISITION_ID IN ($P{REQUISITION_ID})]]>
+       WHERE M_REQUISITION.M_REQUISITION_ID IN $P!{REQUISITION_ID}]]>
        </queryString>
        <field name="M_REQUISITION_ID" class="java.lang.String">
                <fieldDescription><![CDATA[]]></fieldDescription>

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to