Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
LBI On Demand-passing in authuser value
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
272
Members:
0
Total:
272
Online Now:
New Topics
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
LBI On Demand-passing in authuser value
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
petec
Basic Member
Posts: 4
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
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
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.
Ruma Malhotra
Veteran Member
Posts: 412
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
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
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
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
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.
You are not authorized to post a reply.