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
Create report based on report user employee hierarchy
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Rich Cowie
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5255
People Online:
Visitors:
330
Members:
0
Total:
330
Online Now:
New Topics
Lawson S3 HR/Payroll/Benefits
Pay Rate History to Show All Positions
2/26/2025 3:34 PM
Does anyone know how to modify payratehistory.htm
Infor CloudSuite
How to build a Pre-Prod tenant
2/7/2025 1:28 AM
After we finished our implementation and ended our
Lawson S3 Procurement
Browser issue with RQC Shopping
1/28/2025 5:49 PM
Since the recent Chrome/Edge updates, our RQC shop
Lawson S3 Procurement
S3-Procurement New Company
1/22/2025 10:38 PM
My Accounting Department has created a new Company
S3 Customization/Development
JUSTIFIED RIGHT
1/15/2025 7:41 PM
Is there a way in Lawson COBOL to make a character
S3 Systems Administration
ADFS certificate - new cert
12/3/2024 9:38 PM
The certificates on the windows boxes expired and
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Lawson S3 Procurement
ED501 Error: Map 850 not supported by /law/c15vda/lawson/test10/edi/bin/laws_out_91
11/12/2024 3:47 PM
Tried runnning ED501 and getting the atathced erro
Lawson S3 HR/Payroll/Benefits
Error
11/6/2024 9:54 PM
When I try to enroll a retiree in 72.1 health plan
Infor ERP (Syteline)
Syteline: New Data Maintenance Wizard (Error) Need help
11/1/2024 4:24 PM
Hi, I need help with an error on syteline while us
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1375
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Create report based on report user employee hierarchy
Please
login
to post a reply.
19 Replies
1
Subscribed to this topic
22 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
agersh
Veteran Member
Posts: 81
6/13/2012 5:59 PM
I need to create a crystal report of employee related data. The report will be viewed by various levels of management, Managers, Directors, AVP or VP. One of the report criteria requested is that the report only display data for the employees that fall under the user running the report. So for example if a Director is running the report, the report should only include the employees that are under that director’s organization chart hierarchy. Using Lawson LBI Bursting option, the crystal report can only filter the data one user level, not the full hierarchy of the user running the report. Is there some sort of method that you can recommend so that LBI or the report can use to determine the data that should be included in the report based on report user hierarchy? Lawson 9.0.1.7.533 (Windows) MS SQL Server 2008 Crystal Reports 2008
Robby
Veteran Member
Posts: 87
6/14/2012 3:04 PM
Split
Agersh, Are you familiar with creating "Reporting Structures" and "Elements" in LBI's Bursting option?
agersh
Veteran Member
Posts: 81
6/14/2012 4:11 PM
Split
Robby, I am somewhat new to LBI. But I am famular with creating Structures and Element pretaining to InfoSets. Have not really played with LBI Bursting except for the Lawson class that I attended.
Robby
Veteran Member
Posts: 87
6/14/2012 4:19 PM
Split
OK, Lets start at the beginning....How is the organization chart hierarchy built...is it based on Department? In other words, which piece of employee data will determine which manager will see the data? (Let's limit the discussion to the first level of the hierarchy (Manager) to begin with)
agersh
Veteran Member
Posts: 81
6/19/2012 2:00 PM
Split
Hi Robby, I apologize for the delay with my reply. Our organization chart hierarchy is based/built on Process Level + Department. The same department code can be assigned to more than 1 Process Level (example: Dept: 6500 (ER), PL 1 = North, PL 6 = South, PL 15 = SLW but they all share Dept Code 6500). Does this make sense?
Robby
Veteran Member
Posts: 87
6/19/2012 4:18 PM
Split
Your structure makes sense, and we can work with that. Do you have access to mylawson.com? If yes, go to the Knowledgebase and find the Reporting Services documentation, Document Number REPUG-904W-02. Read pages 105-108. If you don't have access, send me your email address and i'll send the pdf to you. We need to start with this info to get your report setup correctly. It can be done :-)
agersh
Veteran Member
Posts: 81
6/19/2012 5:05 PM
Split
Yes I have access to mylawson.com . Reading pages 105-108 right now.
agersh
Veteran Member
Posts: 81
6/21/2012 1:27 PM
Split
Robby, I have read Document Number REPUG-904W-02, pages 105-108. Trying to put the pieces together. The following are the fields available in my crystal report: PAY_WEEK, COST_CENTER EMPLOYEE_LASTNAME EMPLOYEE_FIRSTNAME EMPLOYEE_ID EMPLOYEE_EXPTD_WKLY_HRS EMPLOYEE_REG_HRS EMPLOYEE_OT_HRS EMPLOYEE_CALLBACK_HRS EMPLOYEE_SHIFT_EXT_HRS EMPLOYEE_TOTAL_HRS EMPLOYEE_LOGIN EMPLOYEE_SUPERVISOR SUPERVISOR_EMPLOYEE_ID SUPERVISOR_ LAST_NAME SUPERVISOR_ FIRST_NAME SUPERVISOR_LOGIN ** COST_CENTER Notes: COST_CENTER is Process Level + Department, ex. PL = 1, Dept=6500, COST_CENTER=’016500’. The same department code can be assigned to more than one process level. If needed I can separate COST_CENTER into two fields, Process Level and Department.
Robby
Veteran Member
Posts: 87
6/21/2012 1:55 PM
Split
That's Great! We can use "Cost_center" as the "element" to build a bursting "structure". Send me your email address, I'll forward a doc I created, Robby
agersh
Veteran Member
Posts: 81
6/21/2012 2:58 PM
Split
My email address: Alan.Gersh@martinhealth.org
Greg Moeller
Veteran Member
Posts: 1498
6/25/2012 1:56 PM
Split
Could you send that document to moellerg@genesishealth.com as well? I'd be interested in seeing it as well.
agersh
Veteran Member
Posts: 81
6/27/2012 2:24 PM
Split
Robby, thank you for the doc it is very helpful. I setup the following bursting for my crystal report. [Reporting Services Administration – Right Management] Elements: - Cost Center Element - Supervisor Login Element Structures: - Kronos Rpt Element: Cost Center Element, Order: 1 Element: Supervisor Login Element, Order: 2 [Report Details - Report Bursting Options] Method: Data Structure Structure: Kronos Rpt Element to Field Mapping Cost Center Element = COST_CENTER Supervisor Login Element = S_LOGIN ----------------------------------- In order to test with out getting a manager leve person involded at this point I modifed the query that the report uses so that the supervisor login (S_LOGIN) field would = my login id 'agersh', ( 'agersh' AS 'S_LOGIN'). When I try to view the report Lawson displays the following message... Message: There are not any Rights on File for the requested User. UserId: agersh Description: Report Request Failed For: Associates Approaching or In OT - Design Draft.rpt Additional Text: Publication Key: Since I am not a manager/supervisor level user in Lawson would by me setting the supervisor login (S_LOGIN) field in the report query = to my login id cause the above message?
Robby
Veteran Member
Posts: 87
6/27/2012 2:43 PM
Split
Here's my recommendation on a way to set this up and facilitate easy testing. Go back to the Lawson document and read the section on custom groups. Create a custom group for each manager (all levels). That way, when there are manager changes, you would only change the users in the custom group, and to test, make yourself the only one in the group. With custom groups the 'rights' are setup based on the group, not the user. You're getting the error now because your ID doesn't have the correct rights for this report assigned (at least that the way it sounds :-) )
mark.cook
Veteran Member
Posts: 444
6/28/2012 4:14 PM
Split
We went a different direction that seemed to work for us, we use the direct and indirct supervisor codes from HR Super table and link those to the report user. So when I run the report, it sees my user name, matches it to the HR super table and queries only the employee related records that roll up to me as a direct or indirect supervisor. We rely on HR to maintain those codes and do not build bursting rights that we have to maintain as managers, directors, VP's change.
agersh
Veteran Member
Posts: 81
6/28/2012 6:21 PM
Split
Mark, Thank you for sharing the direction that your orgization took. Yes I agree about using bursting rights. Especially lately we have been having plenty of manager and director changes. I am assuming that your reference to indirect supervisor is referring to the HRSUPER.SUPER_RPT_TO field. Looking at the HRSUPER table I see that the SUPER_RPT_TO field is empty for all rows in the table. Is HR not maintaining our managers, directors, VP's correctly in Lawson? Also can you share the steps that you perform to link the direct and indirect supervisor codes from HR Super table to the report user?
agersh
Veteran Member
Posts: 81
7/6/2012 2:45 PM
Split
Mark, I am very interested in seeing/understanding the steps that you performed to link the direct and indirect supervisor codes from HR Super table to the report user. So I wanted to verify that your seen my 6/28/2012 1:21pm reply. Robby, As I previously mentioned I am somewhat new to LBI and creating crystal reports based/filtered on report user employee hierarchy. So the communication that we have been having is important to me. That’s way I am also looking at custom groups as you recommended.
mark.cook
Veteran Member
Posts: 444
7/17/2012 1:43 PM
Split
shoot me an email mark.cook@moffitt.org and I will send along some screen shots or we can do a quick go to meeting that I can show you what we've done
Paul Berkowitz
Basic Member
Posts: 14
8/1/2012 2:48 PM
Split
Robby, Could you send that document as well, to paul_d.berkowitz@lvh.com as well. Current working on a time allocation report. thanks Paul
Donna
New Member
Posts: 1
11/9/2012 1:10 PM
Split
I tried searching mylawson.com & Infor Xtreme for Document Number REPUG-904W-02 to no avail. Can someone please send it to me at doboyd@atlanta.k12.ga.us?
Will
Veteran Member
Posts: 39
11/26/2012 12:09 PM
Split
In case it can help anybody, I have written a blogpost on setting up elements and structures on Reporting Services, it's there:
http://lbinote.com/crysta...ces-bursting-in-lbi/
Please
login
to post a reply.