Crystal Reports: Add a parameter to query

Question

I'm using the Crystal Reports add-on to Visual Studio. The report calls a stored procedure with a whole list of parameters. I added an int parameter to the stored procedure, now I want to make the crystal report pass a 1 for that parameter.

How do I do that? When I go to database expert > Selected Tables - it just shows the name of the stored procedure. Where does it list the parameters?

Answer 1

If you already created the report and added the parameter to the stored procedure after that you need to use "Verify Database" to get the parameter to the report