Running Stored SQL Procedure from Crystal Reports with data parameter

I have a stored procedure that requires the user to input a data parameter:

DischargeDateTime Between @FromDate and @ThruDate

The user is prompted to input the two dates when it is run in SQL.

How can I modify this Stored Procedure so when it is used in Crystal Reports the user is prompted in Crystal for the date inputs?


Who is Participating?
Lee SavidgeConnect With a Mentor Commented:
Add two parameters in Crystal and then map them to the respective parameters in your SP call in Crystal
GPSPOWAuthor Commented:
I'll try it and let you know
GPSPOWAuthor Commented:
Worked like a charm

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.