Eclipse Community Forums: BIRT » Problem with Binding Report Parameters to DateSet Parameters

Home » Archived » BIRT » Problem with Binding Report Parameters to DateSet Parameters

Problem with Binding Report Parameters to DateSet Parameters [message #88575]

Mon, 07 November 2005 17:39

Eclipse User

Originally posted by: pcasey.earthlink.net

I have a dataset parameter named startDateDS:
Type = Date Time
Direction = Input
Default Value = '11/01/05'

When I preview the query with this parameter, it works fine.

I have a report parameter named startDate:
Type = Date Time
Format = Unfomratted
Default Value = 11/01/2005

I have bound my report parameter to my dataset parameter:
Parameter=startDateDS
Data Type=Date Time
Value=params["startDate"]

When I try to preview the report though I get errors, specifically:

There are errors on the report page:
- There are error(s) in Table:null
Error0 : data.engine.ConvertDataTypeError(1 time)detail: Cannot convert the
parameter value [Wed Dec 31 16:00:00 PST 1969] to type [class
java.util.Date]DateDate Please help, I'm pulling my hair out over
s. --- Pat

Re: Problem with Binding Report Parameters to DateSet Parameters [message #88861 is a reply to message #88575]

Tue, 08 November 2005 14:22

Eclipse User

I tested this scenario, and I was able to preview my report. How did you
bind the data set parameter to the report parameter? Did you bind it through
the table that displays the data?

"Patrick Casey" <pcasey@earthlink.net> wrote in message
news:dkol3u$d79$1@news.eclipse.org...
>
> I have a dataset parameter named startDateDS:
> Type = Date Time
> Direction = Input
> Default Value = '11/01/05'
>
> When I preview the query with this parameter, it works fine.
>
> I have a report parameter named startDate:
> Type = Date Time
> Format = Unfomratted
> Default Value = 11/01/2005
>
> I have bound my report parameter to my dataset parameter:
> Parameter=startDateDS
> Data Type=Date Time
> Value=params["startDate"]
>
> When I try to preview the report though I get errors, specifically:
>
> There are errors on the report page:
> - There are error(s) in Table:null
> Error0 : data.engine.ConvertDataTypeError(1 time)detail: Cannot convert
the
> parameter value [Wed Dec 31 16:00:00 PST 1969] to type [class
> java.util.Date]DateDate Please help, I'm pulling my hair out over
> s. --- Pat
>
>

Re: Problem with Binding Report Parameters to DateSet Parameters [message #88876 is a reply to message #88861]

Tue, 08 November 2005 14:31

Eclipse User

Originally posted by: pcasey.earthlink.net

Yep, I did it via the table.

I also found that if I define the Report Parameter as a String (not a
date/time) that it works, but if both the dataset and report parameters are
date/times, I get the error listed below.

--- Pat

"Diana Peh" <diana.peh@actuate.com> wrote in message
news:dkqts4$eas$1@news.eclipse.org...
> I tested this scenario, and I was able to preview my report. How did you
> bind the data set parameter to the report parameter? Did you bind it
> through
> the table that displays the data?
>
>
> "Patrick Casey" <pcasey@earthlink.net> wrote in message
> news:dkol3u$d79$1@news.eclipse.org...
>>
>> I have a dataset parameter named startDateDS:
>> Type = Date Time
>> Direction = Input
>> Default Value = '11/01/05'
>>
>> When I preview the query with this parameter, it works fine.
>>
>> I have a report parameter named startDate:
>> Type = Date Time
>> Format = Unfomratted
>> Default Value = 11/01/2005
>>
>> I have bound my report parameter to my dataset parameter:
>> Parameter=startDateDS
>> Data Type=Date Time
>> Value=params["startDate"]
>>
>> When I try to preview the report though I get errors, specifically:
>>
>> There are errors on the report page:
>> - There are error(s) in Table:null
>> Error0 : data.engine.ConvertDataTypeError(1 time)detail: Cannot convert
> the
>> parameter value [Wed Dec 31 16:00:00 PST 1969] to type [class
>> java.util.Date]DateDate Please help, I'm pulling my hair out over
>> s. --- Pat
>>
>>
>
>

Re: Problem with Binding Report Parameters to DateSet Parameters [message #88891 is a reply to message #88876]

Tue, 08 November 2005 14:56

Eclipse User

The data type might have been a problem with an earlier version of BIRT. In
the 2.0 Milestone 2 version, both the data set and report parameter can be
datetime type.

"Patrick Casey" <pcasey@earthlink.net> wrote in message
news:dkque8$f47$1@news.eclipse.org...
>
> Yep, I did it via the table.
>
> I also found that if I define the Report Parameter as a String (not a
> date/time) that it works, but if both the dataset and report parameters
are
> date/times, I get the error listed below.
>
> --- Pat
>
> "Diana Peh" <diana.peh@actuate.com> wrote in message
> news:dkqts4$eas$1@news.eclipse.org...
> > I tested this scenario, and I was able to preview my report. How did you
> > bind the data set parameter to the report parameter? Did you bind it
> > through
> > the table that displays the data?
> >
> >
> > "Patrick Casey" <pcasey@earthlink.net> wrote in message
> > news:dkol3u$d79$1@news.eclipse.org...
> >>
> >> I have a dataset parameter named startDateDS:
> >> Type = Date Time
> >> Direction = Input
> >> Default Value = '11/01/05'
> >>
> >> When I preview the query with this parameter, it works fine.
> >>
> >> I have a report parameter named startDate:
> >> Type = Date Time
> >> Format = Unfomratted
> >> Default Value = 11/01/2005
> >>
> >> I have bound my report parameter to my dataset parameter:
> >> Parameter=startDateDS
> >> Data Type=Date Time
> >> Value=params["startDate"]
> >>
> >> When I try to preview the report though I get errors, specifically:
> >>
> >> There are errors on the report page:
> >> - There are error(s) in Table:null
> >> Error0 : data.engine.ConvertDataTypeError(1 time)detail: Cannot convert
> > the
> >> parameter value [Wed Dec 31 16:00:00 PST 1969] to type [class
> >> java.util.Date]DateDate Please help, I'm pulling my hair out over
> >> s. --- Pat
> >>
> >>
> >
> >
>
>

Re: Problem with Binding Report Parameters to DateSet Parameters [message #88906 is a reply to message #88891]

Tue, 08 November 2005 15:05

Eclipse User

Originally posted by: pcasey.earthlink.net

I'm still on 1.0.1 on the theory that it's the more stable release. As I
work more with Birt though I'm starting ot think I might be better off with
the 2.0 milestones. Can anyone comment on that e.g. is 2.0 M2 more
stable/less buggy than 1.0.1?

--- Pat

"Diana Peh" <diana.peh@actuate.com> wrote in message
news:dkqvs4$h5b$1@news.eclipse.org...
> The data type might have been a problem with an earlier version of BIRT.
> In
> the 2.0 Milestone 2 version, both the data set and report parameter can be
> datetime type.
>
> "Patrick Casey" <pcasey@earthlink.net> wrote in message
> news:dkque8$f47$1@news.eclipse.org...
>>
>> Yep, I did it via the table.
>>
>> I also found that if I define the Report Parameter as a String (not a
>> date/time) that it works, but if both the dataset and report parameters
> are
>> date/times, I get the error listed below.
>>
>> --- Pat
<snip>

Previous Topic:	Problems understanding monthly groupings
Next Topic:	Text/cell alignment

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 15 03:12:02 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter