on 12-29-2008 3:15 PM
Hello.
We have this problem in our company:
We are running a firebird database and i am using a date field as a parameter in the report.
But i only can use a string-parameter instead of a date field though it is a date data type in the database.
The reason seems to be that crystal report is sending the parameter formated like this:
Date(10.10.2008)
if i add it in the query like this
{?date}
i get a convert error (seems like our db cant use convert), if i add it like this
'{?date}'
i get an error message, unknown token
So what can i do now? I want to use a date parameter to use the calender function, that would be much better for our customers. So far i have to type the date manuelly and the report is functional but a real date function is missing now.
Hope someone can help me im looking forward to your replies.
P.S. dont know if its important, i am using Crystal Reports 2008 Version 12.0.0.683
This is a known issue and will be fixed with SP3
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok i try to describe our problem a bit more detailed.
SELECT VD.DATUM, .....
FROM VORGANGSDOKUMENT VD
WHERE VD.DATUM >= '{?DATUM_FROM}' AND VD.DATUM <= '{?DATUM_TO}'
this a part of the query. The datafield is DATE type, also i want to use the parameter as DATE type.
The Parameter has to be in form like '10.10.2008' .
So far i have to use a STRING type parameter because DATE type is not working.
Edited by: Markus Klimaschewski on Dec 29, 2008 4:34 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I cant use convert, because our databse dont support it.
The parameters i am using are just from the crystal report query. The problem is that the parameter-format crystal reports is using for a date parameter isnt working on our database, if i would know what crystal reports is exactly using as query i could use substring to get the parts of the parameter our database is understanding.
You may want to make your parameter a DATE parameter then create a record selection such as this:
CDATE() = {?DateParameter}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.