Eclipse Community Forums: BIRT » dateTime parameters don't work ??

Home » Archived » BIRT » dateTime parameters don't work ??

dateTime parameters don't work ?? [message #52598]

Wed, 29 June 2005 10:52

Eclipse User

I've made a report design that take 2 dateTime parameters to generate data
in a certain time range (given at runtime). Hence, my main dataset has
also 2 dateTime parameters that would be injected in the request SELECT
.... WHERE dateCreation BETWEEN ? and ?
That doesn't work and generate a class cast exception.
I've seen in this newsgroup people having the same issue, so i tried to
set parameters type to the default (for both dataset and report
parameters) and set parameters at run time with plain string :

params.put("dateBegin", "2005-06-17 10:43:05");
params.put("dateEnd", "2005-06-27 10:43:05");

The report is generated with no errors but the data is not reduced to the
give time range...

How can i use dateTime parameters?? I desesperate need a workaround or
something,

Thanks for your help

Re: dateTime parameters don't work ?? [message #52735 is a reply to message #52598]

Wed, 29 June 2005 17:15

Eclipse User

You should file a bugzilla report for this issue. Please attach the report
design and any custom code.
I am aware of a number of bugs related to date/time format issue currently
worked on by the BIRT team. You can also try a search in bugzilla for any
similar issues. Some may have already been resolved in latest 1.0.1
development builds.

Gary

"Alex" <a.tual@fylab.fr> wrote in message
news:85275a40d12cd799e9d04314368fabb0$1@www.eclipse.org...
> I've made a report design that take 2 dateTime parameters to generate data
> in a certain time range (given at runtime). Hence, my main dataset has
> also 2 dateTime parameters that would be injected in the request SELECT
> ... WHERE dateCreation BETWEEN ? and ?
> That doesn't work and generate a class cast exception.
> I've seen in this newsgroup people having the same issue, so i tried to
> set parameters type to the default (for both dataset and report
> parameters) and set parameters at run time with plain string :
>
> params.put("dateBegin", "2005-06-17 10:43:05");
> params.put("dateEnd", "2005-06-27 10:43:05");
>
> The report is generated with no errors but the data is not reduced to the
> give time range...
>
> How can i use dateTime parameters?? I desesperate need a workaround or
> something,
>
> Thanks for your help
>

Re: dateTime parameters don't work ?? [message #54091 is a reply to message #52598]

Wed, 06 July 2005 03:38

Eclipse User

Originally posted by: none.none.none

Alex, were you able to resolve this issue? I am currently having the same
problem with report parameters (dataset parameters seem to be okay).

Thanks

"Alex" <a.tual@fylab.fr> wrote in message
news:85275a40d12cd799e9d04314368fabb0$1@www.eclipse.org...
> I've made a report design that take 2 dateTime parameters to generate data
> in a certain time range (given at runtime). Hence, my main dataset has
> also 2 dateTime parameters that would be injected in the request SELECT
> ... WHERE dateCreation BETWEEN ? and ?
> That doesn't work and generate a class cast exception.
> I've seen in this newsgroup people having the same issue, so i tried to
> set parameters type to the default (for both dataset and report
> parameters) and set parameters at run time with plain string :
>
> params.put("dateBegin", "2005-06-17 10:43:05");
> params.put("dateEnd", "2005-06-27 10:43:05");
> The report is generated with no errors but the data is not
> reduced to the give time range...
>
> How can i use dateTime parameters?? I desesperate need a workaround or
> something,
>
> Thanks for your help
>

Previous Topic:	Easier way to set report data?
Next Topic:	PDF summary - guard page

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jun 05 23:03:02 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter