Skip to Content
0
Former Member
Jan 21, 2012 at 05:27 PM

OPTIONAL procedure's parameters ('set to NULL')

39 Views

Hello there

I do have a report based on a stored procedure.

I have declared my variables in the stored procedure.

When the report prompts for user parameters, I see 'set to null' checkbox under all the parameters imported from the procedure.

Is there a way to disable 'set to null' checkbox and make the parameter OPTIONAL (so user can leave it as blank if not required)

Thanks in advance

Misagh