Search code examples
jasper-reportsireport

Any examples how to use timestamp parameter in Jasper IReport

Can anyone help me how to use timestamp parameter in Jasper IReport?
I'm using this format new java.sql.Timestamp(2013,2,26,3,15,0,0) but it throws error in the query window but when I pass the parameter via prompt it shows the time in the following format

26-02-13 3:26 AM

JRXML for reference:

`

Solution

  • try this

    Inside java class 

       Map parameters = new HashMap();
   parameters.put("From_Date",Timestamp.valueOf("2005-06-01 00:00:00.000000"));
   JasperPrint jp=JasperFillManager.fillReport(jr, parameters,cn);

    In jrxml

    <parameter name="From_Date" class="java.sql.Timestamp"/>

    in detail section of jrxml

        <detail>
        <band height="125" splitType="Stretch">
            <textField>
                <reportElement uuid="974661e4-5ac1-4ab2-b933-27f132f4498b" x="70" y="35" width="100" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[$P{From_Date}]]></textFieldExpression>
            </textField>
        </band>
    </detail>