on 04-28-2011 6:30 PM
Hello expert,
I created crystal report by oracle procedure directly , but a date parameter for this procedure is mapped to datatime type parameter in crystal report, its format is dd/mm/yyyy hh:mm:ss. instead of this datatime format, I need date format as "dd/mm/yyyy", but I found I can't change data type for this procedure parameter in crystal report. I know I can't choose data type for procedure parameter if I use procedure in command. but over here, I have to use this procedure directly instead of using command as data connection for this report. Can I change this procedure parameter for datetime type to date type in the crystal report. Apprecaite very much.
You can get crystal to treat the datetime field as a date field by addressing it as
date({datetime})
when ever you refer to it. You may even be able to address your parameter as
date({?datetimeparameter})
Debi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.