Discussoes de Programacao e Tecnologia

[RESOLVIDO] Relatorio com JasperReport - Dúvida

3 respostas
javamysql
R
Richard_Nixon

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…

Imagem colada1267×624 113 KB

Alguem sabe me dar uma luz de me dizer o que devo fazer para que apareçam os dois itens?

Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

3 Respostas

D
drsmachado

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?

R
Richard_Nixon

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>
R
Richard_Nixon

Já consegui a solução amigos, o ideal é trabalhar com um componente que faz sub-relatorios.

Criado 30 de janeiro de 2017
Ultima resposta 6 de fev. de 2017
Respostas 3
Participantes 2

Topicos relacionados

Rodar comando diariamente sem aplicação estar aberta 13 respostas [RESOLVIDO] iReport com subReport e Java em Netbeans Resolvido 4 respostas Problemas com conectar a um banco de dados usando jdbc Resolvido 6 respostas Botão de logar não realiza a ação Resolvido 8 respostas Sistema de venda 6 respostas
Alura Git Flow: entenda o que é, como e quando utilizar Entenda o que é Git Flow, como funciona seu fluxo com branches como Master, Develop, Feature, Release e Hotfix, além de vantagens e desvantagens.
Casa do Codigo Back-end Java: Microsservicos, Spring Boot e Kubernetes Por Eduardo Felipe Zambom Santana — Casa do Codigo