Eclipse Community Forums: BIRT » Dates in BIRT Reports

Home » Archived » BIRT » Dates in BIRT Reports

Tue, 29 August 2006 17:59

Eclipse User

Hi
I am having lots of trouble with date parameters. Can anyone suggest any
documentation or samples that use date parameters.
We are finding that they work on our windows developer machines but not our
linux / tomcat box or visa versa or sometimes neither.
Alternativly has anyone integrated a javascript date picker into the jsp and
documented how to do it?

It seems as though the date-time type is not sending the date in the correct
format to our query/datasource.

TIA,
Nigel

Re: Dates in BIRT Reports [message #188068 is a reply to message #188038]

Wed, 30 August 2006 05:31

Eclipse User

Originally posted by: jhurley12.gmail.com

I think if you convert the datetime data to a custom formatted string before
you pass it as a parameter (with a computed column and javascript) then you
can force the correct format that is required by the report/query you are
passing it to.

Joe

"Nigel James" <nigel.james@gmail.com> wrote in message
news:ed2dct$q8j$1@utils.eclipse.org...
> Hi
> I am having lots of trouble with date parameters. Can anyone suggest any
> documentation or samples that use date parameters.
> We are finding that they work on our windows developer machines but not
> our linux / tomcat box or visa versa or sometimes neither.
> Alternativly has anyone integrated a javascript date picker into the jsp
> and documented how to do it?
>
> It seems as though the date-time type is not sending the date in the
> correct format to our query/datasource.
>
> TIA,
> Nigel
>

Re: Dates in BIRT Reports [message #188455 is a reply to message #188068]

Wed, 30 August 2006 18:20

Eclipse User

Thanks Joe,
I solved it for now by making sure the report parameter and the dataset
parameter were both date-time and I cused the custom format of MM/dd/yyyy
and this seemed to get passed corectly to the db.
When I have a few more eclipse runs on the board I might revisti this.
Thanks,
Nigel

"Joe" <jhurley12@gmail.com> wrote in message
news:ed3lt3$fa7$1@utils.eclipse.org...
>I think if you convert the datetime data to a custom formatted string
>before you pass it as a parameter (with a computed column and javascript)
>then you can force the correct format that is required by the report/query
>you are passing it to.
>
> Joe

Previous Topic:	binding a username/password property to a report
Next Topic:	Stored procedures

Goto Forum:

-=] Back to Top [=-

Current Time: Thu May 08 11:32:03 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter