Prezados, sou iniciante em java, a alguns dias venho desenvolvendo um relatorio atraves do Jasper Report, porem em certo momento me deparei com a seguinte situação apos fazer os inners joins do relatorio, o campo por exemplo, “Variaveis de Risco” traz apenas 1 item e quando utilizo a query que fiz para gerar este relatorio dentro do “Mysql Workbench” por exemplo, ele me traz todos os itens que deveriam constar no relátorio…
Alguem sabe me dar uma luz de me dizer o que devo fazer para que apareçam os dois itens?
Tem mesmo certeza que o resultado é um apenas ou o espaço dedicado a ele é que não está se expandindo ou comportando os resultados?
Por mais que eu aumente o espaço dedicado, ele não me traz os itens vinculados, será que dentro do codigo do relatorio eu preciso adicionar algum parametro para printar todos os resultados?
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 -->
<!-- 2017-01-30T13:24:31 -->
<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="PARECER" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6febb442-ff88-4539-9e5b-88ceaa50891a">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="SGI Data Adapter "/>
<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="224"/>
<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="768"/>
<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="453"/>
<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="533"/>
<parameter name="ID_PARECER" class="java.lang.Integer"/>
<queryString language="SQL">
<![CDATA[SELECT
db_seagi.parecerevento.promotor,
db_seagi.parecerevento.dataevento,
db_seagi.parecerevento.evento,
db_seagi.parecerevento.lotacaopermitida,
db_seagi.parecerevento.publicoestimado,
db_seagi.parecerevento.endereco,
db_seagi.variaveisriscoevento.nome AS VarRiscoEvento,
db_seagi.naturezaevento.nome AS NaturezaEvento,
db_seagi.abrangenciaevento.nome AS Abrangenciaevento,
db_seagi.origem.nome AS Origem,
db_seagi.statusparecerevento.nome AS StatusParecer,
db_seagi.categoriacomplexidadeevento.nome AS Complexidade,
db_seagi.categoriariscoevento.nome AS AnaliseRisco
FROM db_seagi.parecerevento
INNER JOIN origem ON parecerevento.origem_codigo=origem.codigo
INNER JOIN statusparecerevento
ON parecerevento.statusparecerevento_codigo=statusparecerevento.codigo
INNER JOIN abrangenciaevento
ON parecerevento.abrangenciaevento_codigo=abrangenciaevento.codigo
INNER JOIN naturezaevento
ON parecerevento.naturezaevento_codigo=naturezaevento.codigo
INNER JOIN parecerevento_variaveisriscoevento
ON parecerevento.codigo=parecerevento_variaveisriscoevento.parecerevento_codigo
INNER JOIN variaveisriscoevento
ON parecerevento_variaveisriscoevento.variaveisriscoeventos_codigo=variaveisriscoevento.codigo
INNER JOIN parecerevento_categoriacomplexidadeevento
ON parecerevento.codigo=parecerevento_categoriacomplexidadeevento.parecerevento_codigo
INNER JOIN categoriacomplexidadeevento
ON parecerevento_categoriacomplexidadeevento.categoriacomplexidadeeventos_codigo
=categoriacomplexidadeevento.codigo
INNER JOIN parecerevento_categoriariscoevento
ON parecerevento.codigo=parecerevento_categoriariscoevento.parecerevento_codigo
INNER JOIN categoriariscoevento
ON parecerevento_categoriariscoevento.categoriariscoeventos_codigo=categoriariscoevento.codigo
WHERE
db_seagi.parecerevento.codigo = $P{ID_PARECER}]]>
</queryString>
<field name="promotor" class="java.lang.String"/>
<field name="dataevento" class="java.sql.Date"/>
<field name="evento" class="java.lang.String"/>
<field name="lotacaopermitida" class="java.lang.Integer"/>
<field name="publicoestimado" class="java.lang.Integer"/>
<field name="endereco" class="java.lang.String"/>
<field name="VarRiscoEvento" class="java.lang.String"/>
<field name="NaturezaEvento" class="java.lang.String"/>
<field name="Abrangenciaevento" class="java.lang.String"/>
<field name="Origem" class="java.lang.String"/>
<field name="StatusParecer" class="java.lang.String"/>
<field name="Complexidade" class="java.lang.String"/>
<field name="AnaliseRisco" class="java.lang.String"/>
<title>
<band height="129" splitType="Stretch">
<image>
<reportElement x="265" y="2" width="50" height="50" uuid="a8ccfea4-cb16-4c2b-be9e-31193f89cc4b"/>
<imageExpression><![CDATA["WebContent/resources/imagens/Simbolo-do-Amazonas-Brasao-do-Amazonas.png"]]></imageExpression>
</image>
<staticText>
<reportElement x="180" y="54" width="200" height="20" uuid="f3018f2a-cc0f-4c49-b6fe-ef9055694435"/>
<text><![CDATA[GOVERNO DO ESTADO DO AMAZONAS]]></text>
</staticText>
<staticText>
<reportElement x="155" y="67" width="263" height="20" uuid="83db20ad-5b95-4141-b25f-7865e9eb8849"/>
<text><![CDATA[SECRETARIA DE ESTADO DE SEGURANÇA PÚBLICA]]></text>
</staticText>
<staticText>
<reportElement x="118" y="79" width="329" height="20" uuid="18c921a6-cd0f-4fc1-b67e-5db35e266528"/>
<text><![CDATA[SECRETARIA EXECUTIVA ADJUNTA DE PLANEJAMENTO E GESTÃO ]]></text>
</staticText>
<staticText>
<reportElement x="206" y="91" width="149" height="21" uuid="f5fccb6f-d1c3-4806-8f75-48c83bf8bff7"/>
<text><![CDATA[INTEGRADA DE SEGURANÇA]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="440">
<staticText>
<reportElement x="107" y="-20" width="353" height="30" uuid="23bdbefb-182f-4c60-9e71-899b4de0351a"/>
<textElement>
<font size="12" isBold="true" isUnderline="true"/>
</textElement>
<text><![CDATA[PARECER DE CLASSIFICAÇÃO DE GRANDE EVENTO]]></text>
</staticText>
<rectangle>
<reportElement x="340" y="0" width="200" height="69" uuid="c70c9375-138c-4193-85ca-62b3f2f7a41c"/>
</rectangle>
<staticText>
<reportElement x="408" y="7" width="70" height="19" uuid="4bb8edff-e870-4cae-a1cf-d4731f0c4aa3"/>
<textElement textAlignment="Center"/>
<text><![CDATA[A P R O V O]]></text>
</staticText>
<staticText>
<reportElement x="393" y="50" width="100" height="19" uuid="09030fd5-0905-4b77-bba7-167ded2aa0d3"/>
<textElement textAlignment="Center"/>
<text><![CDATA[Secretário SSP/AM]]></text>
</staticText>
<line>
<reportElement x="389" y="44" width="109" height="1" uuid="2eae8d0e-ab03-424f-947f-7360efe42019"/>
</line>
<frame>
<reportElement x="20" y="0" width="270" height="69" uuid="734a3e2f-d232-45ac-ac4c-f87ef842eabf"/>
<rectangle>
<reportElement x="0" y="-2" width="270" height="69" uuid="be18eee8-d23f-4efd-82f4-1d2f5c87f399"/>
</rectangle>
<textField>
<reportElement x="59" y="-2" width="210" height="16" uuid="fac227c9-ae5e-4944-831f-24a04e8d26bc"/>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{evento}]]></textFieldExpression>
</textField>
</frame>
<staticText>
<reportElement x="22" y="52" width="100" height="17" uuid="821b5121-df8b-45be-986e-2af89ec67584"/>
<textElement>
<font size="11" isBold="true"/>
</textElement>
<text><![CDATA[ENDEREÇO:]]></text>
</staticText>
<staticText>
<reportElement x="21" y="36" width="80" height="16" uuid="2fdadb70-e3fe-4c36-a251-e7cf640b99a0"/>
<textElement>
<font size="11" isBold="true"/>
</textElement>
<text><![CDATA[PROMOTOR:]]></text>
</staticText>
<staticText>
<reportElement x="22" y="0" width="63" height="21" uuid="ca74d492-f96b-4286-94e0-100ecdab362e"/>
<textElement>
<font size="11" isBold="true"/>
</textElement>
<text><![CDATA[EVENTO:]]></text>
</staticText>
<staticText>
<reportElement x="22" y="17" width="42" height="22" uuid="4ac610c2-c387-4914-8bcd-e957ab1d1fe8"/>
<textElement>
<font size="11" isBold="true"/>
</textElement>
<text><![CDATA[DATA:]]></text>
</staticText>
<line>
<reportElement x="20" y="49" width="270" height="1" uuid="c998d298-5f68-49e5-831a-95fa0b852406"/>
</line>
<line>
<reportElement x="20" y="32" width="270" height="1" uuid="c0da826a-10c3-4b1e-903e-d46025b94287"/>
</line>
<line>
<reportElement x="21" y="15" width="270" height="1" uuid="5200d743-19b6-4afc-ae61-0e23fa5e1d53"/>
</line>
<rectangle>
<reportElement x="18" y="80" width="522" height="68" uuid="a726902a-0802-4053-a8eb-d3a2e2ca0138"/>
</rectangle>
<line>
<reportElement x="18" y="92" width="522" height="1" uuid="b02583cc-15cd-4157-aec1-30e4fb3a32b2"/>
</line>
<line>
<reportElement x="18" y="106" width="522" height="1" uuid="26c2d523-309d-4318-97db-283949366a5d"/>
</line>
<line>
<reportElement x="18" y="120" width="522" height="1" uuid="04d5b39a-ef33-46fd-bd6e-482e599edc8b"/>
</line>
<line>
<reportElement x="18" y="134" width="522" height="1" uuid="6a0f6c66-6959-4da3-a682-9e99b1cd0fc6"/>
</line>
<rectangle>
<reportElement x="18" y="148" width="262" height="111" uuid="920bdd6c-1751-46be-900f-5a1af387ba68"/>
</rectangle>
<rectangle>
<reportElement x="280" y="148" width="260" height="111" uuid="01a9b1e1-f5d9-4d04-98e0-b9f80fdbe388"/>
</rectangle>
<staticText>
<reportElement x="26" y="81" width="52" height="13" uuid="4fcfd6c4-a280-44a1-b540-5d71bf0c5186"/>
<textElement textAlignment="Left"/>
<text><![CDATA[Natureza:]]></text>
</staticText>
<staticText>
<reportElement x="26" y="94" width="70" height="12" uuid="8673b5d6-85e3-4cbf-9e2b-263f037623c4"/>
<text><![CDATA[Abrangência:]]></text>
</staticText>
<staticText>
<reportElement x="26" y="108" width="44" height="12" uuid="73753d59-8a98-47c1-9276-634b79e12c88"/>
<text><![CDATA[Origem:]]></text>
</staticText>
<staticText>
<reportElement x="27" y="123" width="91" height="12" uuid="7e525119-5349-4891-b19b-8b25198f0b6e"/>
<text><![CDATA[Público Estimado:]]></text>
</staticText>
<staticText>
<reportElement x="26" y="136" width="100" height="12" uuid="4e13a9f9-007a-46bb-a17e-79e586251023"/>
<text><![CDATA[Lotação Permitida:]]></text>
</staticText>
<staticText>
<reportElement x="24" y="150" width="256" height="15" uuid="272abd47-e3c4-4f73-a267-3398be57fd0e"/>
<textElement>
<font isBold="true" isUnderline="true"/>
</textElement>
<text><![CDATA[Variáveis de Risco:]]></text>
</staticText>
<staticText>
<reportElement x="286" y="152" width="254" height="13" uuid="bb518459-b973-49cf-b5a6-f3a6e0b7ebdb"/>
<textElement>
<font isBold="true" isUnderline="true"/>
</textElement>
<text><![CDATA[Complexidade:]]></text>
</staticText>
<rectangle>
<reportElement x="18" y="259" width="522" height="181" uuid="d348440f-ce89-4c8f-afcb-07e43f6ae2a8"/>
</rectangle>
<staticText>
<reportElement x="20" y="260" width="519" height="19" uuid="642e129d-f01e-45ee-b2f2-8a9c563e4f6e"/>
<textElement>
<font isBold="true" isUnderline="true"/>
</textElement>
<text><![CDATA[Análises de Risco:]]></text>
</staticText>
<staticText>
<reportElement x="328" y="81" width="111" height="13" uuid="7876deb2-13f9-4a2a-8419-4b59740f509e"/>
<textElement textAlignment="Left"/>
<text><![CDATA[Status do Relátorio:]]></text>
</staticText>
<textField>
<reportElement x="99" y="36" width="192" height="13" uuid="96645513-a598-4b2b-91da-ae3c5da1a99c"/>
<textFieldExpression><![CDATA[$F{promotor}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy">
<reportElement stretchType="RelativeToBandHeight" x="63" y="17" width="227" height="16" uuid="7d3d15f2-b420-47e9-96a0-171fa313c132"/>
<textElement textAlignment="Left"/>
<textFieldExpression><![CDATA[$F{dataevento}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="96" y="50" width="188" height="17" uuid="cee32a1b-f1ed-46f1-8739-09865bf1eb86"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{endereco}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="26" y="165" width="302" height="175" uuid="04f6219f-9d30-4b0a-af31-16ea87933020"/>
<textFieldExpression><![CDATA[$F{VarRiscoEvento}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="78" y="80" width="250" height="12" uuid="c4b657bb-747f-4282-9368-c253ef0dead9"/>
<textFieldExpression><![CDATA[$F{NaturezaEvento}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="95" y="94" width="231" height="14" uuid="c98a3231-f0c3-4b5d-bba7-07b7dca26858"/>
<textFieldExpression><![CDATA[$F{Abrangenciaevento}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="68" y="108" width="175" height="14" uuid="9fb5ddd6-5851-45a4-9964-dd1bc1155d37"/>
<textFieldExpression><![CDATA[$F{Origem}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="117" y="122" width="108" height="12" uuid="e555cd56-e850-4464-b00f-b94d139d8056"/>
<textFieldExpression><![CDATA[$F{publicoestimado}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="120" y="136" width="118" height="13" uuid="220b1129-4fae-4daf-b259-a5f46f3b9a17"/>
<textFieldExpression><![CDATA[$F{lotacaopermitida}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="286" y="165" width="254" height="85" uuid="2c05c33e-dfcb-4398-8aad-1d0efd0e1650"/>
<textFieldExpression><![CDATA[$F{Complexidade}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="20" y="279" width="519" height="160" uuid="a8162a98-8627-480f-abb0-0900737d1e1d"/>
<textFieldExpression><![CDATA[$F{AnaliseRisco}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="427" y="81" width="100" height="13" uuid="023a4dc7-97c3-41a7-b888-8ca66c5a5318"/>
<textFieldExpression><![CDATA[$F{StatusParecer}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="154" splitType="Stretch">
<staticText>
<reportElement x="19" y="34" width="522" height="90" uuid="edb0d0bb-a7a9-4a18-9400-5ae053b9c897"/>
<text><![CDATA[Com base nas competências da Lei n.4.163, no DOE n. 32.997, de 9 de março de 2015 e Decreto n°34895 de 20 junho de 2014 e da portaria n° 0002 GS-SSP de 01 de abril de 2015 a Operação , a ser realizada no dia , está enquadrado como: , portanto deve receber o aporte de segurança e socorre público que os grandes eventos demandam.]]></text>
</staticText>
<staticText>
<reportElement x="20" y="19" width="88" height="18" uuid="27ba2828-316c-4fcb-aacc-16768af7ca9b"/>
<textElement>
<font isBold="false" isUnderline="true"/>
</textElement>
<text><![CDATA[Enquadramento:]]></text>
</staticText>
<staticText>
<reportElement x="355" y="101" width="193" height="25" uuid="c7cdb271-cffa-4506-969f-413b46950db9"/>
<text><![CDATA[Manaus -Am, ]]></text>
</staticText>
</band>
</columnHeader>
<columnFooter>
<band height="50">
<staticText>
<reportElement x="49" y="15" width="163" height="16" uuid="f42589d5-73a3-409c-8217-2f854f7f316a"/>
<text><![CDATA[Ch Dep Plan Int -SEAGI/SSP-AM]]></text>
</staticText>
<line>
<reportElement x="57" y="10" width="146" height="1" uuid="5df28711-af5e-42ea-9199-24ae7b911d3b"/>
</line>
<staticText>
<reportElement x="352" y="13" width="136" height="15" uuid="62db7659-ab00-45a5-8476-e389b3977565"/>
<text><![CDATA[Resp. pela SEAGI/SSP-AM]]></text>
</staticText>
<line>
<reportElement x="341" y="10" width="152" height="1" uuid="c64a0d59-0385-4c61-86a6-0db0a1aeeb64"/>
</line>
</band>
</columnFooter>
</jasperReport>
Já consegui a solução amigos, o ideal é trabalhar com um componente que faz sub-relatorios.
