Parameter values - "ALL" records versus one specific 1

[piovesan]

Hi There...... I have asked sort of a similar question in the past, but I quess I cannot answer this related question myself because I don't really "understand" what the formulas are doing...... your help would be appreciated!

I have created in the past, two static parameters where the user can select from lists of existing attributes that are in the two fields that each parameter is associated with, AND, for one parameter, I also added a value called "ALL". Then, based on advice I got on this website, I created a formula that put them together like this:
({LND_HRM_PARCEL_MULTI.MAIN_CLASS}={?Test Classification} or {LND_LAND_CLASSIFICATION_MULTI.CLASS}= {?Test Classification})
and
({?All Owners} = "ALL" or {LND_HRM_PARCEL_MULTI.OWNER}={?All Owners})
This works great! I can select an individual owner type from my list of owners, or, I can select "ALL" and I get everything in the list.

I want to do a similar thing, but this time it is with that Main_Class field. I want to give the user the choice of either one particular attribute that is in the Main_Class field (the choice would be "Business Park") OR, all the other class attributes except the Business Park records....... How can I do this?? Hope this is clear what I am asking!
Thanks!

 

[lbass]

But you are using the same parameter also for the multi-class field. Would you want the same options available for both fields? I.e., Business Park or Not Business Park?

-LB

 

[piovesan]

All I want really is for the user to be able to run the report for either just the Business Park classifications, or all the other classifications, leaving out the Business Park ones..........

 

[lbass]

You didn't answer my question. In your first post, you have two different fields set to the same parameter. I don't know how you want to work with that second field in relation to the parameter.

-LB

 

[piovesan]

I don't need the Muli table at all.... I just used that as the example of the last one I did.... So, I sort of want this:
({LND_HRM_PARCEL_MULTI.MAIN_CLASS}={?Test Classification)

Where the Test Classification parameter has only two choices... either it's a Business Park, or it's not........

 

[lbass]

I would just up the parameter {?Test Classification} as a string then with options like: Business Park and Not Business Park. Then set up your selection formula like this:

(
(
{?TestClassification} = "Business Park" and
{LND_HRM_PARCEL_MULTI.MAIN_CLASS} = <value for Business Park here>
) or
(
{?TestClassification} = "Not Business Park" and
{LND_HRM_PARCEL_MULTI.MAIN_CLASS} <> <value for Business Park here>
)
) and
(
{?All Owners} = "ALL" or
{LND_HRM_PARCEL_MULTI.OWNER}={?All Owners}
)

-LB

 

[piovesan]

This solution seems to give me Business Park records with either choice.....

 

[piovesan]

oh wait.... I see what I did wrong.......

 

[piovesan]

OK!! Got it!! And I think I even understand what I am doing this time!! Excellent! Thanks!