jasper report integration

1 files changed, 141 insertions, 0 deletions

diff --git a/jasper_reports/demo/sub_report.jrxml b/jasper_reports/demo/sub_report.jrxml
new file mode 100755
index 0000000..e27bd36
--- /dev/null
+++ b/jasper_reports/demo/sub_report.jrxml
@@ -0,0 +1,141 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1  -->
+<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="sub_report" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
+	<property name="com.jaspersoft.studio.data.sql.tables"/>
+	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="260"/>
+	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="740"/>
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Odoo Jasper"/>
+	<queryString language="SQL">
+		<![CDATA[SELECT public.product_template.name,
+	public.product_template.sequence,
+	public.sale_order.name,
+	public.sale_order.date_order,
+	public.sale_order.confirmation_date,
+	public.sale_order.amount_total,
+	public.res_partner.name,
+	public.res_partner.street,
+	public.res_partner.street2,
+	public.res_partner.zip,
+	public.res_partner.city,
+	public.sale_order_line.price_unit,
+	public.sale_order_line.price_subtotal,
+	public.sale_order_line.price_tax,
+	public.sale_order_line.price_total,
+	public.sale_order_line.price_reduce,
+	public.sale_order_line.discount
+FROM public.product_template,
+	public.res_partner
+	INNER JOIN public.sale_order ON 
+	 public.sale_order.partner_id = public.res_partner.id 
+	INNER JOIN public.sale_order_line ON 
+	 public.sale_order_line.order_id = public.sale_order.id LIMIT 1]]>
+	</queryString>
+	<field name="name" class="java.lang.String">
+		<property name="com.jaspersoft.studio.field.label" value="name"/>
+	</field>
+	<field name="sequence" class="java.lang.Integer">
+		<property name="com.jaspersoft.studio.field.label" value="sequence"/>
+	</field>
+	<field name="COLUMN_3" class="java.lang.String">
+		<property name="com.jaspersoft.studio.field.label" value="name"/>
+	</field>
+	<field name="date_order" class="java.sql.Timestamp">
+		<property name="com.jaspersoft.studio.field.label" value="date_order"/>
+	</field>
+	<field name="confirmation_date" class="java.sql.Timestamp">
+		<property name="com.jaspersoft.studio.field.label" value="confirmation_date"/>
+	</field>
+	<field name="amount_total" class="java.math.BigDecimal">
+		<property name="com.jaspersoft.studio.field.label" value="amount_total"/>
+	</field>
+	<field name="COLUMN_7" class="java.lang.String">
+		<property name="com.jaspersoft.studio.field.label" value="name"/>
+	</field>
+	<field name="street" class="java.lang.String">
+		<property name="com.jaspersoft.studio.field.label" value="street"/>
+	</field>
+	<field name="street2" class="java.lang.String">
+		<property name="com.jaspersoft.studio.field.label" value="street2"/>
+	</field>
+	<field name="zip" class="java.lang.String">
+		<property name="com.jaspersoft.studio.field.label" value="zip"/>
+	</field>
+	<field name="city" class="java.lang.String">
+		<property name="com.jaspersoft.studio.field.label" value="city"/>
+	</field>
+	<field name="price_unit" class="java.math.BigDecimal">
+		<property name="com.jaspersoft.studio.field.label" value="price_unit"/>
+	</field>
+	<field name="price_subtotal" class="java.math.BigDecimal">
+		<property name="com.jaspersoft.studio.field.label" value="price_subtotal"/>
+	</field>
+	<field name="price_tax" class="java.lang.Double">
+		<property name="com.jaspersoft.studio.field.label" value="price_tax"/>
+	</field>
+	<field name="price_total" class="java.math.BigDecimal">
+		<property name="com.jaspersoft.studio.field.label" value="price_total"/>
+	</field>
+	<field name="price_reduce" class="java.math.BigDecimal">
+		<property name="com.jaspersoft.studio.field.label" value="price_reduce"/>
+	</field>
+	<field name="discount" class="java.math.BigDecimal">
+		<property name="com.jaspersoft.studio.field.label" value="discount"/>
+	</field>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band height="79" splitType="Stretch">
+			<staticText>
+				<reportElement x="200" y="26" width="154" height="26"/>
+				<textElement textAlignment="Center" verticalAlignment="Top">
+					<font size="16"/>
+				</textElement>
+				<text><![CDATA[Sale Order Report]]></text>
+			</staticText>
+		</band>
+	</title>
+	<detail>
+		<band height="327" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="20" width="90" height="21"/>
+				<textElement textAlignment="Center">
+					<font size="14" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Customer :]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="100" y="20" width="120" height="21"/>
+				<textElement textAlignment="Left">
+					<font size="14"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{COLUMN_7}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="100" y="41" width="120" height="19"/>
+				<textElement>
+					<font size="10"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{street}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="100" y="60" width="120" height="20"/>
+				<textFieldExpression><![CDATA[$F{city}]]></textFieldExpression>
+			</textField>
+			<subreport>
+				<reportElement x="0" y="110" width="550" height="200"/>
+				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
+				<subreportExpression><![CDATA["Blank_Letter_Landscape.jasper"]]></subreportExpression>
+			</subreport>
+		</band>
+	</detail>
+	<columnFooter>
+		<band height="45" splitType="Stretch"/>
+	</columnFooter>
+	<pageFooter>
+		<band height="54" splitType="Stretch"/>
+	</pageFooter>
+	<summary>
+		<band height="42" splitType="Stretch"/>
+	</summary>
+</jasperReport>