ccmorten

Hi, 1. I have added an Input control called startdate in JasperServer with a single select query to give the user a selection of dates to choose from. The query looks like this (query inside the input control): select distinct recordtimestamp from calltypedaily order by recordtimestamp asc recordtimestamp is an sql datetime from an SQL Server In iReport I have a java.util.Date parameter called startdate, which I use to compare two dates in my iReport query: select .... from ..... where recordtimestamp between $P{startdate} and $P{enddate} When I used an input control of type date, there was no problem, but when I use a single-select query to populate my combobox the date is converted to a string. How do I convert it back to a date format, so I can do the date comparison? 2. What kind of parameter type does a multi-select query Input Control return? Should I make it a Collection parameter or a List parameter, and how do I convert it back to the type I need in my iReport query? Thanks for your reply. Best regards, CC:Morten

Hi, I am quite new to the Jasper platform. I need help casting a return value from an sql query, which is an Integer (milliseconds), into a time format (HH:MM:SS). Is there a way to do a cast inside iReport, or do I need to do it in my sql query? Regards, CC:Morten