Crystal XI
SQL Server
I tryiny to write a report where i ask the user for record selection based on values in the database field. The field can have several different values including nothing.
In my prompt i list the values but i am having a problem of how to represent blank value - I have a row in the prompt section that just has Blank for the description and no value in the value column. the user can select one of the values or they can select a combination of values which could include the blank value.
in my select formula i have:
if {?OrderType} in ("WO", "PO", "") then
{OrdType} = {?OrderType}
This will only return records that have a value (WO, PO) in the {OrdType} field even if the user picked the Blank parameter.
Where am i going wrong?
Thanks
Meg
SQL Server
I tryiny to write a report where i ask the user for record selection based on values in the database field. The field can have several different values including nothing.
In my prompt i list the values but i am having a problem of how to represent blank value - I have a row in the prompt section that just has Blank for the description and no value in the value column. the user can select one of the values or they can select a combination of values which could include the blank value.
in my select formula i have:
if {?OrderType} in ("WO", "PO", "") then
{OrdType} = {?OrderType}
This will only return records that have a value (WO, PO) in the {OrdType} field even if the user picked the Blank parameter.
Where am i going wrong?
Thanks
Meg