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:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
274
Members:
0
Total:
274
Online Now:
New Topics
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
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
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
Create report based on report user employee hierarchy
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
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
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
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
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
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
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
Yes I have access to mylawson.com . Reading pages 105-108 right now.
agersh
Veteran Member
Posts: 81
6/21/2012 1:27 PM
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
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
My email address: Alan.Gersh@martinhealth.org
Greg Moeller
Veteran Member
Posts: 1498
6/25/2012 1:56 PM
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
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
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
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
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
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
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
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
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
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/
You are not authorized to post a reply.