-
Notifications
You must be signed in to change notification settings - Fork 0
/
Options.jrxml
60 lines (60 loc) · 2.53 KB
/
Options.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
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version last-->
<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="Additional-Drivers" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="962ef401-2d8f-44a9-b72c-6d48e483677d">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="JDBC Contract"/>
<parameter name="contractId" class="java.lang.String"/>
<queryString language="SQL">
<![CDATA[select
options0_.`contract`,
options0_.`id`,
options0_.`active`,
FORMAT(options0_.`amount`, 2) as amount,
options0_.`contract`,
options0_.`label` ,
contract.showOptionsPrices
from
`option` options0_,
contract
where
contract.id = options0_.contract AND
options0_.`contract` = $P{contractId}]]>
</queryString>
<field name="contract" class="java.lang.Integer">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="id" class="java.lang.Integer">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="active" class="java.lang.Integer">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="amount" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="label" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="showOptionsPrices" class="java.lang.Integer">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<detail>
<band height="15" splitType="Stretch">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<textField>
<reportElement x="-20" y="-20" width="240" height="14" uuid="34f1bf69-f4bb-4900-8e8c-baa978281d00"/>
<textElement>
<font fontName="Amaranth" pdfFontName="Amaranth"/>
</textElement>
<textFieldExpression><![CDATA[$F{label}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="120" y="-20" width="100" height="14" uuid="156c7442-637d-424c-972e-f6491648e465"/>
<textElement textAlignment="Right">
<font fontName="Amaranth" pdfFontName="Amaranth"/>
</textElement>
<textFieldExpression><![CDATA[IF($F{showOptionsPrices} == 1, $F{amount}, "")]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>