Changing Passed Parameter Values in Crystal Reports for a Stored Procedure
Posted on 2004-10-26
Ok, Just needing a Quick response.... I have a SQL Stored procedure that requires two values to be passed to it, these are @QueryDate and @PrevWeekLoop.
When i first specify the Stored Procedure in Crystal it comes up with a box where i set up the Parameter Values, i.e. i specify 18/06/2004 for @QueryDate and @PrevWeekLoop as Zero, after taking both of then off Default to Null.
Now, i work on the Report for a while, previewing it a few times, but also updating the SQL Stored Proc a few times too, Clicking Update Database every time. The Crystal Report will always find the changing and update itself.
Now, After a while, after changing the SQL Stored Procedure, the @QueryDate and the @PrevWeekLoop are now suddenly defaulting to Null and i can't find a Screen to specify any defaults. Also, When i press the Refresh Report Data button, it prompts me with 'Do i want to use the current parameter Values or do i want to Prompt for new parameter Values' ... After selecting the Latter, no box appears and my blank report appears in the Preview screen (Which is being caused by Nulls being passed for both Values)
How do i edit the values that are being passed to my stored procedure??
I'm using XP and CR10.