Re: Pass variable to Oracle Query form Crystal Reports

You are correct. But I'm most concerned with finding a way to pass a user entered variable to the query. Any ideas?

Thanks,

Wayne

Frank <fbortel_at_nescape.net> wrote in message news:<br82j8$hgf$1_at_news2.tilbu1.nb.home.nl>...
> Wayne Baswell wrote:
>
> > I want to pass a date variable to a sql statement from Crystal
> > Reports. The part of the query accepting the variables looks like:
> >
> > "Calendar_Date between To_Date('1-JUN-03','mm/dd/yy') and
> > To_Date('30-JUN-03','mm/dd/yy')"
> >
> > And I'd be wanting to replace the date part of the query with a
> > user-entered date. As I'm new to Oracle and Crystal, I don't know
> > where to start. Is there a way to replace the '1-JUN-03' part with a
> > variable in Oracle, then modify that variable when I'm designing the
> > report?
> >
> > Grabbing all the results and then filtering them in Crystal won't work
> > as this table is very large. Apologies in advance if this question
> > has been asked a million times.
> >
> > --Wayne
>
> Your statement will not work - the date format differs too much from
> the date offered - result will be an ORA-1860 (iirc)
> '1-JUN-03','dd-mon-yy', or: '7/1/03','mm/dd/yy'
Received on Thu Dec 11 2003 - 15:10:46 CET