Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

LBI Current User Formula???

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
DanH
New Member
Posts: 2
New Member
1/2/2014 3:20 PM
    I am publishing an EE roster of 6000 people. I need the Manager running the report to only view employees they have access to. I concatenated a few fields where the IDs are to make the field i want touse to check the manager .

    i already tried the formula below:

    CurrentCEUsername in {@Manager String} in lbi and crystal but it did not pull the data. In LBI, it kept asking the users for a default ID and PW.

    Can someone please assist? Thanks!
    Tags: LBI, CurrentCEUsername
    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
    1/2/2014 4:24 PM
      Dan,

      The @CurrentUser variable is the LBI/Reporting Services variation of Business Object's CurrentCEUsername to get the user logged into the current session.

      Chris
      Tags: LBI, CurrentCEUsername
      DanH
      New Member
      Posts: 2
      New Member
      1/2/2014 6:06 PM
        Chris, I am having issues getting it to work with @currentuser. where would i enter that? a formula, parameter, etc?

        And can i use that when using the "in" function while looking in a field?

        Thanks!
        Tags: LBI, CurrentCEUsername
        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member
        1/2/2014 6:39 PM
          DanH: You need to create a parameter (in Crystal) called LAWSONRS_CurrentUser (caps matter in this case)
          Now, depending on what you are using as your login to lawson, will matter how you create this parameter field.
          We are using our employee numbers here, so I created it as Type=Number List of Values=static - If you are using alphanumeric logins, create this as Type=String
          Then you should be able to use it as any other parameter field in your report-- but it likely will not return any data from Crystal itself.
          It needs to be published in LBI in order to pick up the LAWONRS_CurrentUser information.
          Tags: LBI, CurrentCEUsername