Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

View certain information on a report

Discussion in 'Information Technology' started by JOM, Nov 1, 2005.

  1. JOM

    JOM
    Expand Collapse
    Guest

    there are 2 secuiry levels in my table: sl 1 serves as a manager and sl2
    serves as a regular employee. if a manager opens a report for a regular
    employee he shoulld be able to view everything on the report but if the
    employee views his own report, he will not be able to view e.g., there
    average rate. How will control that?
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---Force 2 Theatre, Movies & Cinema Nov 20, 2016
    Ashdoc's Movie Review---Rock On 2 Theatre, Movies & Cinema Nov 13, 2016
    Movies Alternate View - Review Of 'PROMETHEUS' Theatre, Movies & Cinema Nov 12, 2016
    Ashdoc's Movie Review---Mr Church Theatre, Movies & Cinema Nov 5, 2016
    Ashdoc's Movie Review---Ae Dil Hain Mushkil Theatre, Movies & Cinema Nov 1, 2016

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    The best way is to build two reports. Give managers access to one and
    employees access to the other.

    Of course, you need to make sure the employees can't simply open your query
    or table and see the data there.

    --
    Rick B



    "JOM" <JOM@discussions.microsoft.com> wrote in message
    news:9C20122C-9AD0-4561-B5EC-277E691F7345@microsoft.com...
    > there are 2 secuiry levels in my table: sl 1 serves as a manager and sl2
    > serves as a regular employee. if a manager opens a report for a regular
    > employee he shoulld be able to view everything on the report but if the
    > employee views his own report, he will not be able to view e.g., there
    > average rate. How will control that?
     

Share This Page