Greetings, I have a SharePoint list that I am using as a report data source. In the data source I have a column for states that we defined as a multiple selection choice field. I would like to use this data source to create a map of who is assigned a state. I am stuck in transforing the multiple selection into multiple rows in the query designer. Here is my Query Designer Text: <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ListName>Responsibility</ListName> <ViewFields> <FieldRef Name="Title" /> <FieldRef Name="AssignedTo" /> <FieldRef Name="States" /> </ViewFields> </RSSharePointList> Any help would be appreciated! Thanks, Kevin

Hi Kevin, Based on your scenario, I suggest that you create a multi-value parameter manually, configure it to retrieve available and default values from the dataset query, and then add a filter to the dataset. If you want to modify the CAML query generated by the SharePoint List data source indeed, please refer to the following thread that has a same topic: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/2285fdf9-c86b-439f-96a2-d07300ef68b1/ Regards,Mike Yin TechNet Community Support

Hi Kevin, Based on your scenario, I suggest that you create a multi-value parameter manually, configure it to retrieve available and default values from the dataset query, and then add a filter to the dataset. If you want to modify the CAML query generated by the SharePoint List data source indeed, please refer to the following thread that has a same topic: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/2285fdf9-c86b-439f-96a2-d07300ef68b1/ Regards, Mike Yin TechNet Community Support Thanks for the reply - Want to make sure that you understand my issue. Here is what my data looks like: ID | Name | State 01 | John | AK; AZ; CA; CO; CT; HI; IA; ID; IL; WY; 02 | Mary | IN; KY; MA; ME; MI; MN; MT; ND; NE; NH; NJ; NM; 03 | Bill | OR; PA; RI; SD; TN; UT; VT; WA; WI; WV; NY; OH; Here is how I think that I need to transform my data to report on it: ID | Name | State 01 | John | AK 01 | John | AZ 01 | John | CA 01 | John | CO 01 | John | CT 01 | John | HI 01 | John | IA 01 | John | ID 01 | John | IL 01 | John | WY 02 | Mary | IN 02 | Mary | KY 02 | Mary | MA 02 | Mary | ME 02 | Mary | MI 02 | Mary | MN 02 | Mary | MT 02 | Mary | ND 02 | Mary | NE 02 | Mary | NH 02 | Mary | NJ 02 | Mary | NM 03 | Bill | OR 03 | Bill | PA 03 | Bill | RI 03 | Bill | SD 03 | Bill | TN 03 | Bill | UT 03 | Bill | VT 03 | Bill | WA 03 | Bill | WI 03 | Bill | WV 03 | Bill | NY 03 | Bill | OH Obviously, if this was all of the data, then I could easily just do a simple transformation, but as it stands I have 200+ rows with a multiple selection state box. Imagine how long the list would be if had a single state selection. After I submitted my original post I continued to search for a question and stumbled upon this one: http://social.msdn.microsoft.com/Forums/en-IN/sqlreportingservices/thread/555e10ca-d017-42c4-9d9e-1a0b96c5149c Your response mentions that we need to contact MS support to get assistance. We are planning to open a case next week. Is this still the case? Thanks