diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2022-09-13 12:05:33 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2022-09-13 12:05:33 +0700 |
| commit | 8f3d096dbae18bacd95796d03b17d4d94a806c85 (patch) | |
| tree | ae90032724dabe417b907db43145639e6df9565f /jasper_reports/tests/user.jrxml | |
| parent | 0d87fec0c4c6fb573b1a09076f6d50844d8d0a80 (diff) | |
jasper report integration
Diffstat (limited to 'jasper_reports/tests/user.jrxml')
| -rwxr-xr-x | jasper_reports/tests/user.jrxml | 119 |
1 files changed, 119 insertions, 0 deletions
diff --git a/jasper_reports/tests/user.jrxml b/jasper_reports/tests/user.jrxml new file mode 100755 index 0000000..d003429 --- /dev/null +++ b/jasper_reports/tests/user.jrxml @@ -0,0 +1,119 @@ +<?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="report1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="48"/> + <style name="table"> + <box> + <pen lineWidth="1.0" lineColor="#000000"/> + </box> + </style> + <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="table 1"> + <box> + <pen lineWidth="1.0" lineColor="#000000"/> + </box> + </style> + <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + <conditionalStyle> + <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression> + <style backcolor="#EFF7FF"/> + </conditionalStyle> + </style> + <subDataset name="Table Dataset 1" /> + <subDataset name="Table Dataset 2" /> + <queryString> + <![CDATA[select p.name, u.login from res_partner p, res_users u where p.id= u.partner_id]]> + </queryString> + <field name="name" class="java.lang.String"/> + <field name="login" class="java.lang.String"/> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="79" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="555" height="79" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="30" isBold="true"/> + </textElement> + <text><![CDATA[User Report]]></text> + </staticText> + </band> + </title> + <pageHeader> + <band height="35" splitType="Stretch"/> + </pageHeader> + <columnHeader> + <band height="41" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="372" height="41" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="26" isBold="true"/> + </textElement> + <text><![CDATA[User Name]]></text> + </staticText> + <staticText> + <reportElement x="372" y="0" width="183" height="41" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="24" isBold="true"/> + </textElement> + <text><![CDATA[Login]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="27" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="372" height="25" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="15"/> + </textElement> + <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="372" y="0" width="183" height="25" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="15"/> + </textElement> + <textFieldExpression><![CDATA[$F{login}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band height="45" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="54" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="42" splitType="Stretch"/> + </summary> +</jasperReport> |