Pessoal, Boa Tarde
Estou usando o ireport para criar um relatório o qual os dados se encontra em uma base SQL Server. Como sou novo no assunto estou com grande dificuldade em dois pontos.
1) Tenho um campo que será apresentado como Data no relatório, porém o mesmo vêm do banco em String.
Exemplo : O campo vem com o valor 20150408 , em string mas preciso apresentá-lo como 08/04/2015.
Portanto, preciso fazer essa conversão. É possivel? Como proceder?
2) Meu segundo problema também está relacionado á data. Preciso criar alguns parâmetros para filtrar por data os dados. Porém é necessário que o usuário digite no formato Data ( dddd-mm-yyyy), mas no meu banco de dados está gravado como string ( 20150408). Existe possibilidade de fazer a conversão no parâmetro? Da forma de data , para string , como esta no Banco? Seria ao contrário do problema acima, porem trata-se de um parametro.
Segue codigo do relatorio da forma que esta atualmente.
<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="report2" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="7a3f5e40-e6cc-4be3-9c22-6576a7df6f0c">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<style name="Title" forecolor="#FFFFFF" fontName="Arial" fontSize="26" isBold="true" pdfFontName="Helvetica-Bold"/>
<style name="SubTitle" forecolor="#666666" fontName="Arial" fontSize="18"/>
<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
<style name="Detail" fontName="Arial" fontSize="12"/>
<queryString language="SQL">
<![CDATA[SELECT
SE2010."E2_FORNECE",
SE2010."E2_PREFIXO",
SE2010."E2_NUM",
SE2010."E2_PARCELA",
SE2010."E2_TIPO",
SE2010."E2_NOMFOR",
SE2010."E2_EMISSAO",
SE2010."E2_VENCTO",
SE2010."E2_VENCREA",
SE2010."E2_VALOR",
SE2010."E2_HIST"
FROM
"SE2010" SE2010
WHERE
E2_FILIAL = '0101'
ORDER BY E2_NOMFOR ASC]]>
</queryString>
<field name="E2_FORNECE" class="java.lang.String"/>
<field name="E2_NOMFOR" class="java.lang.String"/>
<field name="E2_NUM" class="java.lang.String"/>
<field name="E2_PREFIXO" class="java.lang.String"/>
<field name="E2_PARCELA" class="java.lang.String"/>
<field name="E2_TIPO" class="java.lang.String"/>
<field name="E2_EMISSAO" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="E2_VENCTO" class="java.lang.String"/>
<field name="E2_VENCREA" class="java.lang.String"/>
<field name="E2_VALOR" class="java.lang.Double"/>
<field name="E2_HIST" class="java.lang.String"/>
<variable name="SUMFor" class="java.lang.Double" resetType="Group" resetGroup="E2_NOMFOR" calculation="Sum">
<variableExpression><![CDATA[$F{E2_VALOR}]]></variableExpression>
</variable>
<variable name="SUMGeral" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{E2_VALOR}]]></variableExpression>
</variable>
<group name="E2_NOMFOR">
<groupExpression><![CDATA[$F{E2_NOMFOR}]]></groupExpression>
<groupHeader>
<band height="45">
<textField>
<reportElement uuid="98036c22-bd89-48d7-b906-60e40a32138a" style="SubTitle" x="0" y="4" width="118" height="17" forecolor="#000000"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{E2_NOMFOR}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="f15296e7-c8e6-426a-b6cb-09251267f290" style="Column header" x="0" y="30" width="75" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Num. Título]]></text>
</staticText>
<staticText>
<reportElement uuid="45fe259f-ecf4-44c5-8f92-5efb602427a5" style="Column header" x="81" y="30" width="55" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Parcela]]></text>
</staticText>
<staticText>
<reportElement uuid="d45a5b9b-5c92-49de-a5c4-049e4259d9c5" style="Column header" x="223" y="30" width="67" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Dt.Emissao]]></text>
</staticText>
<staticText>
<reportElement uuid="7cd4b820-9aa6-4555-a65c-f55b8cb60ed5" style="Column header" x="151" y="30" width="55" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Tipo]]></text>
</staticText>
<staticText>
<reportElement uuid="4522b0d3-88ad-44ee-bd02-f41d57c2e4f1" style="Column header" x="328" y="30" width="55" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Vencto]]></text>
</staticText>
<staticText>
<reportElement uuid="88df26d0-660a-40a8-a795-fd981302c46d" style="Column header" x="426" y="30" width="69" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Venc.Real]]></text>
</staticText>
<staticText>
<reportElement uuid="99d04043-e4c2-43c8-82fb-ca271d09b4eb" style="Column header" x="544" y="30" width="34" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Valor]]></text>
</staticText>
<staticText>
<reportElement uuid="8596f6b9-ca88-4134-b6e0-660544cb266b" style="Column header" x="677" y="30" width="55" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Histórico]]></text>
</staticText>
</band>
</groupHeader>
<groupFooter>
<band height="25">
<line>
<reportElement uuid="7a7f8936-eebf-47ae-a622-77c6d0e4a79e" positionType="FixRelativeToBottom" isPrintRepeatedValues="false" x="0" y="19" width="802" height="1" printWhenGroupChanges="E2_NOMFOR"/>
<graphicElement>
<pen lineWidth="0.5" lineColor="#000000"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="0f93dcd4-f3af-4474-b607-075830a3d9e9" style="Column header" x="495" y="2" width="55" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Total:]]></text>
</staticText>
<textField pattern="¤ #,##0.00">
<reportElement uuid="f3de6e05-09bd-4445-a62c-fd24e256fceb" x="545" y="0" width="132" height="20"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression><![CDATA[$V{SUMFor}]]></textFieldExpression>
</textField>
</band>
</groupFooter>
</group>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="27" splitType="Stretch">
<staticText>
<reportElement uuid="3956b103-d01e-4655-9ed5-68dcf15a7b7a" style="Title" x="165" y="5" width="220" height="22" forecolor="#000000"/>
<textElement verticalAlignment="Middle">
<font size="15"/>
</textElement>
<text><![CDATA[Relação de Titulos a Pagar]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="7" splitType="Stretch"/>
</columnHeader>
<detail>
<band height="28" splitType="Stretch">
<textField>
<reportElement uuid="a0625521-bc5a-46c2-bdcf-a221edeed884" style="Detail" x="3" y="0" width="55" height="15"/>
<textElement/>
<textFieldExpression><![CDATA[$F{E2_NUM}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1c1a5b26-0a02-4cb3-9a5b-176b6b42ad7f" style="Detail" x="91" y="0" width="60" height="15"/>
<textElement/>
<textFieldExpression><![CDATA[$F{E2_PARCELA}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b5133da7-b073-46bb-84f1-9b9dfdbd1339" style="Detail" x="157" y="0" width="72" height="15"/>
<textElement/>
<textFieldExpression><![CDATA[$F{E2_TIPO}]]></textFieldExpression>
</textField>
<textField pattern="yyyy/MM/dd">
<reportElement uuid="6aa8c13a-4603-4d8a-b8f2-5128acf85450" style="Detail" x="229" y="0" width="99" height="15"/>
<textElement/>
<textFieldExpression class="java.util.Date"><![CDATA[$F{E2_EMISSAO}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy">
<reportElement uuid="15d3b0a2-8624-45a1-8439-f486af2adc2f" style="Detail" x="330" y="0" width="96" height="15"/>
<textElement/>
<textFieldExpression><![CDATA[$F{E2_VENCTO}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy">
<reportElement uuid="c17a41a5-2abd-4227-887a-c45e5b9c1531" style="Detail" x="434" y="0" width="110" height="15"/>
<textElement/>
<textFieldExpression><![CDATA[$F{E2_VENCREA}]]></textFieldExpression>
</textField>
<textField pattern="¤ #,##0.00">
<reportElement uuid="d5391d1d-9fc4-4f03-8be3-181f32b64b60" style="Detail" x="545" y="0" width="101" height="15"/>
<textElement/>
<textFieldExpression><![CDATA[$F{E2_VALOR}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="541671c3-479e-4f97-9edf-dec095d409b1" style="Detail" x="670" y="0" width="55" height="15"/>
<textElement/>
<textFieldExpression><![CDATA[$F{E2_HIST}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="28" splitType="Stretch">
<textField pattern="¤ #,##0.00">
<reportElement uuid="4ae879b0-4547-4b48-abed-2ce816289890" x="570" y="0" width="100" height="20"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression><![CDATA[$V{SUMGeral}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="bf4606f9-d287-43c1-bae6-95b52b2a3a5c" style="Column header" x="495" y="0" width="84" height="15" forecolor="#000000"/>
<textElement/>
<text><![CDATA[Total Geral:]]></text>
</staticText>
</band>
</columnFooter>
<pageFooter>
<band height="20" splitType="Stretch">
<textField>
<reportElement uuid="6746c28d-63d5-4187-a0de-86eb65c0c1e0" style="Column header" x="672" y="0" width="80" height="20" forecolor="#000000"/>
<textElement textAlignment="Right">
<font size="10" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement uuid="ed13f77b-b4de-4050-9aae-c9cb7aebaa78" style="Column header" x="752" y="0" width="40" height="20" forecolor="#000000"/>
<textElement>
<font size="10" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField pattern="EEEEE dd MMMMM yyyy">
<reportElement uuid="3d9515f1-41c1-4f29-9564-4651ca29fcb1" style="Column header" x="0" y="0" width="197" height="20" forecolor="#000000"/>
<textElement>
<font size="10" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band splitType="Stretch"/>
</summary>
</jasperReport>
Conto com a compreensão de todos.
At. Douglas Eduardo