src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 726 dac2a1486bd3
child 2669 dfa1375ef2cf
permissions -rw-r--r--
Removed old frame parameter of windowTableId
juanpablo@726
     1
<?xml version="1.0" encoding="UTF-8"  ?>
juanpablo@726
     2
<!-- Created with iReport - A designer for JasperReports -->
juanpablo@726
     3
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
juanpablo@726
     4
<jasperReport
juanpablo@726
     5
		 name="productionSubReport"
juanpablo@726
     6
		 columnCount="1"
juanpablo@726
     7
		 printOrder="Vertical"
juanpablo@726
     8
		 orientation="Portrait"
juanpablo@726
     9
		 pageWidth="421"
juanpablo@726
    10
		 pageHeight="595"
juanpablo@726
    11
		 columnWidth="421"
juanpablo@726
    12
		 columnSpacing="0"
juanpablo@726
    13
		 leftMargin="0"
juanpablo@726
    14
		 rightMargin="0"
juanpablo@726
    15
		 topMargin="0"
juanpablo@726
    16
		 bottomMargin="0"
juanpablo@726
    17
		 whenNoDataType="NoPages"
juanpablo@726
    18
		 isTitleNewPage="false"
juanpablo@726
    19
		 isSummaryNewPage="false">
juanpablo@726
    20
	<property name="ireport.scriptlethandling" value="0" />
juanpablo@726
    21
	<property name="ireport.encoding" value="UTF-8" />
juanpablo@726
    22
	<import value="java.util.*" />
juanpablo@726
    23
	<import value="net.sf.jasperreports.engine.*" />
juanpablo@726
    24
	<import value="net.sf.jasperreports.engine.data.*" />
juanpablo@726
    25
juanpablo@726
    26
	<parameter name="DATE_FROM" isForPrompting="true" class="java.util.Date">
juanpablo@726
    27
		<defaultValueExpression ><![CDATA[new SimpleDateFormat("dd-MM-yyyy").parse("01-01-2000")]]></defaultValueExpression>
juanpablo@726
    28
	</parameter>
juanpablo@726
    29
	<parameter name="DATE_TO" isForPrompting="true" class="java.util.Date">
juanpablo@726
    30
		<defaultValueExpression ><![CDATA[new SimpleDateFormat("dd-MM-yyyy").parse("01-01-3000")]]></defaultValueExpression>
juanpablo@726
    31
	</parameter>
juanpablo@726
    32
	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
juanpablo@726
    33
		<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
juanpablo@726
    34
	</parameter>
juanpablo@726
    35
	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
juanpablo@726
    36
		<defaultValueExpression ><![CDATA["(1000000)"]]></defaultValueExpression>
juanpablo@726
    37
	</parameter>
juanpablo@726
    38
	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
juanpablo@726
    39
		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
juanpablo@726
    40
	</parameter>
juanpablo@726
    41
	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
juanpablo@726
    42
	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
carlos@0
    43
	<queryString><![CDATA[SELECT M_PRODUCT.NAME AS PRODUCT_NAME, SUM(ROUND(M_PRODUCTIONLINE.MOVEMENTQTY,2)) AS MOVEMENTQTY, C_UOM.NAME AS UOM_NAME
carlos@0
    44
      FROM M_PRODUCTION, M_PRODUCTIONPLAN, M_PRODUCTIONLINE, M_PRODUCT, C_UOM
carlos@0
    45
      WHERE M_PRODUCTION.M_PRODUCTION_ID = M_PRODUCTIONPLAN.M_PRODUCTION_ID
carlos@0
    46
      AND M_PRODUCTIONPLAN.M_PRODUCTIONPLAN_ID = M_PRODUCTIONLINE.M_PRODUCTIONPLAN_ID
carlos@0
    47
      AND M_PRODUCTIONLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
carlos@0
    48
      AND M_PRODUCTIONLINE.C_UOM_ID = C_UOM.C_UOM_ID
carlos@0
    49
      AND M_PRODUCTION.AD_CLIENT_ID IN ($P!{USER_CLIENT})
carlos@0
    50
      AND M_PRODUCTION.AD_ORG_ID IN ($P!{USER_ORG})
carlos@0
    51
      AND M_PRODUCTION.PROCESSED = 'Y'
carlos@0
    52
      AND M_PRODUCTIONLINE.MOVEMENTQTY > 0
carlos@0
    53
      AND M_PRODUCTION.MOVEMENTDATE >= $P{DATE_FROM}
carlos@0
    54
      AND M_PRODUCTION.MOVEMENTDATE < $P{DATE_TO}
carlos@0
    55
      AND M_PRODUCTION.ISSOTRX = 'Y'
carlos@0
    56
      GROUP BY M_PRODUCT.NAME, C_UOM.NAME
juanpablo@726
    57
      HAVING SUM(ROUND(M_PRODUCTIONLINE.MOVEMENTQTY,2)) > 0]]></queryString>
juanpablo@726
    58
juanpablo@726
    59
	<field name="PRODUCT_NAME" class="java.lang.String"/>
juanpablo@726
    60
	<field name="MOVEMENTQTY" class="java.math.BigDecimal"/>
juanpablo@726
    61
	<field name="UOM_NAME" class="java.lang.String"/>
juanpablo@726
    62
juanpablo@726
    63
		<background>
juanpablo@726
    64
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
    65
			</band>
juanpablo@726
    66
		</background>
juanpablo@726
    67
		<title>
juanpablo@726
    68
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
    69
			</band>
juanpablo@726
    70
		</title>
juanpablo@726
    71
		<pageHeader>
juanpablo@726
    72
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
    73
			</band>
juanpablo@726
    74
		</pageHeader>
juanpablo@726
    75
		<columnHeader>
juanpablo@726
    76
			<band height="20"  isSplitAllowed="true" >
juanpablo@726
    77
				<staticText>
carlos@0
    78
					<reportElement
carlos@0
    79
						x="0"
carlos@0
    80
						y="3"
carlos@0
    81
						width="170"
carlos@0
    82
						height="17"
carlos@0
    83
						forecolor="#000000"
juanpablo@726
    84
						key="staticText"/>
juanpablo@726
    85
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
    86
					<textElement textAlignment="Left">
juanpablo@726
    87
						<font fontName="Bitstream Vera Sans" pdfFontName="Helvetica-Bold" size="10" isBold="true" isUnderline="true"/>
juanpablo@726
    88
					</textElement>
juanpablo@726
    89
				<text><![CDATA[PRODUCTION REPORT]]></text>
juanpablo@726
    90
				</staticText>
juanpablo@726
    91
			</band>
juanpablo@726
    92
		</columnHeader>
juanpablo@726
    93
		<detail>
juanpablo@726
    94
			<band height="18"  isSplitAllowed="true" >
juanpablo@726
    95
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
    96
					<reportElement
carlos@0
    97
						x="0"
carlos@0
    98
						y="1"
carlos@0
    99
						width="170"
carlos@0
   100
						height="16"
carlos@0
   101
						forecolor="#000000"
juanpablo@726
   102
						key="textField"/>
juanpablo@726
   103
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   104
					<textElement textAlignment="Left">
juanpablo@726
   105
						<font fontName="Bitstream Vera Sans" size="10" isBold="false"/>
juanpablo@726
   106
					</textElement>
juanpablo@726
   107
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{PRODUCT_NAME}]]></textFieldExpression>
juanpablo@726
   108
				</textField>
juanpablo@726
   109
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   110
					<reportElement
carlos@0
   111
						x="172"
carlos@0
   112
						y="1"
carlos@0
   113
						width="132"
carlos@0
   114
						height="16"
carlos@0
   115
						forecolor="#000000"
juanpablo@726
   116
						key="textField"/>
juanpablo@726
   117
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   118
					<textElement textAlignment="Right">
juanpablo@726
   119
						<font fontName="Bitstream Vera Sans" size="10" isBold="false"/>
juanpablo@726
   120
					</textElement>
juanpablo@726
   121
				<textFieldExpression   class="java.lang.String"><![CDATA[($F{MOVEMENTQTY}!=null)?$P{NUMBERFORMAT}.format($F{MOVEMENTQTY}):new String(" ")]]></textFieldExpression>
juanpablo@726
   122
				</textField>
juanpablo@726
   123
				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
carlos@0
   124
					<reportElement
carlos@0
   125
						x="304"
carlos@0
   126
						y="1"
carlos@0
   127
						width="69"
carlos@0
   128
						height="16"
carlos@0
   129
						forecolor="#000000"
juanpablo@726
   130
						key="textField"/>
juanpablo@726
   131
					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="4" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
juanpablo@726
   132
					<textElement textAlignment="Left">
juanpablo@726
   133
						<font fontName="Bitstream Vera Sans" size="10" isBold="false"/>
juanpablo@726
   134
					</textElement>
juanpablo@726
   135
				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOM_NAME}]]></textFieldExpression>
juanpablo@726
   136
				</textField>
juanpablo@726
   137
			</band>
juanpablo@726
   138
		</detail>
juanpablo@726
   139
		<columnFooter>
juanpablo@726
   140
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   141
			</band>
juanpablo@726
   142
		</columnFooter>
juanpablo@726
   143
		<pageFooter>
juanpablo@726
   144
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   145
			</band>
juanpablo@726
   146
		</pageFooter>
juanpablo@726
   147
		<summary>
juanpablo@726
   148
			<band height="0"  isSplitAllowed="true" >
juanpablo@726
   149
			</band>
juanpablo@726
   150
		</summary>
juanpablo@726
   151
</jasperReport>