■プロジェクト作成＆DataAdapter(DB)
1) file->new->project->JasperReports Project->testProject
2) testProject->new->Jasper Report->Blank_A4
3) testProject->new->Data Adaper->Database JDBC Connection
adapterName
MYSQL(com.mysql.jdbc.Driver)
jdbc:mysql://localhost/database name
root
password
4) Driver Classpath
/保存場所/mysql-connector-java-5.1.47-bin.jar
5) testで接続確認
6）outline->Blank_A4->Dataset and Query
アダプタ名
データベース/テーブル選択->select * from database.table名 join database.table2 using( field )->Read Fields
7) Blank_A4.jrxml選択->Text Field配置->Fields->field名
8）fx Variables->create Variable
Name = sum
Value Class Name = java.lang.Integer
Calculation = Sum
Expression = データベースフィールド名（sum対象）
■プロジェクト作成＆DataAdapter(JSON)
1) file->new->project->JasperReports Project->Customers
2) Customers->new->Jasper Report->Blank_A4
Data Adapter Language:jsonql
Customers->new->Data Adapter->JSON File
Customer_Rows/URL/Use the report JSON expression when filling the report
■サンプルDB
create database 伝票明細;
use 伝票明細
create table 伝票(
伝票番号 varchar(8) not null comment "伝票番号",
支払合計 int(10) not null comment "支払合計");
create table 商品情報(
伝票番号 varchar(8) not null comment "伝票番号",
商品コード varchar(16) not null comment "商品コード",
数量 varchar(24) not null comment "数量");
create table 支払情報(
伝票番号 varchar(8) not null comment "伝票番号",
金種 int(2) not null comment "金種",
支払金額 int(10) not null comment "支払金額");
create table 商品マスター(
商品コード varchar(16) not null comment "商品コード",
商品名 varchar(24) not null comment "商品名",
単価 int(10) not null comment "単価");
insert into 伝票
(伝票番号, 支払合計) values
(00000001,1000),
(00000002,1200),
(00000003,1600),
(00000004,1000);
insert into 支払情報
(伝票番号, 金種, 支払金額) values
(00000001, 1, 1000),
(00000002, 2, 2000),
(00000003, 3, 3000);
insert into 商品情報
(伝票番号, 商品コード, 数量 ) values
(00000001, 0000000000000200, 3),
(00000001, 0000000000000300, 4),
(00000002, 0000000000000300, 5),
(00000003, 0000000000000400, 6);
insert into 商品マスター
(商品コード,商品名,単価) values
(0000000000000100,"りんご",200),
(0000000000000200,"みかん",300),
(0000000000000300,"バナナ",400),
(0000000000000400,"すいか",500);
create view view_table( 伝票番号, 支払合計, 商品コード, 商品名, 単価, 数量, 定価, 金種, 支払金額, 値引額 )
as select
伝票.伝票番号 as 伝票番号,
伝票.支払合計 as 支払合計,
商品情報.商品コード as 商品コード,
商品マスター.商品名 as 商品名,
商品マスター.単価 as 単価,
商品情報.数量 as 数量,
単価 * 数量 as 定価,
支払情報.金種 as 金種,
支払情報.支払金額 as 支払金額,
(単価 * 数量) - 支払情報.支払金額 as 値引額
from 伝票
join 商品情報 on (伝票.伝票番号=商品情報.伝票番号 )
left join 支払情報 on (伝票.伝票番号=支払情報.伝票番号 )
left join 商品マスター on (商品情報.商品コード=商品マスター.商品コード);
select * from view_table;
select 伝票番号 , 支払合計, 商品情報.商品コード as 商品コード, 商品情報.数量 as 数量 from 伝票 join 商品情報 using( 伝票番号 ) where 伝票番号="1";
mysql> select column_name, column_comment from information_schema.columns where table_name='伝票';
+--------------+----------------+
| COLUMN_NAME | COLUMN_COMMENT |
+--------------+----------------+
| 伝票番号 | 伝票番号 |
| 支払合計 | 支払合計 |
+--------------+----------------+
2 rows in set (0.00 sec)
----------------------------------------------
create database test;
use test
create table test.check(
id varchar(8) not null comment "伝票番号",
total int(10) not null comment "金額");
create table test.item_info(
id varchar(8) not null comment "伝票番号",
code varchar(16) not null comment "商品コード",
qty varchar(24) not null comment "数量");
create table test.paid_info(
id varchar(8) not null comment "伝票番号",
kind int(2) not null comment "金種",
amt int(10) not null comment "金額");
create table test.plu_mast(
code varchar(16) not null comment "商品コード",
name varchar(24) not null comment "商品名",
price int(10) not null comment "金額");
insert into test.check
(id, total) values
(00000001,1000),
(00000002,1200),
(00000003,1600),
(00000004,1000);
insert into test.paid_info
(id, kind, amt) values
(00000001, 1, 1000),
(00000002, 2, 2000),
(00000003, 3, 3000);
insert into test.item_info
(id, code, qty ) values
(00000001, 0000000000000200, 3),
(00000001, 0000000000000300, 4),
(00000002, 0000000000000300, 5),
(00000003, 0000000000000400, 6);
insert into test.plu_mast
(code,name,price) values
(0000000000000100,"りんご",200),
(0000000000000200,"みかん",300),
(0000000000000300,"バナナ",400),
(0000000000000400,"すいか",500);
select id , total, item_info.code as code, item_info.qty as qty from test.check join test.item_info using( id ) where id="1";
select check.id as id,
check.total as total,
item_info.code as code,
plu_mast.name as name,
plu_mast.price as price,
item_info.qty as qty,
price * qty as teika,
paid_info.kind as kind,
paid_info.amt as shiharai,
(price * qty) - paid_info.amt as nebiki
from test.check
join test.item_info on (check.id=item_info.id )
left join test.paid_info on (check.id=paid_info.id )
left join test.plu_mast on (item_info.code=plu_mast.code);
create view view_table( id, total, code, name, price, qty, teika, kind, shiharai, nebiki )
as select check.id as id,
check.total as total,
item_info.code as code,
plu_mast.name as name,
plu_mast.price as price,
item_info.qty as qty,
price * qty as teika,
paid_info.kind as kind,
paid_info.amt as shiharai,
(price * qty) - paid_info.amt as nebiki
from test.check
join test.item_info on (check.id=item_info.id )
left join test.paid_info on (check.id=paid_info.id )
left join test.plu_mast on (item_info.code=plu_mast.code);
select * from view_table;
■サンプル（見積書）
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0 -->
<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="Blank_A4" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="85bb76b2-9fca-429d-9818-4f3c94e4a537">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="DataAdapter.xml"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<style name="Row" mode="Transparent">
<conditionalStyle>
<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
<style backcolor="#E6DAC3"/>
</conditionalStyle>
</style>
<queryString>
<![CDATA[select * from plumaster]]>
</queryString>
<field name="id" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="id"/>
<property name="com.jaspersoft.studio.field.tree.path" value="plumaster"/>
</field>
<field name="name" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="name"/>
<property name="com.jaspersoft.studio.field.tree.path" value="plumaster"/>
</field>
<field name="price" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="price"/>
<property name="com.jaspersoft.studio.field.tree.path" value="plumaster"/>
</field>
<variable name="sum" class="java.lang.Integer" calculation="Sum">
<variableExpression><![CDATA[$F{price}]]></variableExpression>
<initialValueExpression><![CDATA[0]]></initialValueExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="230" splitType="Stretch">
<staticText>
<reportElement x="190" y="23" width="180" height="30" uuid="b8f34608-86ab-4e09-9fe8-0579fe524724"/>
<box>
<bottomPen lineWidth="1.0" lineColor="#CC9966"/>
</box>
<textElement textAlignment="Center">
<font size="22"/>
</textElement>
<text><![CDATA[御見積書]]></text>
</staticText>
<staticText>
<reportElement x="407" y="63" width="50" height="16" uuid="47f7a7cc-d80e-4409-ab28-80ea7d131a63"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<leftPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[見積書番号]]></text>
</staticText>
<staticText>
<reportElement x="407" y="79" width="50" height="16" uuid="e9c62715-f5b2-46ce-9c21-426dd8832be9"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<leftPen lineWidth="1.0"/>
<bottomPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[見積書日]]></text>
</staticText>
<staticText>
<reportElement x="457" y="79" width="94" height="16" uuid="249cf104-b7b1-4f3f-b948-e7e0c35b6829"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<leftPen lineWidth="1.0"/>
<bottomPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[2018年12月6日]]></text>
</staticText>
<staticText>
<reportElement x="457" y="63" width="94" height="16" uuid="b7c76a46-2bcb-4c06-849f-0f509b0905e2"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<leftPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[No.1234567890]]></text>
</staticText>
<staticText>
<reportElement x="406" y="140" width="146" height="16" uuid="bf7ce692-b2ce-4457-b099-464bd5cf2fe4"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="10"/>
</textElement>
<text><![CDATA[東京都渋谷区初台1ｰ46ｰ3]]></text>
</staticText>
<staticText>
<reportElement x="406" y="123" width="50" height="16" uuid="debe3ab5-6415-4bff-885d-b0b685bb8847"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Bottom">
<font size="9"/>
</textElement>
<text><![CDATA[〒151-0061]]></text>
</staticText>
<staticText>
<reportElement x="406" y="156" width="146" height="16" uuid="8f8540dd-2b07-47a7-9496-e87b95ff323b"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="10"/>
</textElement>
<text><![CDATA[シモモトビル10F]]></text>
</staticText>
<staticText>
<reportElement x="406" y="173" width="146" height="16" uuid="3c8a4b03-9479-494b-82fd-4d0bb4e335a3"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[TEL 03-5302-3760 FAX 03-5371-1592]]></text>
</staticText>
<staticText>
<reportElement x="406" y="107" width="124" height="16" uuid="f3be2acc-5696-4fa7-b4bb-5ee494928700"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="10"/>
</textElement>
<text><![CDATA[株式会社 CXDネクスト]]></text>
</staticText>
<staticText>
<reportElement x="0" y="37" width="70" height="16" uuid="1d54e096-dc80-40b7-9aa1-2df5f1670a08"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[〒151-0061]]></text>
</staticText>
<staticText>
<reportElement x="0" y="54" width="146" height="16" uuid="fdfc9959-2806-4681-a127-ff116a2a712b"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[東京都渋谷区初台1ｰ46ｰ3]]></text>
</staticText>
<staticText>
<reportElement x="0" y="72" width="146" height="16" uuid="e7fd1187-7f25-43a5-99bc-78ddac2be130"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[シモモトビル10F]]></text>
</staticText>
<staticText>
<reportElement x="0" y="89" width="145" height="20" uuid="8c481223-65bd-44f7-9861-1157e3047e1f"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="14"/>
</textElement>
<text><![CDATA[株式会社 CXDネクスト]]></text>
</staticText>
<staticText>
<reportElement x="148" y="93" width="60" height="16" uuid="89f27720-0b96-4de1-9364-942733838c6c"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[御中]]></text>
</staticText>
<staticText>
<reportElement x="1" y="132" width="230" height="16" uuid="73642428-67dc-4ddf-9c63-8dc0872356d8"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[下記のとおり、御見積申し上げます。]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="29" splitType="Stretch">
<staticText>
<reportElement x="0" y="-74" width="80" height="18" uuid="badfce99-c78e-4a4b-a6b1-ff3952d8e4eb"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<leftPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[合計金額]]></text>
</staticText>
<textField>
<reportElement x="80" y="-74" width="120" height="18" uuid="ce31f9b6-b555-42e5-988a-2ed7d7e0d993"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#CC9966"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#CC9966"/>
</box>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$V{sum}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="-55" width="80" height="18" uuid="c930972f-6756-4e27-ba40-97363aff3113"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<leftPen lineWidth="1.0"/>
<bottomPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[支払条件]]></text>
</staticText>
<staticText>
<reportElement x="0" y="-37" width="80" height="18" uuid="fcf2d64d-b38a-4417-bb2f-99c05548055b"/>
<box>
<pen lineColor="#CC9966"/>
<leftPen lineWidth="1.0"/>
<bottomPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[有効期間]]></text>
</staticText>
<staticText>
<reportElement x="80" y="-55" width="120" height="18" uuid="d746403a-7c12-4ad2-b58d-6dda5a167e20"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<leftPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[月末締め翌月末払い]]></text>
</staticText>
<staticText>
<reportElement x="80" y="-37" width="120" height="18" uuid="63894a47-08ef-4793-aa70-e9707ede3606"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<leftPen lineWidth="1.0"/>
<bottomPen lineWidth="1.0"/>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[見積後一ヶ月]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="16" splitType="Stretch">
<staticText>
<reportElement x="0" y="0" width="100" height="16" uuid="06e096d3-211d-4499-a52d-ac730ed416d0"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[番号]]></text>
</staticText>
<staticText>
<reportElement x="100" y="0" width="130" height="16" uuid="8903f234-cbcb-42b8-9d33-9393d44c12bc"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[商品コード]]></text>
</staticText>
<staticText>
<reportElement x="231" y="0" width="130" height="16" uuid="712e15fa-ebcc-4ca6-8a7c-3cfa9eb7e10e"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[商品名]]></text>
</staticText>
<staticText>
<reportElement x="360" y="0" width="170" height="16" uuid="9e92e40a-5d0b-40a3-b231-b109ad6e22f7"/>
<textElement textAlignment="Right" verticalAlignment="Middle"/>
<text><![CDATA[金額]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="20" splitType="Stretch">
<frame>
<reportElement style="Row" mode="Opaque" x="0" y="0" width="550" height="20" uuid="fa7cec56-4ec1-48e6-a26e-7266a995d174"/>
<box>
<pen lineColor="#CC9966"/>
<topPen lineWidth="1.0"/>
<bottomPen lineWidth="1.0"/>
</box>
</frame>
<textField>
<reportElement x="0" y="0" width="100" height="16" uuid="b2ca6b23-5bd6-44b6-b8a1-424e3d9ab122"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="100" y="0" width="130" height="16" uuid="5d2b0aee-6d36-4ccb-845c-4da19e2b9a43"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="230" y="0" width="130" height="16" uuid="b6301163-1d67-423b-bf88-5ff7b521493d"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="360" y="0" width="170" height="16" uuid="b383cbaa-67f0-40e8-b5e5-d0085700866e"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Right" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{price}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch">
<textField pattern="#,##0.###円">
<reportElement x="440" y="0" width="90" height="30" uuid="180a0589-e4b1-493c-b7ae-71f4a575fef5"/>
<box>
<pen lineColor="#CC9966"/>
<bottomPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="18"/>
</textElement>
<textFieldExpression><![CDATA[$V{sum}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="360" y="1" width="80" height="29" uuid="f5a8dbb2-f468-4ad6-ae60-230936f9780e"/>
<box>
<pen lineColor="#CC9966"/>
<bottomPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="18"/>
</textElement>
<text><![CDATA[累計]]></text>
</staticText>
</band>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>
