Search code examples
stored-procedurescrystal-reportsparameter-passingcrystal-reports-xi

Call sp with parameter without user input from Crystal Reports Developer


I am using Crystal Reports Developer version 11 (XI). I am using a stored procedure that accepts a parameter. The problem is that I have to repeatedly call the procedure for a series of subreports, each with a different parameter. And I don't want the user to have to input the parameters each time the run the report because there are so many. I want the parameter to static and stored in the report.

But I cannot see how I can do this. Is it even possible? How can I do this? The parameter options in Field Explorer appear to be just for filtering after the call.


Solution

  • Adding a default value for the parameter solves the problem.