Skip to Content
0
Former Member
May 09, 2008 at 02:35 PM

Question on using a Parameter against an Oracle date field

41 Views

Post Author: klkemp100

CA Forum: Data Connectivity and SQL

newbie here just getting started in Crystal Reports v11.0

writing a report to go against an oracle view. i need the report to use a parameter that the user enters to select a specific date.

i went through the database expert and keyed in my own sql since i first tested this via TOAD and know that the sql works fine with a hard-coded date etc.

next i created a parameter and set it first up as a DATE but got the message that FAILED TO RETRIEVE DATA FROM THE DATABASE, even though I know that there is data to retrieve and i have previously retrieved it when the selection date is hard-coded in the query.

i then changed the field type in the view to be a VARCHAR2 and changed the parameter to be a STRING, but am still getting the same thing.

is there something special about using dates and parameters within crystal against oracle?

thanks in advance for your help.