Pass date variables from Crystal to Oracle SQL view.

[Maven4Champ]

Not sure if this is possible or not.

I have a view which I would like to have in the WHERE Clause a StartDate and EndDate variable that would prompt when you execute the query. I would like to get that far first to see if this works.

If it does, my next step would be to utilize Crystal Reports 8.5 to prompt the user in our VB application for a Start Date and End Date which is subsequently passed into the where clause of the view and restrics the data coming back into the report.

So my first question - is it possible to pass date variables to an Oracle SQL view and if so, what is the proper syntax?

Second question, If I build a Crystal report based off this view, will it automatically prompt in the report for a date range or is there further work involved?

Let me know.
Thanks,
Mike

P.S. I also posted this in the Oracle forum for those who may think this goes elsewhere. Wasn't really sure where to post this one though.

 

[Turkbear]

Hi,
I responced to you rpost in the Oracle forum, but:
Views cannot be build with variables, use a Stored Procedure instead and base your Crystal report on that..
( The IN variable in the SP will be a prompt in Crystal)..




To Paraphrase:"The Help you get is proportional to the Help you give.."