Basically as answered in your other post you add a parameter Field.

You can add it as a BOOLEAN data type and name it whatever but we will call it "My Parameter" for now.

In the Select Expert write a formula that uses the parameter to filter the records.

I think you want it to include all records from your DB if they pick TRUE and only pick a subset of users if they pick FALSE.

so this will be something like:

 

I am at a loss on this although someone else may be able to answer for you. You first need a data source that has a TRUE FALSE option per row that is equivalent to your include or exclude criteria.

However, the problem as I see it is you are looking for a selection of TRUE to include all records and FALSE to limit the selection. Cascading parameters are going to limit it either way and I do not know how you would avoid that.

The only thing I can think of would be to make your firsy parameter allow Multiple values. users would have to select both instead of TRUE to get all users. Otherwise if the select TRUE or FALSE it would limit based on the selection.

Create a Parameter as a Boolean Type (this will automatically make it have TRUE FALSE select values.

You can name it whatever you want but for this example I am naming it "My Parameter".

Now in your select statement you use an OR statment to flip your selection criteria based on the choice of the TRUE or FALSE.

 

With the OR stement it will stop as soon as it finds a condition that is TRUE.

Since you are using a Boolean type and you want all records if the paramter is True the first part of your seelct statement is

 

 

If TRUE was selected in the parameter value then this condition = TRUE and the select formula stops there without doing any filtering (if you have other conditions like date ranges then you need to alter to account for those with an AND statement). This isa lso more efficient because it does not need to read the DB at all.

From there the only oher option for the parameter to be is FALSE.  Therefore if it is npot TRUE then your OR is what you want the select statement to be as if they picked FALSE.

Create one statement with parenthesis around the entire logic if there is more to it than the user id not being  in a list.