PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/20/2017 8:21 AM by  Who Da Philly
LBI On Demand-passing in authuser value
 7 Replies
Sort:
You are not authorized to post a reply.
Author Messages
petec
Private
Private
Basic Member
(10 points)
Basic Member
Posts:4


Send Message:

--
10/18/2012 1: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
    Private
    Private
    Veteran Member
    (825 points)
    Veteran Member
    Posts:277


    Send Message:

    --
    10/18/2012 2:02 PM
    Yes, but it's been awhile and need to check old notes. Will follow up with info...
    Matthew Nye
    Private
    Private
    Veteran Member
    (1532 points)
    Veteran Member
    Posts:514


    Send Message:

    --
    10/18/2012 2: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
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    10/18/2012 3: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
    Private
    Private
    Veteran Member
    (1244 points)
    Veteran Member
    Posts:444


    Send Message:

    --
    10/19/2012 12: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
    Private
    Private
    Veteran Member
    (117 points)
    Veteran Member
    Posts:39


    Send Message:

    --
    10/21/2012 11:24 PM
    Hi there,

    I had written an illustrated article on this very topic last year, see here: http://lbinote.com/passing-paramete...o-crystal/
    petec
    Private
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    10/31/2012 1: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
    Senior Programmer / Analyst
    McLeod Health
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    07/20/2017 8:21 AM
    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.
    You are not authorized to post a reply.