Record Selection Formula

[pgmr]

Hi,
CR 8.5 Pro, reporting off a SQL Server.
My selection formula :
If {?Infants} = "Yes" then
{Classifiers.Name} = {?Division}and Isnull({StyleSummaryStoreSpecial.StoreSpecial}) or
{Classifiers.Name} = {?Division} and ({StyleSummaryStoreSpecial.StoreSpecial} <>"Retail").
StyleSummaryStoreSpecial is a view.
The problem is I can select records where StoreSpecial="Retail", I cannot select where StoreSpecial<>"Retail" Any idea why?
Thanks in advance

 

[kskid]

Change the Record selection to

{?Infants} = "Yes" and
(
(
{Classifiers.Name} = {?Division}and Isnull({StyleSummaryStoreSpecial.StoreSpecial})
) or
(
{Classifiers.Name} = {?Division} and {StyleSummaryStoreSpecial.StoreSpecial} <>"Retail"
)
)

Cheers,
-lw