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

LBI On Demand-passing in authuser value

 7 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
petec
Basic Member
Posts: 4
Basic Member
10/18/2012 5:51 PM
    We are using the LBI RS ers/ersRequestHandler.jsp? to create report bookmarks in Portal for remote EMSS users. Has anyone been able to use &SelFormula or perhaps &LawUserID to pull the authuser value (user who has logged in)? For example, if user 3436 logs in, I want that valued passed as a parameter into the LBI\Crystal report so the user only sees their data.

    Let me know. Thanks. (need it for Portal and eventually workspace, these users won't have LSO).
    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
    10/18/2012 6:02 PM
      Yes, but it's been awhile and need to check old notes. Will follow up with info...
      Matthew Nye
      Veteran Member
      Posts: 514
      Veteran Member
      10/18/2012 6:15 PM
        Be curious to see what Chris has on this but as I recall you need to add a new parameter to the crystal report called LAWSON_CurrentUser. Supposedly this is a supported RS variable that will automatically pass the username. Just a note, there was a known bug with this that it will not work in one of the early releases of RS 9.0.4.2 so you may need to patch RS first.
        If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
        10/18/2012 7:10 PM
          This will work work when you add a new LBI parameter and call it "UserID" . On the LBI parameter screen if you map this variable to the RS variable "CurrentUser" you can tie a crystal report data set to the data that the user who logs in can see.
          mark.cook
          Veteran Member
          Posts: 444
          Veteran Member
          10/19/2012 4:26 PM
            I think Matthew and Ruma covered it. We use it alot for reports that we pass to ESS. The employee only sees their data, the report only pulls their data. Works very well for things like PTO Transaction Report, Total Compensation and things like that.

            Will
            Veteran Member
            Posts: 39
            Veteran Member
            10/22/2012 3:24 AM
              Hi there,

              I had written an illustrated article on this very topic last year, see here: http://lbinote.com/passin...ashboard-to-crystal/
              petec
              Basic Member
              Posts: 4
              Basic Member
              10/31/2012 5:01 PM
                Thanks alot everyone. Employee number is numeric (and lbi user is a string), so I created a formula field in Crystal "EmpStr". Then I created the LBI parmeter UserID (per Rama) for that field (hidden as Will describes), and made the Default Value "@CurrentUser". So when I log on with my employee id (our EMSS accounts use that), and click on the report I see only the data for my employee number (so far done the BN242 Benefits Statement and Pay History). Currently only MSS users have LBI, so I'm creating a new "LBIESS" group and just give them one dashboard "Employee Documents". I'll run it by the team, we'll have to watch the capacity of the server, I know this will be easier once we upgrade to LBI 10 (and if necessary add another). Perfect world we'd hoped to pass in "authuser" from the ESS session (so the user wouldn't even need an LBI account), but not sure how doable that is unless we create a custom page. Same hit on the server either way.
                Who Da Philly
                New Member
                Posts: 1
                New Member
                7/20/2017 12:21 PM
                  I know this is an old thread but has anyone had success with this in Version 10? I tried clicking the "Link above" but it is no longer valid.