Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing date parameters

Status
Not open for further replies.

ByzantianX

Programmer
Dec 18, 2000
103
I tried to bound a new report to the stored procedure on sql server. Stored procedure requires 2 smalldate parameters and there is no way I can pass the value in "Enter parameter value" dialogue. Everytime I am getting the message "Error detected by database DLL". I am using European date format DD.MM.YYYY
I really don't know what to do. I had to change stored procedure and to pass string values (I converted those two date parameters with convert(smalldatetime,@dateparameter) function but that can be only an ad hoc solution. I'm using Crystal Reports 7. Please, help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top