Estou tentando incluir um subreport no report
package br.com.ghnetsoft.eventos.pedido.service;
import static br.com.ghnetsoft.eventos.pedido.model.enuns.TipoCaixaEnum.DIARIO;
import static br.com.ghnetsoft.eventos.pedido.model.enuns.TipoCaixaEnum.buscarTipoCaixaEnum;
import static br.com.ghnetsoft.eventos.pedido.model.enuns.UsuarioPerfilEnum.ADMINISTRADOR;
import static br.com.ghnetsoft.eventos.pedido.model.enuns.UsuarioPerfilEnum.OPERADOR;
import static br.com.ghnetsoft.principal.mensagem.MensagensRegra.ME_0040;
import static br.com.ghnetsoft.principal.mensagem.MensagensRegra.getMensagemArquivoImagem;
import static br.com.ghnetsoft.principal.util.DateTimeUtil.DD_MM_YYYY_HH_MM_SS;
import static br.com.ghnetsoft.principal.util.DateTimeUtil.converterLocalDateTimeParaString;
import static br.com.ghnetsoft.principal.util.PrincipalUtil.mascaraCep;
import static br.com.ghnetsoft.principal.util.PrincipalUtil.mascaraCnpjCpf;
import static java.util.stream.Collectors.joining;
import java.net.URL;
import java.time.LocalDateTime;
import java.util.Collection;
import java.util.HashSet;
import java.util.Map;
import java.util.Set;
import javax.validation.ConstraintViolation;
import org.apache.commons.collections4.map.HashedMap;
import org.apache.commons.lang3.tuple.Pair;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import br.com.ghnetsoft.eventos.pedido.client.ClienteCategoriaEventoClient;
import br.com.ghnetsoft.eventos.pedido.client.ClienteCategoriaUsuarioClient;
import br.com.ghnetsoft.eventos.pedido.client.ClienteClient;
import br.com.ghnetsoft.eventos.pedido.client.EmpresaClient;
import br.com.ghnetsoft.eventos.pedido.client.UsuarioLogadoClient;
import br.com.ghnetsoft.eventos.pedido.dto.EmpresaInternoDTO;
import br.com.ghnetsoft.eventos.pedido.dto.FechamentoCaixaFormDTO;
import br.com.ghnetsoft.eventos.pedido.model.Pedido;
import br.com.ghnetsoft.eventos.pedido.model.outro.Cliente;
import br.com.ghnetsoft.eventos.pedido.model.outro.Usuario;
import br.com.ghnetsoft.eventos.pedido.preencher.PedidoRelatorioPreencher;
import br.com.ghnetsoft.eventos.pedido.regra.fechamentocaixa.FechamentoCaixaRegra;
import br.com.ghnetsoft.principal.exception.GeralException;
import br.com.ghnetsoft.principal.service.PrincipalService;
import lombok.extern.slf4j.Slf4j;
import net.sf.jasperreports.engine.JRDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;
@Slf4j
@Service
public class FechamentoCaixaService extends PrincipalService {
private static final long serialVersionUID = -8271008341570437488L;
@Autowired
private PedidoService pedidoService;
@Autowired
private UsuarioLogadoClient usuarioLogadoClient;
@Autowired
private ClienteClient clienteClient;
@Autowired
private ClienteCategoriaEventoClient clienteCategoriaEventoClient;
@Autowired
private ClienteCategoriaUsuarioClient clienteCategoriaUsuarioClient;
@Autowired
private PedidoRelatorioPreencher pedidoRelatorioPreencher;
@Autowired
private EmpresaClient empresaClient;
public byte[] relatorio(final FechamentoCaixaFormDTO dto) {
try {
log.info("relatorio - dto: " + dto.toString());
validar(dto);
final Cliente cliente = clienteClient.buscarPorId(dto.getIdCliente());
if (buscarTipoCaixaEnum(dto.getCaixa()) == DIARIO) {
}
final Pair<LocalDateTime, LocalDateTime> periodo = periodo(dto);
final LocalDateTime de = periodo.getLeft();
final LocalDateTime ate = periodo.getRight();
final Usuario usuario = usuarioLogadoClient.buscarUsuarioLogado();
log.info("caixa - usuario: " + usuario.toString());
final Set<String> idEventos = eventos(usuario, dto.getIdCliente());
final Collection<Pedido> entidades = buscarInformacao(de, ate, usuario, idEventos);
final JRDataSource dataSource = new JRBeanCollectionDataSource(pedidoRelatorioPreencher.dto(entidades));
final EmpresaInternoDTO empresa = empresaClient.buscarEmpresa();
final Map<String, Object> parametros = new HashedMap<>();
parametros.put("emitidoPor", usuario.getNome().toUpperCase());
parametros.put("estabelecimento", cliente.getNomeRazaoSocial());
parametros.put("dataRelatorio", converterLocalDateTimeParaString(de, DD_MM_YYYY_HH_MM_SS) + " - " + converterLocalDateTimeParaString(ate, DD_MM_YYYY_HH_MM_SS));
parametros.put("nomeEmpresa", empresa.getEmpresa().getRazaoSocial());
parametros.put("cnpjEmpresa", mascaraCnpjCpf(empresa.getEmpresa().getCnpj()));
parametros.put("enderecoUm", empresa.getEmpresaEndereco().getLogradouro() + ", " + empresa.getEmpresaEndereco().getNumero());
parametros.put("enderecoDois", empresa.getEmpresaEndereco().getBairro() + " - " + empresa.getEmpresaEndereco().getMunicipio());
parametros.put("enderecoTres", empresa.getEmpresaEndereco().getEstado().getDescricao() + " - " + mascaraCep(empresa.getEmpresaEndereco().getCep()));
parametros.put("enderecoQuatro", empresa.getEmpresa().getSite());
final URL web = getClass().getResource("/relatorio/FechamentoCaixaDiarioFooter.jasper");
parametros.put("FechamentoCaixaDiarioFooter", web.toString());
return JasperRunManager.runReportToPdf(getClass().getClassLoader().getResourceAsStream("relatorio/FechamentoCaixaDiario.jasper"), parametros, dataSource);
} catch (final JRException e) {
log.error(e.getMessage(), e);
throw new GeralException(getMensagemArquivoImagem("download", "Fechamento de caixa diário"));
}
}
public void verificar(final FechamentoCaixaFormDTO dto) {
log.info("verificar - dto: " + dto.toString());
validar(dto);
clienteClient.buscarPorId(dto.getIdCliente());
final Pair<LocalDateTime, LocalDateTime> periodo = periodo(dto);
final Usuario usuario = usuarioLogadoClient.buscarUsuarioLogado();
log.info("caixa - usuario: " + usuario.toString());
buscarInformacao(periodo.getLeft(), periodo.getRight(), usuario, eventos(usuario, dto.getIdCliente()));
}
private Set<String> eventos(final Usuario usuario, final String idCliente) {
final Set<String> idEventos = new HashSet<>();
if (ADMINISTRADOR != usuario.getPerfil()) {
if (OPERADOR == usuario.getPerfil()) {
clienteCategoriaUsuarioClient.existeEventosPorUsuarioLogado().forEach(entidade -> idEventos.add(entidade.getId()));
} else {
clienteCategoriaEventoClient.buscarEventosPorUsuarioLogado().forEach(entidade -> idEventos.add(entidade.getId()));
}
} else {
clienteCategoriaEventoClient.eventosCliente(idCliente).forEach(entidade -> idEventos.add(entidade.getId()));
}
return idEventos;
}
private Collection<Pedido> buscarInformacao(final LocalDateTime de, final LocalDateTime ate, final Usuario usuario, final Set<String> idEventos) {
final Collection<Pedido> pedidos = pedidoService.caixa(de, ate, usuario, idEventos);
if ((pedidos == null) || pedidos.isEmpty()) {
throw new GeralException(ME_0040);
}
return pedidos;
}
private Pair<LocalDateTime, LocalDateTime> periodo(final FechamentoCaixaFormDTO dto) {
LocalDateTime de;
LocalDateTime ate;
if (buscarTipoCaixaEnum(dto.getCaixa()) == DIARIO) {
de = LocalDateTime.of(dto.getData().getYear(), dto.getData().getMonthValue(), dto.getData().getDayOfMonth(), 0, 0, 0);
ate = LocalDateTime.of(dto.getData().getYear(), dto.getData().getMonthValue(), dto.getData().getDayOfMonth(), 23, 59, 59);
} else {
de = LocalDateTime.of(dto.getStart().getYear(), dto.getStart().getMonthValue(), dto.getStart().getDayOfMonth(), 0, 0, 0);
ate = LocalDateTime.of(dto.getEnd().getYear(), dto.getEnd().getMonthValue(), dto.getEnd().getDayOfMonth(), 23, 59, 59);
}
return Pair.of(de, ate);
}
private void validar(final FechamentoCaixaFormDTO dto) {
log.info("validar - dto: " + dto.toString());
final Set<ConstraintViolation<FechamentoCaixaFormDTO>> violations = validator.validate(dto, FechamentoCaixaRegra.class);
if (!violations.isEmpty()) {
throw new GeralException(violations.stream().map(ConstraintViolation::getMessage).collect(joining("\n")));
}
}
}
report: FechamentoCaixaDiario
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928 -->
<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="FechamentoCaixaDiario" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="cf558b13-83cf-46c7-a581-16f4f3de5a80">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<parameter name="emitidoPor" class="java.lang.String"/>
<parameter name="estabelecimento" class="java.lang.String"/>
<parameter name="dataRelatorio" class="java.lang.String"/>
<parameter name="nomeEmpresa" class="java.lang.String"/>
<parameter name="cnpjEmpresa" class="java.lang.String"/>
<parameter name="enderecoDois" class="java.lang.String"/>
<parameter name="enderecoTres" class="java.lang.String"/>
<parameter name="enderecoQuatro" class="java.lang.String"/>
<parameter name="enderecoUm" class="java.lang.String"/>
<parameter name="FechamentoCaixaDiarioFooter" class="java.lang.String"/>
<queryString>
<![CDATA[]]>
</queryString>
<field name="contador" class="java.lang.Integer"/>
<field name="numeroPedido" class="java.lang.String"/>
<field name="buyerPaid" class="java.math.BigDecimal"/>
<field name="tipoPagamento" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="129" splitType="Stretch">
<textField>
<reportElement x="230" y="7" width="319" height="15" uuid="ccedbbd5-e6f4-4a4b-9d51-edb56be91afa">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$P{nomeEmpresa}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="270" y="27" width="279" height="15" uuid="0e1937f2-bd6a-4987-8767-90b270070dc2">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>
<font isBold="false"/>
</textElement>
<textFieldExpression><![CDATA[$P{cnpjEmpresa}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="230" y="27" width="40" height="15" uuid="d0d49db0-cac8-4429-95fd-722e7e78748f">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[CNPJ:]]></text>
</staticText>
<textField>
<reportElement x="230" y="47" width="319" height="15" uuid="3d820b92-9b0d-4b16-88cd-d5cb74fafc4a">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$P{enderecoUm}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="230" y="67" width="319" height="15" uuid="86db59b7-766d-40d5-a2df-403aaab9112e">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$P{enderecoDois}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="230" y="87" width="319" height="15" uuid="506bc30c-da9c-4ae0-875d-7bea792cb323">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$P{enderecoTres}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="230" y="107" width="319" height="15" uuid="34aeb39e-7880-4338-bcae-6c22a9995b72">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$P{enderecoQuatro}]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band height="60" splitType="Stretch">
<staticText>
<reportElement x="0" y="0" width="260" height="15" uuid="14863ab7-489d-44d5-9bf2-0993f5ace35b">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[RELATÓRIO – FECHAMENTO DE CAIXA DIÁRIO]]></text>
</staticText>
<staticText>
<reportElement x="0" y="15" width="110" height="15" uuid="516e73b2-4aed-42fa-b184-068e20a228f2">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[ESTABELECIMENTO: ]]></text>
</staticText>
<staticText>
<reportElement x="0" y="30" width="110" height="15" uuid="df2e50c4-4cec-45fb-84a9-6f902066d071">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Emitido por: ]]></text>
</staticText>
<textField>
<reportElement x="110" y="30" width="440" height="14" uuid="26cb5081-0b05-4cb2-91de-66f024ed84bc"/>
<textFieldExpression><![CDATA[$P{emitidoPor}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="110" y="15" width="440" height="14" uuid="1e9d2560-86ed-4166-a06c-ad8555b25659"/>
<textFieldExpression><![CDATA[$P{estabelecimento}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="45" width="550" height="15" uuid="f9f842d8-85ca-412e-aee5-ab8de4746d90">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$P{dataRelatorio}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="15">
<staticText>
<reportElement x="0" y="0" width="30" height="15" uuid="ffd02d67-b401-438e-acd1-ecf18f7948ef">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Nº]]></text>
</staticText>
<staticText>
<reportElement x="30" y="0" width="210" height="15" uuid="2094e485-8407-4c4f-a65f-4af62e286d86">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Número do Pedido]]></text>
</staticText>
<staticText>
<reportElement x="240" y="0" width="150" height="15" uuid="e83ba243-3628-49e7-9711-d49320183720">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Valor Pago]]></text>
</staticText>
<staticText>
<reportElement x="390" y="0" width="164" height="15" uuid="5e6da7e2-d481-4d41-a2a8-f8612cef97a4">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Forma Pagamento]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="15" splitType="Stretch">
<textField>
<reportElement x="0" y="0" width="30" height="15" uuid="58b6a167-2151-4998-9c62-46f0e987957b">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="54881476-4c7f-4d79-bd45-cc8b0f4c62b4"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{contador}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="30" y="0" width="210" height="15" uuid="32c5a0b1-862f-4828-adbe-2a0717b3bccb">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d2e7a095-ccb5-4217-a99e-e78ba5ef07d0"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{numeroPedido}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="240" y="0" width="150" height="15" uuid="21168df0-656d-430a-a08c-a434f5a88c66">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1adf7dab-2034-4fe7-b86f-976a5547a65b"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{buyerPaid}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="390" y="0" width="164" height="15" uuid="e0930989-f6e2-4301-9e69-7a3ce6c4d0b0">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c475338a-f007-4e76-9a8a-18a99d371620"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{tipoPagamento}]]></textFieldExpression>
</textField>
</band>
</detail>
<pageFooter>
<band height="15" splitType="Stretch">
<textField>
<reportElement x="310" y="0" width="244" height="15" uuid="4f031ae7-6387-49ba-8c18-f4e6f923be81">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA["Página " + $V{PAGE_NUMBER} + " de " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="30">
<subreport>
<reportElement x="0" y="0" width="555" height="30" uuid="5db58b5c-1771-45d0-a3c3-85db091de2ec">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{FechamentoCaixaDiarioFooter}]]></subreportExpression>
</subreport>
</band>
</summary>
</jasperReport>
subeport: FechamentoCaixaDiarioFooter
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928 -->
<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="FechamentoCaixaDiario" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="cf558b13-83cf-46c7-a581-16f4f3de5a80">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<queryString>
<![CDATA[]]>
</queryString>
<field name="descricao" class="java.lang.String"/>
<field name="quantidade" class="java.lang.Integer"/>
<field name="total" class="java.math.BigDecimal"/>
<field name="ticketMedio" class="java.lang.Double"/>
<background>
<band splitType="Stretch"/>
</background>
<columnHeader>
<band height="38">
<staticText>
<reportElement x="0" y="23" width="254" height="15" uuid="ffd02d67-b401-438e-acd1-ecf18f7948ef">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Descrição]]></text>
</staticText>
<staticText>
<reportElement x="254" y="23" width="100" height="15" uuid="2094e485-8407-4c4f-a65f-4af62e286d86">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Quantidade do Item]]></text>
</staticText>
<staticText>
<reportElement x="354" y="23" width="100" height="15" uuid="e83ba243-3628-49e7-9711-d49320183720">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Total]]></text>
</staticText>
<staticText>
<reportElement x="454" y="23" width="100" height="15" uuid="5e6da7e2-d481-4d41-a2a8-f8612cef97a4">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Ticket Médio]]></text>
</staticText>
<staticText>
<reportElement x="0" y="0" width="80" height="15" uuid="07393fa3-d73f-47a2-9564-243f2603723b">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
<pen lineWidth="0.5"/>
<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">
<font isBold="true"/>
</textElement>
<text><![CDATA[RESUMO DIA]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="15" splitType="Stretch">
<textField>
<reportElement x="0" y="0" width="254" height="15" uuid="58b6a167-2151-4998-9c62-46f0e987957b">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="54881476-4c7f-4d79-bd45-cc8b0f4c62b4"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Left"/>
<textFieldExpression><![CDATA[$F{descricao}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="254" y="0" width="100" height="15" uuid="32c5a0b1-862f-4828-adbe-2a0717b3bccb">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d2e7a095-ccb5-4217-a99e-e78ba5ef07d0"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{quantidade}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="354" y="0" width="100" height="15" uuid="21168df0-656d-430a-a08c-a434f5a88c66">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1adf7dab-2034-4fe7-b86f-976a5547a65b"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{total}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="454" y="0" width="100" height="15" uuid="e0930989-f6e2-4301-9e69-7a3ce6c4d0b0">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c475338a-f007-4e76-9a8a-18a99d371620"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<box>
<pen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{ticketMedio}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
Como passar uma lista para um subreport.
Não está dando nenhum erro. Mas nem a parte fixa do subreport aparece.
Como resolver ?