Record Selection prob

[AdamRicko]

Hey Folks,

Should be a fairly simple one here but cant get my head around it, in my head its logical :S .

Here is my current record selection formulae:

{Sales.DayName} = "Saturday" and
(
{Sales.ItemName_P} startswith "11'" or
{Sales.ItemName_P} startswith "9's" or
{Sales.ItemName_P} startswith UpperCase ("Kil") or
{Sales.BaseUOM_P} startswith uppercase ("CASE") or
{Sales.BaseUOM_P} startswith uppercase ("PACK") or
{Sales.MainProductGroupCode_P} = "41"
)

Basically im looking to only show ceartain types of products that are sold on a Saturday.

All is working except for the "{Sales.ItemName_P} startswith "9's" or" but if i put this on its own and // the rest out it does work.

I think its something to do with my logic but am unsure.

Many Thanks in advance,

AdamRicko

CR 2008

 

[IanWaterman]

Is it possible for {Sales.BaseUOM_P} to be Null

If Crystal encounters Nulls formula tend to fall over.

Add a condition to deal with Nulls for that field.

Ian

 

[lbass]

You don't need to specify ucase when hardcoding text. Can the field be lower or mixed case? Then use:

{Sales.DayName} = "Saturday" and
(
{Sales.ItemName_P} startswith "11'" or
{Sales.ItemName_P} startswith "9's" or
ucase({Sales.ItemName_P}) startswith "KIL" or
ucase({Sales.BaseUOM_P}) startswith "CASE" or
ucase({Sales.BaseUOM_P}) startswith "PACK" or
{Sales.MainProductGroupCode_P} = "41"
)

-LB