Hi all,
I am using Crystal 2008. I am using a parameter based formula for record selection. I want the last option to basically say, if "none of the above". Any idea how to make the last one give me everything else that does not fit the other categories?
I tried just using the field name but that gives me an error. If I leave the last if statement off, I get no records. If I use "true" then I get all records which is covered by the first option.
If {?Merchants} = "0" then
true
else
if {?Merchants} = "1" then
({TRANSIT_FACILITY.SHORT_DESC} startswith "CVS")
else
if {?Merchants} = "2" then
({TRANSIT_FACILITY.SHORT_DESC} startswith "Giant")
else
if {?Merchants} = "3" then
({TRANSIT_FACILITY.FACID} in [6022, 5055, 6023, 6024, 6028])
else
if {?Merchants} = "4" then
({TRANSIT_FACILITY.SHORT_DESC} startswith "PRTC")
else
if {?Merchants} = "5" then
({TRANSIT_FACILITY.SHORT_DESC} like "*Commuter*")
else
if {?Merchants} = "6" then
({TRANSIT_FACILITY.SHORT_DESC} startswith "Zodiac")
else
if {?Merchants} = "7" then
????