Multiple Fields into One Parameter

hi guys,

i have researched extensively , cant find exact result looking for.

i have 3 fields of names in sharepoint list , set parameter based upon these names.

i want maintain unique values , not join them i.e. name 1, name 2

current fields example:

name field 1	name field 2	name field 3
person 1	person 3	person 5
person 2	person 4	person 6

what want parameter be:

person 1

person 2

person 3

person 4

person 5

person 6

i need user of report able select person want in parameter , able filter 3 columns based upon parameter.

i quite new this, aware may not make sense, please gentle :)

hi dg85,

in reporting services, parameter available values can specified in 2 ways, 1 specify manually , 1 values query. when select values query, can specify 1 dataset , 1 field. in scenario, want parameter available values multiple fields cannot achieved in reporting services currently.

thank understanding.

regards,

---

charlie liao
technet community support

SQL Server  >  SQL Server Reporting Services, Power View