erickdeoliveiraleal

Used the Jasper Studio plugin for Eclipse, Eclipse asked to update to version 2021-03, I updated, Jasper Studio stopped working. Every time you update Eclipse, the plugin stops working. Why does Tibco not adopt a more proactive stance like other plug-in providers and already makes its plugin compatible with the current Eclipse version? Is there a deadline for it to be compatible with version 2021-03?

I solved my problem using $P{listaDias}.cloneDataSource() but I don't know why. I just saw the method and tried it.

I have 2 datasources, SQL used in Master report, and a JRColletion as parameter to a table in details section. The table only prints one time. I want it to repeat every page, how can i do it? pdf: https://expirebox.com/download/f142b4e2bafa063f124f2f02f04dd700.html jrxml:https://expirebox.com/download/084004a4c8114a40684e721a60995aab.html <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1 --><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" whenNoDataType="NoDataSection" columnWidth="575" leftMargin="10" rightMargin="10" topMargin="10" bottomMargin="10" uuid="b7e4dcc6-52fe-4220-9766-9cff19793ada"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="local"/> <style name="Table_TH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_CH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Dataset1" uuid="aaef60af-4612-400f-9cd5-127fb6ba737f"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <queryString> <![CDATA[]]> </queryString> </subDataset> <subDataset name="Dataset3" uuid="627032cc-5941-4ece-8024-efed85d73113"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="segad"/> <parameter name="turno" class="java.lang.String"/> <parameter name="listaDias" class="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource" isForPrompting="false"/> <queryString> <![CDATA[]]> </queryString> <field name="dia" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="DIA"/> </field> <field name="texto" class="java.lang.String"/> </subDataset> <parameter name="ano" class="java.lang.Integer" isForPrompting="false"> <defaultValueExpression><![CDATA["201712"]]></defaultValueExpression> </parameter> <parameter name="idUp" class="java.lang.Integer"> <defaultValueExpression><![CDATA[107]]></defaultValueExpression> </parameter> <parameter name="mesExtenso" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["Janeiro"]]></defaultValueExpression> </parameter> <parameter name="turno" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["EXPEDIENTE"]]></defaultValueExpression> </parameter> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["C:relatorios"]]></defaultValueExpression> </parameter> <parameter name="listaDias" class="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource" isForPrompting="false"/> <queryString> <![CDATA[select first 2 nome_funcionario, matricula,CARGO,SIGLA,POSTO_TRABALHO from funcionario FLEFT JOIN UNIDADE_PENAL U ON U.ID_UP = F.ID_UPLEFT JOIN POSTO_TRABALHO P ON P.IDPOSTO_TRABALHO = F.IDPOSTO_TRABALHO where F.id_up = $P{idUp} AND F.PLANTAO_EXPEDIENTE= $P{turno} order by nome_funcionario]]> </queryString> <field name="NOME_FUNCIONARIO" class="java.lang.String"/> <field name="MATRICULA" class="java.lang.String"/> <field name="CARGO" class="java.lang.String"/> <field name="SIGLA" class="java.lang.String"/> <field name="POSTO_TRABALHO" class="java.lang.String"/> <pageHeader> <band height="80"> <image> <reportElement x="0" y="0" width="80" height="80" uuid="4e440bf7-7f78-4920-a68f-9ddc3037862e"/> <imageExpression><![CDATA[$P{SUBREPORT_DIR}+"gdf.png"]]></imageExpression> </image> <staticText> <reportElement x="0" y="3" width="575" height="18" uuid="3c395247-ed97-4c8a-b588-cccf135ed073"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="11" isBold="true"/> </textElement> <text><![CDATA[GOVERNO DO DISTRITO FEDERAL]]></text> </staticText> <staticText> <reportElement x="0" y="43" width="575" height="18" uuid="61cd5db9-2891-495a-8a08-6266a72d2288"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="11" isBold="true"/> </textElement> <text><![CDATA[subsecretaria de Administração Geral - SUAG]]></text> </staticText> <staticText> <reportElement x="0" y="23" width="575" height="18" uuid="c58c4731-7ddc-459d-9b3a-db28231a5f52"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="11" isBold="true"/> </textElement> <text><![CDATA[sECRETARIA DE ESTADO DA SEGURANÇA PÚBLICA E DA PAZ SOCIAL]]></text> </staticText> </band> </pageHeader> <detail> <band height="87" splitType="Stretch"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <rectangle> <reportElement mode="Transparent" x="0" y="0" width="575" height="65" uuid="77f441c2-ceb4-4571-a808-b73b5d40fa29"/> <graphicElement> <pen lineWidth="1.0"/> </graphicElement> </rectangle> <staticText> <reportElement x="0" y="0" width="290" height="16" uuid="30a168eb-0290-4ce8-b127-dc2803eb2059"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <box topPadding="0" leftPadding="5" bottomPadding="0" rightPadding="0"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[sISTEMA DE PESSOAL]]></text> </staticText> <staticText> <reportElement x="0" y="16" width="120" height="16" uuid="7c0a2c13-fe92-4b79-8d68-6ffb416e0147"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box topPadding="0" leftPadding="5" bottomPadding="0" rightPadding="0"/> <textElement verticalAlignment="Middle"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[CARGO:]]></text> </staticText> <staticText> <reportElement x="0" y="49" width="120" height="16" uuid="55e66210-42c1-4877-80e3-4643e06889a0"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box leftPadding="5"/> <textElement verticalAlignment="Middle"> <font size="10" isBold="true"/> </textElement> <text><![CDATA[LOTAÇÃO:]]></text> </staticText> <textField> <reportElement x="290" y="69" width="285" height="18" uuid="25ad35c8-a669-490b-9d2f-8662ca61e47c"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="12" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$P{ano}]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="69" width="290" height="18" uuid="17df2331-67e1-4c44-ac56-4ae96f57f531"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="12" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$P{mesExtenso}]]></textFieldExpression> </textField> <staticText> <reportElement x="290" y="0" width="280" height="16" uuid="67d54e0f-b7ba-47e5-a24d-a9db4619d5f9"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <box topPadding="0" leftPadding="5" bottomPadding="0" rightPadding="0"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[FOLHA DE PRESENÇA]]></text> </staticText> <staticText> <reportElement x="0" y="32" width="120" height="16" uuid="80c383cd-e987-4922-82c0-88c4aac8f1a6"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <box topPadding="0" leftPadding="5" bottomPadding="0" rightPadding="0"/> <textElement verticalAlignment="Middle"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[NOME:]]></text> </staticText> </band> <band height="42"> <componentElement> <reportElement positionType="Float" x="0" y="1" width="575" height="30" isPrintInFirstWholeBand="true" uuid="9ad19761-cbd6-4a88-91b2-52423ef251b2"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/> <property name="net.sf.jasperreports.export.headertoolbar.table.name" value=""/> <property name="com.jaspersoft.studio.components.autoresize.proportional" value="true"/> <property name="com.jaspersoft.studio.components.autoresize.next" value="true"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="Blank"> <datasetRun subDataset="Dataset3" uuid="8c0739d2-45a4-4f0d-b990-71b8dba0ed99"> <datasetParameter name="turno"> <datasetParameterExpression><![CDATA[$P{turno}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="listaDias"> <datasetParameterExpression><![CDATA[$P{listaDias}]]></datasetParameterExpression> </datasetParameter> <dataSourceExpression><![CDATA[$P{listaDias}]]></dataSourceExpression> </datasetRun> <jr:column width="64" uuid="fa1e7b8b-75a0-464a-b9fc-4c7de98a96de"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:columnHeader style="Table 1_CH" height="18" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="64" height="18" uuid="7afef1fa-d424-43bd-b091-c5a1fa7315a4"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Dia]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="12"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/> <textField isBlankWhenNull="true"> <reportElement x="0" y="0" width="64" height="12" uuid="f0a4639a-f2f1-428d-9376-f2ec0b7ef84a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="9"/> </textElement> <textFieldExpression><![CDATA[$F{dia}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="214" uuid="ca858e2d-b9fd-4cba-9538-cf01d9a09507"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:columnHeader style="Table 1_CH" height="18" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="214" height="18" uuid="9d7cb4b4-8ea6-4f61-8e37-f7c06dace9a4"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Entrada]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="12"> <textField isBlankWhenNull="true"> <reportElement x="0" y="0" width="214" height="12" uuid="5e91d3a0-ecf5-417d-aa48-cdecc279e4c3"> <printWhenExpression><![CDATA[EQUALS($P{turno},"EXPEDIENTE")]]></printWhenExpression> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="9"/> </textElement> <textFieldExpression><![CDATA[$F{texto}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="219" uuid="a628df56-5963-4ecd-aaf5-df821846f8eb"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <jr:columnHeader style="Table 1_CH" height="18" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="219" height="18" uuid="1211e930-813c-448c-9cd6-6d9ed1e6f3f8"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Assinatura]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="12"> <textField isBlankWhenNull="true"> <reportElement x="0" y="0" width="219" height="12" uuid="4adf777c-bb1a-40c2-8c3d-70680882ddd5"> <printWhenExpression><![CDATA[EQUALS($P{turno},"EXPEDIENTE")]]></printWhenExpression> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="9"/> </textElement> <textFieldExpression><![CDATA[$F{texto}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="78" uuid="3dbe83c4-78b4-43c6-b360-56add80266f6"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> <jr:columnHeader style="Table 1_CH" height="18" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="78" height="18" uuid="6f9e73ec-6e51-45b1-9155-632d2a5fbcd2"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Código]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="12"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </jr:detailCell> </jr:column> </jr:table> </componentElement> <break> <reportElement x="0" y="41" width="99" height="1" uuid="3d02396d-35f7-4956-a046-e44e575bb637"/> </break> </band> </detail> <pageFooter> <band height="226"> <staticText> <reportElement x="0" y="183" width="278" height="14" uuid="974c627d-2014-47f0-ae99-0fec4a868989"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box leftPadding="5"/> <textElement textAlignment="Left"/> <text><![CDATA[ASSINATURA E CARIMBO DO CHEFE IMEDIATO]]></text> </staticText> <rectangle> <reportElement mode="Transparent" x="0" y="179" width="277" height="47" uuid="80221777-7af9-4d58-861a-570ae062b41d"/> </rectangle> <staticText> <reportElement x="278" y="183" width="274" height="14" uuid="efbf36f1-4a2c-4c59-9441-afcc04be2db4"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box leftPadding="5"/> <textElement textAlignment="Left"/> <text><![CDATA[ASSINATURA E CARIMBO DO SUPERIOR HIERÁRQUICO]]></text> </staticText> <rectangle> <reportElement mode="Transparent" x="278" y="179" width="296" height="47" uuid="7f2a74a7-c77f-4c26-8f2b-4776a1d9c2be"/> </rectangle> <staticText> <reportElement x="0" y="160" width="278" height="20" uuid="ef1155d3-2f99-4562-9217-fd79555c8219"/> <textElement verticalAlignment="Middle"/> <text><![CDATA[DATA:..............de..........................de .............]]></text> </staticText> <staticText> <reportElement x="-1" y="4" width="575" height="18" uuid="73d33846-20a2-4063-a72a-41fd864c1de2"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box leftPadding="5"> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement verticalAlignment="Middle"/> <text><![CDATA[OBSERVAÇÕES:]]></text> </staticText> <staticText> <reportElement x="-1" y="22" width="575" height="48" uuid="bcb979e8-b5ad-4eef-b263-5b9aa5853d58"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement verticalAlignment="Middle"/> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="-1" y="94" width="575" height="16" backcolor="#CCCCCC" uuid="6ac5e7ee-3f20-4574-a4f0-eecc4d67df54"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="10"/> </textElement> <text><![CDATA[CÓDIGOS]]></text> </staticText> <staticText> <reportElement x="-1" y="110" width="181" height="40" uuid="d02f4c65-4118-402d-9307-3cea29822ecc"/> <box leftPadding="0"> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[045 - Abono de Ponto Anual051 - Falta não Justificada052 - Falta Justificada]]></text> </staticText> <staticText> <reportElement x="180" y="110" width="157" height="40" uuid="c2a43206-b6e8-436d-a4ca-83159942d8e2"/> <text><![CDATA[084 - Férias do Exercício085 - Férias do Exercício Anterior116 - Licença Especial]]></text> </staticText> </band> </pageFooter></jasperReport>[/code]

It would be nice if we have thi resource available on main repo just like https://mvnrepository.com/artifact/net.sf.jasperreports/jasperreports

Like I said before, 6.2.1 it was ok without any of this batik etc libraries.

I don't use Maven so I just put the jasperreports-6.2.1jasperreports-fonts-6.2.1jasperreports-functions-6.2.1jasperreports-javaflow-6.2.1in the build path and it was ok until 6.2.1 after I replace with 6.2.2 jars I got some problems: https://gist.github.com/erickdeoliveiraleal/ddd588ecfb7d9e1c38f14af935fe1578 I already filled a issue but no developer answered. http://community.jaspersoft.com/jasperreports-library/issues/7416

Jasper or JRXML - Which are more efficient?

But there is a bug yet, the time picker doesnt allow to choose 00:00:00 it only allows 12:00:00

*****Edited. Sorry. I posted on the wrong post ********

But there is a bug yet, the time picker doesnt allow to choose 00:00:00 it only allows 12:00:00

Changed Assigned User from @User_306070 to @anonymous Now I think I know why the problem is happening, when I was simulating a report I chose Date but not time, then the Studio filled with actual time. But all field were filled with 00:00:00 then no items were found

Thanks. And now I think I know why the problem is happening, when I was simulating a report I chose Date but not time, then the Studio filled with actual time. But all field were filled with 00:00:00 then no items were found

If I replace $P{DATA} by '2014-09-01' it works nice! Also in a new test I created a parameter "DataString" and i just entered "2014-09-01" then the console shows Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] please remove this checking, this is so annoying

Changed Assigned User from - to @User_306070 If I replace $P{DATA} by '2014-09-01' it works nice! Also in a new test I created a parameter "DataString" and i just entered "2014-09-01" then the console shows Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]please remove this checking, this is so annoying

I have a report that works fine in iReport Designer but in Studio it shows me an empty page. If I delete the line where parameter $P{DATA} is used, the report works fine. SELECT INTERNO.NOME_INTERNO, INTERNO.RGI, INTERNO.tempo_consolidado_ano, interno.tempo_consolidado_mes, INTERNO.tempo_consolidado_dia, INTERNO.REGIME_ATUAL, PAVILHAO.PAVILHAO, GALERIA.GALERIA, CELA.CELA, SOLARIO.SOLARIO, COALESCE(DESTINO.destino,'NÃO INFORMADO') DESTINO, agenda_atendimento.data_agenda, agenda_atendimento.hora_agenda, c.cidade, UNIDADE_PENAL.NOME_UP, UNIDADE_PENAL.sigla, CASE agenda_atendimento.id_up WHEN '104' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 401 AND FUNCIONARIO.id_up = 104) WHEN '105' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 401 AND FUNCIONARIO.id_up = 105) WHEN '106' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 401 AND FUNCIONARIO.id_up = 106) WHEN '107' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 401 AND FUNCIONARIO.id_up = 107) WHEN '308' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 401 AND FUNCIONARIO.id_up = 308) WHEN '309' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 401 AND FUNCIONARIO.id_up = 309) WHEN '408' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 401 AND FUNCIONARIO.id_up = 408) WHEN '3010' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 401 AND FUNCIONARIO.id_up = 3010) ELSE 'CampoBranco' END AS NOME_CHEFE_NUARQ, 'CHEFE DA NUARQ' AS CHEFE_NUARQ, CASE agenda_atendimento.id_up WHEN '104' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 501 AND FUNCIONARIO.id_up = 104) WHEN '105' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 501 AND FUNCIONARIO.id_up = 105) WHEN '106' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 501 AND FUNCIONARIO.id_up = 106) WHEN '107' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 501 AND FUNCIONARIO.id_up = 107) WHEN '308' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 501 AND FUNCIONARIO.id_up = 308) WHEN '309' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 501 AND FUNCIONARIO.id_up = 309) WHEN '408' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 501 AND FUNCIONARIO.id_up = 408) WHEN '3010' THEN (SELECT nome_funcionario FROM funcionario WHERE FUNCIONARIO.id_funcao= 501 AND FUNCIONARIO.id_up = 3010) ELSE 'CampoBranco' END AS NOME_DIRETOR_DE_PENITENCIARIA, 'DIRETOR DE PENITENCIÁRIA' AS DIRETOR_DE_PENITENCIARIAFROM INTERNO INNER JOIN PAVILHAO ON (INTERNO.IDPAVILHAO = PAVILHAO.ID_PAVILHAO) INNER JOIN GALERIA ON (INTERNO.IDGALERIA = GALERIA.ID_GALERIA) INNER JOIN CELA ON (INTERNO.IDCELA = CELA.ID_CELA) INNER JOIN SOLARIO ON (INTERNO.IDSOLARIO = SOLARIO.ID_SOLARIO) INNER JOIN agenda_atendimento ON (INTERNO.id_interno=agenda_atendimento.id_interno) INNER JOIN agenda_situacao ag ON (ag.idagenda_situacao = agenda_atendimento.idagenda_situacao) LEFT JOIN destino ON (destino.id_destino=agenda_atendimento.iddestino) LEFT JOIN cidade c ON (c.id_cidade=destino.idcidade)LEFT JOIN UNIDADE_PENAL ON (UNIDADE_PENAL.ID_up=INTERNO.id_UP)WHERE INTERNO.ST = 'A' AND INTERNO.ID_UP = $P{UNIDADE}AND DATA_AGENDA= $P{DATA}AND ag.descricao NOT LIKE 'CANCELADO'ORDER BY agenda_atendimento.hora_agenda, c.cidade, destino.destino, INTERNO.NOME_INTERNO[/code] The parameter $P{DATA} is a java.util.Date type and works fine in iReport Designer. But with Jaspersoft Studio it shows a empty report. I already checked if the parameter were filled, I already changed the parameter type to Timestamp. But nothing happens.