summaryrefslogtreecommitdiff
path: root/jasper_reports/demo/user_query_report.jrxml
diff options
context:
space:
mode:
Diffstat (limited to 'jasper_reports/demo/user_query_report.jrxml')
-rwxr-xr-xjasper_reports/demo/user_query_report.jrxml251
1 files changed, 251 insertions, 0 deletions
diff --git a/jasper_reports/demo/user_query_report.jrxml b/jasper_reports/demo/user_query_report.jrxml
new file mode 100755
index 0000000..1ad3841
--- /dev/null
+++ b/jasper_reports/demo/user_query_report.jrxml
@@ -0,0 +1,251 @@
+<?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="sale_order_subreport_demo" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
+ <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Odoo Jasper"/>
+ <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
+ <box>
+ <pen lineWidth="0.5" lineColor="#000000"/>
+ <topPen lineWidth="0.5" lineColor="#000000"/>
+ <leftPen lineWidth="0.5" lineColor="#000000"/>
+ <bottomPen lineWidth="0.5" lineColor="#000000"/>
+ <rightPen lineWidth="0.5" lineColor="#000000"/>
+ </box>
+ </style>
+ <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
+ <box>
+ <pen lineWidth="0.5" lineColor="#000000"/>
+ <topPen lineWidth="0.5" lineColor="#000000"/>
+ <leftPen lineWidth="0.5" lineColor="#000000"/>
+ <bottomPen lineWidth="0.5" lineColor="#000000"/>
+ <rightPen lineWidth="0.5" lineColor="#000000"/>
+ </box>
+ </style>
+ <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
+ <box>
+ <pen lineWidth="0.5" lineColor="#000000"/>
+ <topPen lineWidth="0.5" lineColor="#000000"/>
+ <leftPen lineWidth="0.5" lineColor="#000000"/>
+ <bottomPen lineWidth="0.5" lineColor="#000000"/>
+ <rightPen lineWidth="0.5" lineColor="#000000"/>
+ </box>
+ </style>
+ <style name="Table 1_TH" mode="Opaque" backcolor="#F0F8FF">
+ <box>
+ <pen lineWidth="0.5" lineColor="#000000"/>
+ <topPen lineWidth="0.5" lineColor="#000000"/>
+ <leftPen lineWidth="0.5" lineColor="#000000"/>
+ <bottomPen lineWidth="0.5" lineColor="#000000"/>
+ <rightPen lineWidth="0.5" lineColor="#000000"/>
+ </box>
+ </style>
+ <style name="Table 1_CH" mode="Opaque" backcolor="#BFE1FF">
+ <box>
+ <pen lineWidth="0.5" lineColor="#000000"/>
+ <topPen lineWidth="0.5" lineColor="#000000"/>
+ <leftPen lineWidth="0.5" lineColor="#000000"/>
+ <bottomPen lineWidth="0.5" lineColor="#000000"/>
+ <rightPen lineWidth="0.5" lineColor="#000000"/>
+ </box>
+ </style>
+ <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF">
+ <box>
+ <pen lineWidth="0.5" lineColor="#000000"/>
+ <topPen lineWidth="0.5" lineColor="#000000"/>
+ <leftPen lineWidth="0.5" lineColor="#000000"/>
+ <bottomPen lineWidth="0.5" lineColor="#000000"/>
+ <rightPen lineWidth="0.5" lineColor="#000000"/>
+ </box>
+ </style>
+ <subDataset name="Dataset3">
+ <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Odoo Jasper"/>
+ <queryString language="SQL">
+ <![CDATA[SELECT public.res_partner.name,
+ public.res_partner.email,
+ public.res_partner.phone,
+ public.res_partner.city,
+ public.res_partner.barcode
+FROM public.res_partner]]>
+ </queryString>
+ <field name="name" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="name"/>
+ </field>
+ <field name="email" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="email"/>
+ </field>
+ <field name="phone" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="phone"/>
+ </field>
+ <field name="city" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="city"/>
+ </field>
+ <field name="barcode" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="barcode"/>
+ </field>
+ </subDataset>
+ <queryString language="SQL">
+ <![CDATA[SELECT public.res_partner.name,
+ public.res_partner.email,
+ public.res_partner.barcode,
+ public.res_partner.city,
+ public.res_partner.phone
+FROM public.res_partner]]>
+ </queryString>
+ <field name="name" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="name"/>
+ </field>
+ <field name="email" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="email"/>
+ </field>
+ <field name="barcode" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="barcode"/>
+ </field>
+ <field name="city" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="city"/>
+ </field>
+ <field name="phone" class="java.lang.String">
+ <property name="com.jaspersoft.studio.field.label" value="phone"/>
+ </field>
+ <background>
+ <band splitType="Stretch"/>
+ </background>
+ <title>
+ <band height="79" splitType="Stretch"/>
+ </title>
+ <pageHeader>
+ <band height="35" splitType="Stretch"/>
+ </pageHeader>
+ <columnHeader>
+ <band height="61" splitType="Stretch"/>
+ </columnHeader>
+ <detail>
+ <band height="272" splitType="Stretch">
+ <componentElement>
+ <reportElement x="31" y="11" width="500" height="150">
+ <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
+ <property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/>
+ <property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/>
+ <property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/>
+ </reportElement>
+ <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
+ <datasetRun subDataset="Dataset3">
+ <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
+ </datasetRun>
+ <jr:column width="100">
+ <jr:tableHeader style="Table 1_TH" height="30"/>
+ <jr:tableFooter style="Table 1_TH" height="30"/>
+ <jr:columnHeader style="Table 1_CH" height="30">
+ <staticText>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font isBold="true"/>
+ </textElement>
+ <text><![CDATA[name]]></text>
+ </staticText>
+ </jr:columnHeader>
+ <jr:columnFooter style="Table 1_CH" height="30"/>
+ <jr:detailCell style="Table 1_TD" height="30">
+ <textField>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
+ </textField>
+ </jr:detailCell>
+ </jr:column>
+ <jr:column width="100">
+ <jr:tableHeader style="Table 1_TH" height="30"/>
+ <jr:tableFooter style="Table 1_TH" height="30"/>
+ <jr:columnHeader style="Table 1_CH" height="30">
+ <staticText>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font isBold="true"/>
+ </textElement>
+ <text><![CDATA[email]]></text>
+ </staticText>
+ </jr:columnHeader>
+ <jr:columnFooter style="Table 1_CH" height="30"/>
+ <jr:detailCell style="Table 1_TD" height="30">
+ <textField>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{email}]]></textFieldExpression>
+ </textField>
+ </jr:detailCell>
+ </jr:column>
+ <jr:column width="100">
+ <jr:tableHeader style="Table 1_TH" height="30"/>
+ <jr:tableFooter style="Table 1_TH" height="30"/>
+ <jr:columnHeader style="Table 1_CH" height="30">
+ <staticText>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font isBold="true"/>
+ </textElement>
+ <text><![CDATA[phone]]></text>
+ </staticText>
+ </jr:columnHeader>
+ <jr:columnFooter style="Table 1_CH" height="30"/>
+ <jr:detailCell style="Table 1_TD" height="30">
+ <textField>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{phone}]]></textFieldExpression>
+ </textField>
+ </jr:detailCell>
+ </jr:column>
+ <jr:column width="100">
+ <jr:tableHeader style="Table 1_TH" height="30"/>
+ <jr:tableFooter style="Table 1_TH" height="30"/>
+ <jr:columnHeader style="Table 1_CH" height="30">
+ <staticText>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font isBold="true"/>
+ </textElement>
+ <text><![CDATA[city]]></text>
+ </staticText>
+ </jr:columnHeader>
+ <jr:columnFooter style="Table 1_CH" height="30"/>
+ <jr:detailCell style="Table 1_TD" height="30">
+ <textField>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{city}]]></textFieldExpression>
+ </textField>
+ </jr:detailCell>
+ </jr:column>
+ <jr:column width="100">
+ <jr:tableHeader style="Table 1_TH" height="30"/>
+ <jr:tableFooter style="Table 1_TH" height="30"/>
+ <jr:columnHeader style="Table 1_CH" height="30">
+ <staticText>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle">
+ <font isBold="true"/>
+ </textElement>
+ <text><![CDATA[barcode]]></text>
+ </staticText>
+ </jr:columnHeader>
+ <jr:columnFooter style="Table 1_CH" height="30"/>
+ <jr:detailCell style="Table 1_TD" height="30">
+ <textField>
+ <reportElement x="0" y="0" width="100" height="30"/>
+ <textElement textAlignment="Center" verticalAlignment="Middle"/>
+ <textFieldExpression><![CDATA[$F{barcode}]]></textFieldExpression>
+ </textField>
+ </jr:detailCell>
+ </jr:column>
+ </jr:table>
+ </componentElement>
+ </band>
+ </detail>
+ <columnFooter>
+ <band height="45" splitType="Stretch"/>
+ </columnFooter>
+ <pageFooter>
+ <band height="54" splitType="Stretch"/>
+ </pageFooter>
+ <summary>
+ <band height="42" splitType="Stretch"/>
+ </summary>
+</jasperReport>
generated by cgit v1.2.3 (git 2.25.1) at 2026-05-23 22:58:32 +0000