details: https://code.openbravo.com/erp/devel/pi/rev/c6772c713f93 changeset: 22129:c6772c713f93 user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com> date: Sun Feb 23 18:47:37 2014 +0530 summary: Fixes Issue 0025444: Payment terms label in invoice print template is not correctly shown when the text is long
diffstat: src/org/openbravo/erpReports/RptC_Invoice_new.jrxml | 967 +++++++++++++------ 1 files changed, 642 insertions(+), 325 deletions(-) diffs (truncated from 1091 to 300 lines): diff -r 58d87a1a0d0c -r c6772c713f93 src/org/openbravo/erpReports/RptC_Invoice_new.jrxml --- a/src/org/openbravo/erpReports/RptC_Invoice_new.jrxml Fri Feb 21 15:27:50 2014 +0000 +++ b/src/org/openbravo/erpReports/RptC_Invoice_new.jrxml Sun Feb 23 18:47:37 2014 +0530 @@ -1,70 +1,201 @@ -<?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="RptC_Invoice_new" 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="136"/> - <import value="net.sf.jasperreports.engine.*"/> - <import value="java.util.*"/> - <import value="net.sf.jasperreports.engine.data.*"/> - <style name="default" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="8"/> - <style name="Report_Title" fontName="Bitstream Vera Sans" fontSize="18"/> - <style name="Report_Subtitle" forecolor="#555555" fontName="Bitstream Vera Sans" fontSize="14"/> - <style name="Report_Data_Label" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/> - <style name="Report_Data_Field" fontName="Bitstream Vera Sans" fontSize="11" isBold="false"/> - <style name="Total_Field" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/> - <style name="GroupHeader_DarkGray" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="12" isBold="true"/> - <style name="Group_Data_Label" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/> - <style name="Group_Data_Field" fontName="Bitstream Vera Sans" fontSize="11"/> - <style name="Detail_Header" mode="Opaque" forecolor="#FFFFFF" backcolor="#5D5D5D" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="10" isBold="true"/> - <style name="Detail_Line" fontName="Bitstream Vera Sans" fontSize="8"> +<?xml version="1.0" encoding="UTF-8" ?> +<!-- Created with iReport - A designer for JasperReports --> +<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd";> +<jasperReport + name="RptC_Invoice_new" + columnCount="1" + printOrder="Vertical" + orientation="Portrait" + pageWidth="595" + pageHeight="842" + columnWidth="483" + columnSpacing="0" + leftMargin="56" + rightMargin="56" + topMargin="56" + bottomMargin="56" + whenNoDataType="NoPages" + isTitleNewPage="false" + isSummaryNewPage="false"> + <property name="ireport.zoom" value="1.0" /> + <property name="ireport.x" value="0" /> + <property name="ireport.y" value="136" /> + <property name="ireport.scriptlethandling" value="0" /> + <property name="ireport.encoding" value="UTF-8" /> + <import value="java.util.*" /> + <import value="net.sf.jasperreports.engine.*" /> + <import value="net.sf.jasperreports.engine.data.*" /> + + <style + name="default" + vAlign="Middle" + fontName="Bitstream Vera Sans" + fontSize="8" + > + </style> + <style + name="Report_Title" + fontName="Bitstream Vera Sans" + fontSize="18" + > + </style> + <style + name="Report_Subtitle" + forecolor="#555555" + fontName="Bitstream Vera Sans" + fontSize="14" + > + </style> + <style + name="Report_Data_Label" + fontName="Bitstream Vera Sans" + fontSize="11" + isBold="true" + > + </style> + <style + name="Report_Data_Field" + fontName="Bitstream Vera Sans" + fontSize="11" + isBold="false" + > + </style> + <style + name="Total_Field" + mode="Opaque" + forecolor="#000000" + backcolor="#CCCCCC" + vAlign="Middle" + fontName="Bitstream Vera Sans" + fontSize="11" + isBold="true" + > + </style> + <style + name="GroupHeader_DarkGray" + mode="Opaque" + forecolor="#FFFFFF" + backcolor="#555555" + vAlign="Middle" + fontName="Bitstream Vera Sans" + fontSize="12" + isBold="true" + > + </style> + <style + name="Group_Data_Label" + fontName="Bitstream Vera Sans" + fontSize="11" + isBold="true" + > + </style> + <style + name="Group_Data_Field" + fontName="Bitstream Vera Sans" + fontSize="11" + > + </style> + <style + name="Detail_Header" + mode="Opaque" + forecolor="#FFFFFF" + backcolor="#5D5D5D" + vAlign="Middle" + fontName="Bitstream Vera Sans" + fontSize="10" + isBold="true" + > + </style> + <style + name="Detail_Line" + fontName="Bitstream Vera Sans" + fontSize="8" + > + <conditionalStyle> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==1)]]></conditionExpression> - <style mode="Opaque" backcolor="#CCCCCC"/> + <style + mode="Opaque" + backcolor="#CCCCCC" + > + </style> </conditionalStyle> </style> - <style name="Total_Gray" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC"/> - <style name="Detail_Data_Label" mode="Opaque" backcolor="#CCCCCC" fontName="Bitstream Vera Sans" fontSize="10" isBold="true"/> - <style name="Detail_Data_Field" mode="Opaque" backcolor="#CCCCCC" fontName="Bitstream Vera Sans" fontSize="10"/> - <style name="Group_Footer" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/> - <style name="Report_Footer" isDefault="true" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="11"/> - <parameter name="DOCUMENT_ID" class="java.lang.String"> - <defaultValueExpression><![CDATA["'1000032'"]]></defaultValueExpression> + <style + name="Total_Gray" + mode="Opaque" + forecolor="#000000" + backcolor="#CCCCCC" + > + </style> + <style + name="Detail_Data_Label" + mode="Opaque" + backcolor="#CCCCCC" + fontName="Bitstream Vera Sans" + fontSize="10" + isBold="true" + > + </style> + <style + name="Detail_Data_Field" + mode="Opaque" + backcolor="#CCCCCC" + fontName="Bitstream Vera Sans" + fontSize="10" + > + </style> + <style + name="Group_Footer" + fontName="Bitstream Vera Sans" + fontSize="11" + isBold="true" + > + </style> + <style + name="Report_Footer" + isDefault="true" + vAlign="Middle" + fontName="Bitstream Vera Sans" + fontSize="11" + > + </style> + + <parameter name="DOCUMENT_ID" isForPrompting="true" class="java.lang.String"> + <defaultValueExpression ><![CDATA["'1000032'"]]></defaultValueExpression> </parameter> - <parameter name="DOCUMENT_NAME" class="java.lang.String" isForPrompting="false"> - <defaultValueExpression><![CDATA["'INVOICE'"]]></defaultValueExpression> + <parameter name="DOCUMENT_NAME" isForPrompting="false" class="java.lang.String"> + <defaultValueExpression ><![CDATA["'INVOICE'"]]></defaultValueExpression> </parameter> - <parameter name="ATTACH" class="java.lang.String" isForPrompting="false"/> - <parameter name="BASE_WEB" class="java.lang.String" isForPrompting="false"/> - <parameter name="BASE_DESIGN" class="java.lang.String" isForPrompting="false"> - <defaultValueExpression><![CDATA["/home/openbravo/src/openbravo/erp/devel/bttCourse/pi/src"]]></defaultValueExpression> + <parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/> + <parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/> + <parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"> + <defaultValueExpression ><![CDATA["/home/openbravo/src/openbravo/erp/devel/bttCourse/pi/src"]]></defaultValueExpression> </parameter> - <parameter name="LANGUAGE" class="java.lang.String" isForPrompting="false"> - <defaultValueExpression><![CDATA["en_US"]]></defaultValueExpression> + <parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String"> + <defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression> </parameter> - <parameter name="USER_CLIENT" class="java.lang.String" isForPrompting="false"> - <defaultValueExpression><![CDATA["('1000000)"]]></defaultValueExpression> + <parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String"> + <defaultValueExpression ><![CDATA["('1000000)"]]></defaultValueExpression> </parameter> - <parameter name="USER_ORG" class="java.lang.String" isForPrompting="false"> - <defaultValueExpression><![CDATA["('0')"]]></defaultValueExpression> + <parameter name="USER_ORG" isForPrompting="false" class="java.lang.String"> + <defaultValueExpression ><![CDATA["('0')"]]></defaultValueExpression> </parameter> - <parameter name="REPORT_TITLE" class="java.lang.String" isForPrompting="false"> - <defaultValueExpression><![CDATA["REPORT TITLE"]]></defaultValueExpression> + <parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String"> + <defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression> </parameter> - <parameter name="REPORT_SUBTITLE" class="java.lang.String" isForPrompting="false"/> - <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> - <defaultValueExpression><![CDATA[$P{BASE_DESIGN}+"/org/openbravo/erpReports/"]]></defaultValueExpression> + <parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String"/> + <parameter name="SUBREPORT_DIR" isForPrompting="false" class="java.lang.String"> + <defaultValueExpression ><![CDATA[$P{BASE_DESIGN}+"/org/openbravo/erpReports/"]]></defaultValueExpression> </parameter> - <parameter name="NUMBERFORMAT" class="java.text.DecimalFormat" isForPrompting="false"/> - <parameter name="LOCALE" class="java.util.Locale" isForPrompting="false"/> - <parameter name="SUBREP_RptC_Invoice_Lines_new" class="net.sf.jasperreports.engine.JasperReport" isForPrompting="false"/> - <parameter name="SUBREP_RptC_Invoice_TaxLines_new" class="net.sf.jasperreports.engine.JasperReport" isForPrompting="false"/> - <parameter name="SHOW_LOGO" class="java.lang.String"/> - <parameter name="SHOW_COMPANYDATA" class="java.lang.String" isForPrompting="false"/> - <parameter name="HEADER_MARGIN" class="java.lang.String"/> - <queryString> - <![CDATA[SELECT C_INVOICE.C_INVOICE_ID, C_BPARTNER.NAME, C_BPARTNER.TAXID AS CIF, AD_USER.NAME AS CONTACT_NAME, C_LOCATION.ADDRESS1, + <parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/> + <parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/> + <parameter name="SUBREP_RptC_Invoice_Lines_new" isForPrompting="false" class="net.sf.jasperreports.engine.JasperReport"/> + <parameter name="SUBREP_RptC_Invoice_TaxLines_new" isForPrompting="false" class="net.sf.jasperreports.engine.JasperReport"/> + <parameter name="SHOW_LOGO" isForPrompting="true" class="java.lang.String"/> + <parameter name="SHOW_COMPANYDATA" isForPrompting="false" class="java.lang.String"/> + <parameter name="HEADER_MARGIN" isForPrompting="true" class="java.lang.String"/> + <queryString><![CDATA[SELECT C_INVOICE.C_INVOICE_ID, C_BPARTNER.NAME, C_BPARTNER.TAXID AS CIF, AD_USER.NAME AS CONTACT_NAME, C_LOCATION.ADDRESS1, C_LOCATION.POSTAL, C_LOCATION.CITY, C_REGION.NAME AS REGION,C_COUNTRY.NAME AS COUNTRY,C_BPARTNER_LOCATION.PHONE AS PHONE, C_BPARTNER_LOCATION.FAX AS FAX, C_INVOICE.DATEINVOICED, C_INVOICE.DOCUMENTNO, C_BPARTNER.VALUE AS CODE_BPARTNER, AD_CLIENT.DESCRIPTION AS ENTITY, C_Location_Description(AD_ORGINFO.C_LOCATION_ID) AS LOCATION, C_CURRENCY.ISO_CODE AS CURRENCY_CODE,C_CURRENCY.CURSYMBOL AS SYMBOL, @@ -92,8 +223,8 @@ AND AD_ORG.ad_org_id = (SELECT o.AD_ORG_ID FROM AD_ORG o JOIN AD_OrgType t USING (AD_ORGTYPE_ID) WHERE AD_ISORGINCLUDED(C_INVOICE.AD_ORG_ID, o.ad_org_id, C_INVOICE.ad_client_id)<>-1 - AND (t.IsLegalEntity='Y' OR t.IsAcctLegalEntity='Y'))]]> - </queryString> + AND (t.IsLegalEntity='Y' OR t.IsAcctLegalEntity='Y'))]]></queryString> + <field name="C_INVOICE_ID" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="CIF" class="java.lang.String"/> @@ -125,365 +256,551 @@ <field name="ISSOTRX" class="java.lang.String"/> <field name="ISTAXINCLUDED" class="java.lang.String"/> <field name="ISCASHVAT" class="java.lang.String"/> - <variable name="TOTAL_LINENETAMT" class="java.math.BigDecimal" resetType="Group" resetGroup="C_INVOICE_ID"/> - <variable name="TOTAL_TAXAMT" class="java.math.BigDecimal" resetType="Group" resetGroup="C_INVOICE_ID"/> - <variable name="SHOWLOGO" class="java.lang.String"/> - <variable name="SHOWCOMPANYDATA" class="java.lang.String"/> - <group name="PrintLarge" isReprintHeaderOnEachPage="true"> - <groupExpression><![CDATA[]]></groupExpression> - <groupHeader> - <band height="120" splitType="Stretch"> + + <variable name="TOTAL_LINENETAMT" class="java.math.BigDecimal" resetType="Group" resetGroup="C_INVOICE_ID" calculation="Nothing"> + </variable> + <variable name="TOTAL_TAXAMT" class="java.math.BigDecimal" resetType="Group" resetGroup="C_INVOICE_ID" calculation="Nothing"> + </variable> + <variable name="SHOWLOGO" class="java.lang.String" resetType="Report" calculation="Nothing"> + </variable> + <variable name="SHOWCOMPANYDATA" class="java.lang.String" resetType="Report" calculation="Nothing"> + </variable> + + <group name="PrintLarge" isReprintHeaderOnEachPage="true" > + <groupExpression><![CDATA[]]></groupExpression> + <groupHeader> + <band height="120" isSplitAllowed="true" > <printWhenExpression><![CDATA[new Boolean($F{HEADERMARGIN}.equalsIgnoreCase("large"))]]></printWhenExpression> </band> - </groupHeader> ------------------------------------------------------------------------------ Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
