Multi Value Paremater

[Llazwas]

I'm using Crystal X and a ODBC. I'm having trouble with a multiple value parameter including and excluding my data and I think it's because of my selection criteria. Generally my data fields ({vdvVendor.UserFld1} and ({vdvVendor.UserFld2} have data in them but occasionally they're blank and I think that's where I'm getting screwed up.



My paramters are:
{?Date Range} - No default values
{?1099 Year} - No default values
{?Corporation} - Default values Y,N

And my current selection criteria are:
{vdvVendor.CompanyID} = 'PCV'
and {vdvVendorPayment.PostDate} = {?Date Range}
and ({vdvVendor.UserFld1} <> {?1099 Year} or {vdvVendor.UserFld1} = "" )
and ({vdvVendor.UserFld2} = {?Corp?} or {vdvVendor.UserFld2} = "")

Don't know if I included enough info but any help will be greatly appreciated.

 

[Turkbear]

Hi,
Test for NULLs first...Not the same as blanks in some databases. try somethig like this:

If ( NOT IsNull({vdvVendor.UserFld1}) then 
(
({vdvVendor.UserFld1} <> {?1099 Year} or  {vdvVendor.UserFld1} = "" )
)
and
If ( NOT IsNull({vdvVendor.UserFld2}) then 
(
( {vdvVendor.UserFld2} = {?Corp?}
 or  {vdvVendor.UserFld2} = "")
)

and

{vdvVendor.CompanyID} = 'PCV'
and 
{vdvVendorPayment.PostDate} = {?Date Range}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Llazwas]

Thanks Turkbear. They did wind up being nulls and I resolved this by adding two formulas:

{@1099Year} =if isnull({vdvVendor.UserFld1}) then "Y" else {vdvVendor.UserFld1}

{@Corp} = if isnull({vdvVendor.UserFld2}) then "C" else ({vdvVendor.UserFld2}


and changed my selection formula to:

{vdvVendor.CompanyID} = 'PCV'
and {vdvVendorPayment.PostDate} = {?Date Range}
and ({vdvVendor.UserFld1} <> [{?1099 Year},"Y"]
and ({vdvVendor.UserFld2} = [{?Corp?},"C"]


This worked for me. Thanks very much for you help.