Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Capture User ID

Sort:
You are not authorized to post a reply.
Author
Messages
David V
Basic Member
Posts: 22
Basic Member
4/19/2010 6:16 PM
    Is there a way to capture the user name and display it on the report? And does anyone know how to capture rules info for a user. So I need a report that lists the current user and the rules that exist for that user.

    Example:

    Current User - ABC

    Rule - Company
    Values - 1,2,3,4
    Jimmy Chiu
    Veteran Member
    Posts: 641
    Veteran Member
    4/20/2010 1:01 PM
      You can use security administrator to create security report for a user. There is not a lawson utility that can track "logged in user" by name/ID.
      Char
      Veteran Member
      Posts: 62
      Veteran Member
      4/20/2010 1:33 PM
        You can create a parameter in the report and within LBI set it to hidden = true and prompt = false and in the value put @CurrentUser and it will pass the user ID to that parameter which you can then display within the report. I do the same thing except I use it in record selection to enforce row level security by company and accounting unit
        David V
        Basic Member
        Posts: 22
        Basic Member
        4/20/2010 2:38 PM
          @CurrentUser worked thanks guys!
          Jimmy Chiu
          Veteran Member
          Posts: 641
          Veteran Member
          4/21/2010 4:18 AM
            Gotta try this one out myself. Good one!
            You are not authorized to post a reply.