Single Select Query (Date) Datatype

[bckeen]

Is there a way to typr case the return from a single select query to allow the selection of only available dates in the database.  And have the date go into the report as a java.util.Date instead of a String

[andrewsok]

 You can use String for visible parameter, and show your available dates from the DB, and then have a second hidden parameter which you use for the report query:

<parameter name="P_DateString" isForPrompting="true" class="java.lang.String" />

<parameter name="P_Date" isForPrompting="false" class="java.util.Date">

  <defaultValueExpression><![CDATA[new java.text.SimpleDateFormat("--your--pattern--").parse($P{P_DateString})]]></defaultValueExpression>

</parameter>

P_DateString is what InputControl sets up, and P_Date is what you user in your SQL query.

[bckeen]

This does not seem to work with iReport and Jasper Server 3.5.  My code is attached.  There are no errors just no data is retrieved

Code:

Post Edited by Brian Keener at 04/14/09 12:46

[bckeen]

Nevermind, I have gotten it working

[zakaria2105]

hi bckeen,

 

i want to use your code to change the format of the calender but i dont know how can i use it , where can i put this code ? excuse me im a new user of jasper i try to understand some carasteristic of this opensource^^