I have list having columns emp name ,emp group. One employee can be in one or more groups. So in Emp list column empgroup may contain one or more goup.like(Group1,group2) data in list is like below empName empGroup --------------------------------- EMp1 Group1 Emp2 Group2 Emp3 Group1,Group2 Emp4 Group2 When I create report in SSRS group by Emp groups. If employee is in group1 and group2. It shows that employee under group1,group2 and not in seprate group1 and group2. What can I do to show that emp in group 1 as will as group2.? Can I filer the parameter in repot using LIKE perator so that when I select group1 in parameter it will show empname in that group also? or else I have to select group1,group2 as parameter.