-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathcrosstab_1.jrxml
executable file
·128 lines (125 loc) · 4.69 KB
/
crosstab_1.jrxml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?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="crosstab_1"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<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.*" />
<parameter name="THIS_PATH_TO_DATABASE" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["jdbc:firebirdsql://localhost:3050/D://Cloth_Shop//DataBase//cloth.gdb"]]></defaultValueExpression>
</parameter>
<parameter name="THIS_LOGIN" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["SYSDBA"]]></defaultValueExpression>
</parameter>
<parameter name="THIS_PASSWORD" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["masterkey"]]></defaultValueExpression>
</parameter>
<queryString><![CDATA[SELECT
ARTICLE.NAME ARTICLE_NAME,
SUM(COMMODITY.QUANTITY) QUANTITY
FROM COMMODITY
INNER JOIN ARTICLE ON ARTICLE.KOD=COMMODITY.KOD_ARTICLE
INNER JOIN SUPPLIER ON SUPPLIER.KOD=ARTICLE.KOD_SUPPLIER
INNER JOIN KIND ON KIND.KOD=ARTICLE.KOD_KIND
LEFT JOIN PRICE ON PRICE.KOD=ARTICLE.KOD_PRICE
LEFT JOIN SIZE_TABLE ON SIZE_TABLE.KOD=ARTICLE.KOD_SIZE_TABLE
WHERE COMMODITY.KOD_POINT_SOURCE=0
GROUP BY
ARTICLE.NAME
HAVING SUM(COMMODITY.QUANTITY)>0]]></queryString>
<field name="ARTICLE_NAME" class="java.lang.String"/>
<field name="QUANTITY" class="java.lang.Long"/>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="0" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="0" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="64" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="0"
width="84"
height="15"
key="textField-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ARTICLE_NAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="84"
y="0"
width="72"
height="15"
key="textField-2"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font/>
</textElement>
<textFieldExpression class="java.lang.Long"><![CDATA[$F{QUANTITY}]]></textFieldExpression>
</textField>
<subreport isUsingCache="true">
<reportElement
x="17"
y="15"
width="508"
height="49"
forecolor="#FF00FF"
backcolor="#66FFFF"
key="subreport-1"
isPrintRepeatedValues="false"
isPrintInFirstWholeBand="true"
isPrintWhenDetailOverflows="true"/>
<subreportParameter name="ARTICLE_NAME">
<subreportParameterExpression><![CDATA[$F{ARTICLE_NAME}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[java.sql.DriverManager.getConnection($P{THIS_PATH_TO_DATABASE},$P{THIS_LOGIN},$P{THIS_PASSWORD})]]></connectionExpression>
<subreportExpression class="java.lang.String"><![CDATA[".\\crosstab_1_subreport0.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="0" isSplitAllowed="true" >
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>