I've created a report with various paramater all which work ok individually but ive come accross an oddity on a couple. UserList is a list of Users, ProjectList is a list of Projects which relate to the User selected in UserList. By default it selects all for both, if I change Userlist to select 2 users it shows me the Projects for those users only as expected. If i then change it to show me 3 users it shows me the jobs for all 3 users but only selects the job for the original 2 users. Any ideas why this is?Pete

Correct me If my understanding is wrong. Whether the UserLists and ProjectLists Parameters are dropdown or multiselect parameters. If the ProjectLists parameter is textbox then the textbox will not refresh with the selections. If it is dropdownlist, then check how you are passing value to the projectlists dataset. Nanda

Hi Nanda, Yes their both mult selects, the dataset which populates the ProjectsLists has a where statement for userlistfieldname in (@UserList) Any ideas? ThanksPete

1: Try checking with SQL query whether your query is able pick the expected values from the UserList values. 2: Try removing the Default values for ProjectList multiselect and assign only Available values.Nanda

Hi Pete, I came across this problem, well nothing you cant do about it and it's a bug in SQL Reporting Services 2008. the only way you can solve this problem is try to cut down your parameters to 2 or try to concatinate the third parameter in to the second one. In my issue i use to have Manager, Month and Year a parameters so i have kept them as Manager as one parameter and Concatinate Month and Year as another parameter but this will not work in all considerations. so my second and third parameter concatinae like this July - 2010 etc. All the best .Dasari