sharepoint ssrs parameter using 'LIKE' operator RRS feed

  • Question

  • 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.

    Monday, November 15, 2010 4:39 AM