1 Reply Latest reply on May 26, 2013 8:01 PM by TexasApexDeveloper

    How to make user only view entries on reports under their userid

    1010628
      Hi guys so I made a report about different users and I want it that only the user logged in can see their individual report rather than all the reports!

      I've tried everything from userid() to getrecord() but it doesn't work, can you guys give me some tips please?
        • 1. Re: How to make user only view entries on reports under their userid
          TexasApexDeveloper
          So if you have a report that has data based on user information, you can just write your query in such a way to limit what data they have entered:
          Select Alpha,
                    Beta,
                    Charlie
            from Report_Data 
            Where Created_By = v('App_User');
          
          or
          
          Select Alpha,
                    Beta,
                    Charlie
            from Report_Data 
            Where User_Id = v('App_User');
          
          (App User is a column in the table that the other data is associated with)..
          
          Thank you,
          
          Tony Miller
          LuvMuffin Software
          Ruckersville, VA