slimshades26
Technical User
I have the need for the user to choose one of or ALL in the following parameters. My issue is that Crystal is choosing to use one parm over another or not use any at all. I need the user to be able to choose ALL customers in US and not have to fill out what state they are in. Or type one customer number and not complete the state or country by leaving it "ALL". My parameters have been where the user could choose to see customers in TN, TX and CA, so my "ALL" parameters are multiple value type. The others are single choice parameters.
An oddity I've observed is that by moving the statements up or down in the record selection formula seems to cause varying results. But one statement is just as important as another if the user chooses it.
Thanks for looking. ATM
{F5542016.SSDATE} = {?DateYear} and
{F5542016.SSMCU} = {?MCU} and
{F03012.AICO} = {?AICO} and
If {?LOB} = "ALL" then true else {F03012.AIAC29} = {?LOB} and
if {?Cust} = "ALL" then true else totext({F5542016.SSAN8}) = {?Cust} and
if {?State} = "ALL" then true else {F0101.ALADDS} = {?State} and
if {?Country} = "ALL" then true else {F0101.ALCTR} = {?Country}
ss26
An oddity I've observed is that by moving the statements up or down in the record selection formula seems to cause varying results. But one statement is just as important as another if the user chooses it.
Thanks for looking. ATM
{F5542016.SSDATE} = {?DateYear} and
{F5542016.SSMCU} = {?MCU} and
{F03012.AICO} = {?AICO} and
If {?LOB} = "ALL" then true else {F03012.AIAC29} = {?LOB} and
if {?Cust} = "ALL" then true else totext({F5542016.SSAN8}) = {?Cust} and
if {?State} = "ALL" then true else {F0101.ALADDS} = {?State} and
if {?Country} = "ALL" then true else {F0101.ALCTR} = {?Country}
ss26