| Problem with Binding Report Parameters to DateSet Parameters [message #88575] |
Mon, 07 November 2005 22: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 #88876 is a reply to message #88861] |
Tue, 08 November 2005 19: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 #88906 is a reply to message #88891] |
Tue, 08 November 2005 20: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>
|
|
|
Powered by
FUDForum. Page generated in 0.02739 seconds
] 
Search
Help
Register
Login
Home
