SQL - Passing a Stored Procedure Variable as a Parameter in a crystal report for end users to select
Ok here are the steps I took to reference parameters from my crystal report to the stored procedure.


Add parameter declarations in stored procedure like so:

ALTER PROCEDURE [dbo].[a_ras_TruckSummary_SP] 

@location VARCHAR(10),

@dateshipped DATETIME 
Then navigate to crystal report builder and select "Database>>>>Database Verify". This will refresh the database connection and present your parameters as a dialog box. From there you will enter your values to test the parameters
If they test ok the dialog box will be closed and you can then navigate to "field explorer" and under "parameter fields" you will now see your new parameters.
Then you can simply drag them over to the report.