首先创建一个多值参数(param1")，可用值范围为 1 到 10.

First create a multivalued parameter ("param1"), with available values ranging from 1 to 10.

然后创建一个查询(query1)，返回1到10的参数过滤掉从param1"中选择的值 -> where query1.col NOT IN (@param1)

Then create a query (query1), which returns the parameters from 1 to 10 filtering out the selected values from "param1" -> where query1.col NOT IN (@param1)

然后创建另一个多值参数(param2")，设置一个默认值(从查询中获取值)指向query1"以填充未选择的值

Then create another multivalued parameter("param2"), set a default value (get values from a query) point to "query1" to fill in the unselected values

使用带有以下代码的文本框=Join(Parameters!param1.Value,",")"

use a text box with the following code "=Join(Parameters!param1.Value,",")"

要进行 query1，您可以使用联合.

To make query1 you can use unions.

您将取回未选择的值，