Using SQL Server 2005 with Crystal Report XI. I have a report that is using a stored prod. The stored prod needs to parm passed to it. Not sure how to pass the parm from crystal to the stored prod. Thank you for your help. David
I am still working with CR9 until my machine is updated, but most of the menu options should be similiar .. in the designer :
(assuming connect to MSSQL)
Database->Set DataSource Location->
Create New Connection -> OLEDB(ADO) ->
(Follow property page to set SQL connection info)
When you select a stored procedure, you should be prompted for parameters. This is partially because a procedure can potentially return different column information from different parameters. After you have set the parameters at least once, they will appear in the "Parameter Fields" section of the "Field Explorer" . If you need to reset parameters, either use "Verify Database" or preview the report and refresh the report information and you will be prompted for parameters again.
Hope this helps.. i don't know exactly your setup, so i;m using mine as a reference..
EDIT : Also, CR treats stored procs as if they were tables.