Conditional Paremeters

[reidtw]

I currently have three parameters that require the user to select a Pool Side, Custodian and a Currency (or more than one value of each). What I would like to do is: -

1. to give them the ability to select one or a combination of them without the non-selected parameters affecting the result, i.e. returning no data because the user did not select all the parameters.

and

2. create a conditional parameter for the currency where the user can select, for example, currency <> GBP, thus returning all the currencies that are not GBP.

Possible or not?!?

[PC1]

 

[MColeman]

This thread shows how to use All as a default for your parameters.

thread767-790404

 

[reidtw]

Thanks for your reply, unfortunately CR is looking for a string where I have input the parameter as follows: -

If
{?PoolSide} <> "All"
Then
{Account.PoolSide} = {?PoolSide}
Else If
{?PoolSide} = "All"
Then
True

Any ideas why it is not accepting my parameter?

 

[flowersr]

Try this code:

{?PoolSide} in ( 'ALL', {Account.PoolSide})

I use it all the time in 7.0 . Just make sure that the case of 'ALL' is the same between the parameter value and Record Selection formula.

Rich

 

[reidtw]

Hi Rich,

Thanks for your reply but this doesn't appear to work in v8.0 but I have found what I think is a working solution in thread 767-99969 (the post from synapsevampire).

Thanks again

T

 

[reidtw]

Hi all!

Almost forgot to ask if anyone has looked at having a parameter with a condition of "does not equal" the <value> entered as an option?

For instance, when the user has chosen the values for the first two parameters where record selection is: -

(if {?PoolSide}[1] <> 0
then
({Account.PoolSide} in {?PoolSide})
else
if {?PoolSide}[1] = 0
then
true)

and

(if {?Custodian}[1] <> 'All'
then
({Account.NumberX} in {?Custodian})
else
if {?Custodian}[1] = 'All'
then
true)

and

(if {?Currency}[1] <> 'All'
then
({AccountBalancesMaxdateView.Currency} in {?Currency})
else
if {?Currency}[1] = 'All'
then
true)

I would like them to be able to either choose the currency and "Add" as tha value or exclude a currency by adding it as the value but also having to choose the condition <>.

Does this make sense to anyone!!!

Cheers
T