how to pass optional parameters

[tfurman]

Hi,

I am using Crystal 7 with VB 6. The report is created based on stored procedure, which has dates(declared as a strings) as optional parameters. However, if vb doesn't pass thoses parameter to crystal,a crystal parameter screen pops up.

Basically what I want to happen is that if a value is not passed then crystal should treat this as a null value. How can I make this happen?

In crystal 6 there was an option "Set Value to Null" when you clicked on "Stored procedure parameter". That is no longer valid in Crystal 7.

Your help will be greatly appreciated.

Thank you

 

[synapsevampire]

Perhaps you can pass a default value, and in the record selection value allow for a default of some value or null, as in:

if not(isnull({?parm})) then
{table.field} = {?parm}
else
true

-k