Hi,

Hi,

My report contains an input parameter bound to MSSQL datetime value.

It works fine with Report Designer if I defined
Object Type = Object or
Object Type = Date

BUT in both cases, I got an error when I try to display it with BI Server.


Date:
at java.lang.Thread.run(Thread.java:595)
11:19:16,876 ERROR [SimpleReportingComponent] [execute] Component execution fail
ed.
java.lang.NumberFormatException: For input string: "2010-01-27 00:00:00.0"
at java.lang.NumberFormatException.forInputString(NumberFormatException.
java:48)
at java.lang.Long.parseLong(Long.java:412)
at java.lang.Long.<init>(Long.java:671)

Object:

10:53:26,970 ERROR [AbstractReportProcessor] 5553796: Report processing failed.
10:53:26,970 ERROR [SimpleReportingComponent] [execute] Component execution fail
ed.
org.pentaho.reporting.engine.classic.core.ReportParameterValidationException: Th
e parameters provided for this report are not valid.
at org.pentaho.reporting.engine.classic.core.states.process.ProcessState
.<init>(ProcessState.java:211)