Post reply

Filter data by user but let managers see it all

  • April 22, 2009 at 8:18 am

    #203202

    I have a report that currently filters the data. In the dataset, I have this filter: =Fields!SalesRep.Value = User!UserID. That's working.

    However, there are some managers that should see all the information. Can I put an IIf statement in the filter? Something like =IIf(User!UserID = "manager name", "", User!UserID). Basically, it the UserID is the manager's, the filter should remain blank.

    Thanks for any help!

  • April 22, 2009 at 9:00 am

    #982251

    You can filter the data using query

    select * from tablename where columnname=(select case User!UserID when 'manager name' then columnname else User!UserID)

    In Sql where columnname=columnname it will list entire data from table

    Hope this may helpul for you

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply