Crystal selection formula

[Guest_imported]

We have two parameters, "State Code" and "Store Id". The user is prompted to enter a value for each of these parameters. The user may select the value "ALL" for each parameter in order to bring back all records, or the may enter a specific value to limit the returned records. We are having problems when we concatenate the two formulas for these parameters. We don't have any problems if we only use one formula and not the other. Here is the concatenated version of the formulas:

(if {?show_specific_store} = -9999 then
true
else
{sp_sales_change_over_time.retailer_id} = {?show_specific_store}) and
(if {?show_specific_state} = "ALL" then
true
else
{sp_sales_change_over_time.state_code} = {?show_specific_state})

It WILL work with only one formula, for example:

if {?show_specific_store} = -9999 then
true
else
{sp_sales_change_over_time.retailer_id} = {?show_specific_store}

Any ideas why? Thanks!

 

[MalcolmW]

What sort of symptoms are you getting with the problem? Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[EarlGray]

Try this (or some variant):

(if {?show_specific_store} > 0 then
{sp_sales_change_over_time.retailer_id} = {?show_specific_store}) and
(if {?show_specific_state} <> &quot;ALL&quot; then
{sp_sales_change_over_time.state_code} = {?show_specific_state})


The idea here is to assume the 'ALL' condition. ECS DataSystems, Inc.

http://www.ecsdata.com

A Crystal Partner