how to take out some items from a complete parameter drop down list?

[francesguan]

I am trying to take out several items from a complete parameter drop down list, like if I set parameter @customer, and when you get all data from customers, it could be more than 1000 customers, I want all of them except customer_1, customer_5, Customer_100; how can I get it?
any comments and suggestions are appreciated,
Frances

 

[MrBillSC]

It is not clear to me if you want customers 1,5,100 to not show up in your parameter list or if you do not want them to show up on the report if you select all customers. Can you please clairify?

MrBill

 

[francesguan]

Mrbill,
I don't want them show in the report.
I want to give users two option: one is for all; another one is for all but expcept those customers 1,5,100, maybe I give this option a name like: USA-customers;
so in the customers drop list they will see:


all
USA-customers


I am not sure whether it is clear or not,
Thank you!
Frances

 

[MrBillSC]

Let's say your parameter values are something like this:
// paramter {?SelectCust}

parameter value: 1 description: "All Customers"
parameter value: 2 description: "USA Customers:

In your record select formula enter something like this:

{?SelectCust} = 1 or
({?SelectCust} = 2 and Not ({table.CustNo} in [1,5,100]))

It would be better if your customer table had a field to identify a customer's country then you would not have to keep track of customer numbers within the report. For example if your table has a field called country:

{?SelectCust} = 1 or
({?SelectCust} = 2 and {table.Country} = "USA")

MrBill

 

[francesguan]

Thank you so much, MrBill, it's working!