<?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="02_DR" language="groovy" pageWidth="274" pageHeight="802" columnWidth="274" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="a8993b13-3e8e-4b71-8ab4-d7d6b55acc18">
	<property name="ireport.zoom" value="5.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="style1">
		<conditionalStyle>
			<conditionExpression><![CDATA[$F{record_id} == 0 && $F{jp_parameter}.equals( "DRS" )]]></conditionExpression>
			<style backcolor="#99CCFF"/>
		</conditionalStyle>
		<conditionalStyle>
			<conditionExpression><![CDATA[$F{record_id} == 0 && $F{jp_parameter}.equals( "DR" )]]></conditionExpression>
			<style backcolor="#CCCCCC"/>
		</conditionalStyle>
	</style>
	<style name="style3">
		<conditionalStyle>
			<conditionExpression><![CDATA[($V{REPORT_COUNT} % 2) == 0]]></conditionExpression>
			<style backcolor="#CCCCCC"/>
		</conditionalStyle>
	</style>
	<parameter name="AD_PINSTANCE_ID" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="T_Report_AD_PInstance_ID" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT r.name,r.description,r.col_0, r.record_ID, rl.JP_Parameter
 FROM T_Report r
 INNER JOIN PA_ReportLine rl ON(r.PA_ReportLine_ID = rl.PA_ReportLine_ID)
 WHERE r.AD_PInstance_ID = $P{T_Report_AD_PInstance_ID} AND rl.IsPrinted = 'Y' AND rl.JP_Parameter IN ('DR','DRS') AND r.col_0 <> 0
 ORDER BY r.SeqNo,r.LevelNo,r.Name]]>
	</queryString>
	<field name="name" class="java.lang.String"/>
	<field name="description" class="java.lang.String"/>
	<field name="col_0" class="java.math.BigDecimal"/>
	<field name="record_id" class="java.math.BigDecimal"/>
	<field name="jp_parameter" class="java.lang.String"/>
	<columnHeader>
		<band height="12" splitType="Stretch">
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="0" y="0" width="1" height="12"/>
				<graphicElement>
					<pen lineWidth="2.0"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="0" y="0" width="274" height="1"/>
				<graphicElement>
					<pen lineWidth="2.0"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="0" y="11" width="274" height="1"/>
				<graphicElement>
					<pen lineWidth="2.0"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="85" y="0" width="1" height="12"/>
				<graphicElement>
					<pen lineWidth="1.0" lineStyle="Dotted"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="208" y="0" width="1" height="12"/>
				<graphicElement>
					<pen lineWidth="1.0" lineStyle="Dotted"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="273" y="0" width="1" height="12"/>
				<graphicElement>
					<pen lineWidth="1.0"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement uuid="fcf7592a-dc0f-4620-b7de-adfb42fd6463" x="4" y="0" width="80" height="12"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6" pdfFontName="HeiseiKakuGo-W5" pdfEncoding="UniJIS-UCS2-HW-H"/>
				</textElement>
				<text><![CDATA[勘定科目コード]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5b6afe4b-1685-4d38-afde-aff7c558b6e5" x="88" y="0" width="120" height="12"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6" pdfFontName="HeiseiKakuGo-W5" pdfEncoding="UniJIS-UCS2-HW-H"/>
				</textElement>
				<text><![CDATA[勘定科目名]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="7e1871e0-4304-4a39-b02c-bef74d6be55f" x="210" y="0" width="60" height="12"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6" pdfFontName="HeiseiKakuGo-W5" pdfEncoding="UniJIS-UCS2-HW-H"/>
				</textElement>
				<text><![CDATA[金額]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<frame>
				<reportElement uuid="e548736d-7079-4666-93b0-ff07b4269977" style="style1" mode="Opaque" x="0" y="0" width="273" height="10"/>
				<textField>
					<reportElement uuid="924d3bd0-6ffe-4cbd-87fe-c0331c8b2012" x="4" y="0" width="80" height="10"/>
					<textElement verticalAlignment="Middle">
						<font size="6" pdfFontName="HeiseiKakuGo-W5" pdfEncoding="UniJIS-UCS2-HW-H"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement uuid="420c7c6a-fa20-4662-a49c-6ff72d7dd66c" x="88" y="0" width="120" height="10"/>
					<textElement verticalAlignment="Middle">
						<font size="6" pdfFontName="HeiseiKakuGo-W5" pdfEncoding="UniJIS-UCS2-HW-H"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{description}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0;-#,##0" isBlankWhenNull="true">
					<reportElement uuid="49509ff6-6ccb-47f4-af3e-52f1bad4af9c" x="210" y="0" width="60" height="10"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{col_0}]]></textFieldExpression>
				</textField>
			</frame>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="0" y="0" width="1" height="10"/>
				<graphicElement>
					<pen lineWidth="2.0"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="85" y="0" width="1" height="10"/>
				<graphicElement>
					<pen lineWidth="1.0" lineStyle="Dotted"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="208" y="0" width="1" height="10"/>
				<graphicElement>
					<pen lineWidth="1.0" lineStyle="Dotted"/>
				</graphicElement>
			</line>
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="273" y="0" width="1" height="10"/>
				<graphicElement>
					<pen lineWidth="1.0"/>
				</graphicElement>
			</line>
		</band>
	</detail>
	<pageFooter>
		<band height="1">
			<line>
				<reportElement uuid="81e68beb-14a2-40cb-a874-93c4fb170a1e" x="0" y="0" width="274" height="1"/>
				<graphicElement>
					<pen lineWidth="2.0"/>
				</graphicElement>
			</line>
		</band>
	</pageFooter>
</jasperReport>
