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---A Death In The Gunj Theatre, Movies & Cinema Thursday at 12:53 AM
    Ashdoc's Movie Review---G Kutta Se Theatre, Movies & Cinema Jun 17, 2017
    Ashdoc's Movie Review---Sachin , A Billion Dreams Theatre, Movies & Cinema Jun 8, 2017
    "Mera Jeevan Safar" (Autobiography Of Prof. H. S. Virk) - Book Review By Dr. D. P. Singh* Blogs Jun 1, 2017
    Ashdoc's Movie Review---The Lost City Of Z Theatre, Movies & Cinema May 31, 2017

  3. OP
    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?
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page