How I can remove Null Option Checkbox from the input parameters??

[Former Member]

Hi,

I am using a stored procedure with some input parameters(Date,Number,String). I want to remove Null option checkbox for some of the input parameter from Crystal report "Enter Input" prompt.

Thanks in advance....

Edited by: Deepak Sisodia on Oct 1, 2008 10:24 AM

[Former Member · Accepted solution]

Hi Deepak,

This is by design, you can't remove the Set to Null check box from your input parameter.

To avoid this you may have to create you input parameters at report level.

Thanks,

Sastry

[Former Member]

Hi Deepak,

As a workaround try this

use add command like this

Exec SPName {?Parameter}

It wont show set to null option.

Hope this helps!

Raghavendra

[Former Member]

I have checked it again but it's not working?

[Former Member]

Hi,

I have given a default value for that input field in the Stored Procedure.

But than also its not working.I am having that Null checkbox still there.

[Former Member]

Has anyone found a solution to this problem?

[Former Member]

You have declared parameters wtih default null value in strored procedure. If you remove parammeter default null value from stored procedure ,You won't see null option checkbox in crystal report.