Wonderwall
asked on
Stored procedure parameters with Crystal reports
Aloha, I have a bunch of SP is SQL server that I want to use in crystal reports. What is the command in CR to do this? I can run sp's with no parameters but not sure how to call
exec sp_test ........ when requiring a parameter to be entered. I would like the parameters to pop up like a date range. Mahalo Brew
exec sp_test ........ when requiring a parameter to be entered. I would like the parameters to pop up like a date range. Mahalo Brew
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc is right. After that you need to integrate that report to application then create parameter fields in report and assign it to sps' parameter.
http://www.codeproject.com/KB/cs/loadingcrystalreport.aspx
http://www.eggheadcafe.com/tutorials/aspnet/4520dcca-f4bb-4cd3-a80c-569d6ea46488/crystal-report-and-parame.aspx