• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Capture User ID

 4 Replies
 0 Subscribed to this topic
 24 Subscribed to this forum
Sort:
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
4/21/2010 4:18 AM
Gotta try this one out myself. Good one!