| report parameter of type date/time causes problem [message #61164] |
Fri, 22 July 2005 12:11  |
Eclipse User |
|
|
|
Originally posted by: tomvo.hahaha.be
Hi,
I've created a report that asks for a start and end date.
The problem i have is this error:
There are errors on the report page:
Error1:Failed to evaluate 07/01/2005 00:00:00 AM
missing ; before statement (#1)
Error2:Failed to evaluate 07/30/2005 00:00:00 AM
missing ; before statement (#1)
Error3:Cannot execute the statement.
SQL statement does not return a ResultSet object
[Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.
SQL statement does not return a ResultSet object
[Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.
[Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.
This is my sql statement:
select "Description","Date/Time Closed","Date/Time Opened","Case Comment
Created By","Status","Type","Priority","Case Number","Subject","Case
Comments","Case Comment Created Date","Age (Hours)"
from VeraCases t1
where t1."Case Comment Created Date" =
(
select MAX("Case Comment Created Date") from VeraCases t2 where t1."Case
Number" = t2."Case Number"
)
and t1."Type" = 'Incident' and "Date/Time Closed" > ? and "Date/Time Closed"
< ?
order by "case number"
my data set parameters are:
vroegstedatum any input "07/01/2005 00:00:00 AM" No No
laatstedatum any input "07/30/2005 00:00:00 AM" No No
my report parameters are:
name: vroegste_sluitdatum
display name: Vroegste sluitdatum
Type: DateTime
Format: ShortDate
Display type: Text Box
default value: 07/01/2005 00:00:00 AM
(all checkboxes are unchecked)
and
name: laatste_sluitdatum
display name: Laatste sluitdatum
Type: DateTime
Format: ShortDate
Display type: Text Box
default value: 07/30/2005 00:00:00 AM
(all checkboxes are unchecked)
Binding:
vroegstedatum any params["vroegste_sluitdatum"]
laatstedatum any params["laatste_sluitdatum"]
I guess i'm mixing data types somewhere, but i don't know where to start
looking. it looks fine to me.
Tom.
|
|
|
| Re: report parameter of type date/time causes problem [message #61331 is a reply to message #61164] |
Sat, 23 July 2005 07:24  |
| Eclipse User |
|
|
|
Originally posted by: tomvo.hahaha.be
Looks like the problem is in my sql select, even though it seems to work
with the samples database.
my data source is actually an excel file. Perhaps this is the problem ?
I've solved it by using the 'filter' option (letting birt do the work of
filtering, instead of via sql).
I'd still like to know if this is a bug or not though ? (especially as i
can't use a report parameter now i think ?)
regards,
tom.
"Tom Van Overbeke" <tomvo@hahaha.be> wrote in message
news:dbr5r6$hq$1@news.eclipse.org...
> Hi,
> I've created a report that asks for a start and end date.
> The problem i have is this error:
>
> There are errors on the report page:
> Error1:Failed to evaluate 07/01/2005 00:00:00 AM
> missing ; before statement (#1)
> Error2:Failed to evaluate 07/30/2005 00:00:00 AM
> missing ; before statement (#1)
> Error3:Cannot execute the statement.
> SQL statement does not return a ResultSet object
> [Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.
> SQL statement does not return a ResultSet object
> [Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.
> [Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.
>
> This is my sql statement:
>
> select "Description","Date/Time Closed","Date/Time Opened","Case Comment
> Created By","Status","Type","Priority","Case Number","Subject","Case
> Comments","Case Comment Created Date","Age (Hours)"
> from VeraCases t1
> where t1."Case Comment Created Date" =
> (
> select MAX("Case Comment Created Date") from VeraCases t2 where t1."Case
> Number" = t2."Case Number"
> )
> and t1."Type" = 'Incident' and "Date/Time Closed" > ? and "Date/Time
> Closed" < ?
> order by "case number"
>
> my data set parameters are:
> vroegstedatum any input "07/01/2005 00:00:00 AM" No No
> laatstedatum any input "07/30/2005 00:00:00 AM" No No
> my report parameters are:
> name: vroegste_sluitdatum
> display name: Vroegste sluitdatum
> Type: DateTime
> Format: ShortDate
> Display type: Text Box
> default value: 07/01/2005 00:00:00 AM
> (all checkboxes are unchecked)
> and
> name: laatste_sluitdatum
> display name: Laatste sluitdatum
> Type: DateTime
> Format: ShortDate
> Display type: Text Box
> default value: 07/30/2005 00:00:00 AM
> (all checkboxes are unchecked)
> Binding:
> vroegstedatum any params["vroegste_sluitdatum"]
> laatstedatum any params["laatste_sluitdatum"]
> I guess i'm mixing data types somewhere, but i don't know where to start
> looking. it looks fine to me.
> Tom.
>
|
|
|
Powered by
FUDForum. Page generated in 0.03444 seconds
Home