locked
hiding column based on permission RRS feed

  • Question

  • Hi,

    I recently had a request from a client who wants to hide a column in a report based on a user's permission.

    e.g.

    Col1 | Col2 | Col3 | Col4

    Users belonging to Group1 can view all columns

    Users belonging to Group2 can view Col1, Col2, Col3

    Users belonging to Group3 can view Col1, Col2, Col4

    where Group is defined in Active Directory

    I did not want to create 3 separate reports as this will cause some maintenance overhead, but it seems like the only other solution would be to use code to query AD using the CurrentUser and retrieve the group or maybe use my own "security" setup in some tables in the database rather than AD?

    Is there a recommended best practice to solve this?

     

    Thursday, April 29, 2010 4:41 AM

Answers

  • First create the infrastructure (set of tables) for user /group, column & permission.

    In SSRS you can get the user id from

    User!UserID

    Pass this to the SP to get the permission for the columns.

    then hide/show based on the permission

    • Proposed as answer by Jerry Nee Monday, May 3, 2010 2:45 AM
    • Marked as answer by Jerry Nee Friday, May 7, 2010 10:45 AM
    Thursday, April 29, 2010 7:01 AM