Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
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:
1
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
222
Members:
0
Total:
222
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
Forums
Performance Management
Forum:
Lawson Business Intelligence/Reporting/Crystal
Search this forum:
136 Subscribed to this forum
Page 34 of 34
<<
<
30
31
32
33
34
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
lsDrillAround Syntax
Started by
Bob Beverley
(
1
2
)
I'm on RS 1.3 and Crystal RAS 10. When I format an _DRILL field from a Lawson Report (not from RW) I can't get it to display as a hyperlink (not to mention it doesn't drill, but I'll address that later). When I publish and view it the drill field appears with the suyntax.
27
19730
1
by
Bob Beverley
1/25/2007 2:27 PM
ACTRANSREL.mx_value_3
Started by
Deleted User
I am using crystal reports to create a work order report. We currently use the field mx_value_3 in the ACTRANSREL table to distinguish between travel and labor. I lose this field when the work orders move to the ACTRANS and GLTRANS tables. Does anyone know how I might link the mx_value_3 field into my report, from what table it might be held in
2
12792
1
by
Deleted User
1/19/2007 12:51 PM
Employee record & Change Notice
Started by
Deleted User
recently we applied CTP 45859 (Program PA702) which transitioned our PAEMPLOYEE.NEXT_REVIEW_DTE to the Table REVIEW. PA702 runs and updates the REVIEW table with the PAEMPLOYEE info. The problem I am having now, is the report mentioned above - I had to incorparate the REVIEW table, delete the PAEMPLOYEE.Next_Review_DTE field, and put in place REVIEW.NEXT_REVIEW_DTE. We still use PAEMPLOYEE for Hm Phone, Gender, and Birthdate. Below are the tables I am linking in the report: (('EMPLOYEE'.'...
1
12934
1
by
John Henley
12/20/2006 11:42 PM
Years of Service
Started by
Deleted User
I'm using Crystal for the first time in three years and am a little rusty. I know Lawson calculates years of service. You can see it in PA10 and pull it in HR65 reports with the HIRE DATE - YOS field. I am trying to find it in the data dictionary but am not have much luck. Which table stores this field so I can pull it into a Crystal report Thanks.
1
13099
0
by
John Henley
9/29/2006 4:10 PM
COBRA - Outsourcing report
Started by
Shane Jones
I am trying to create a report to provide our third party vendor information on insurance plan terminations... What is everyone doing to track COBRA and ... does anyone have a report that they would like to share Thanks Shane
2
13434
1
by
Shane Jones
9/28/2006 3:50 PM
XTRA: parameters
Started by
Deleted User
Scenario: I am trying to build a Report in Crystal XI from a Lawson report. Customer runs a Lawson Report, I pick up the data using a 'xtra:... ' Lawson Query that the user has provided. Once the report is successfully developed, the customer would like to run the same report against similar Lawson Reports which may use a different Department etc. To accomplish that I would like to create a parameter which allows the user to choose which values are used in the 'xtra' command for the following...
1
13410
2
by
Matthew Nye
9/27/2006 8:25 PM
Training requirements
Started by
Deleted User
I have a report developed that is showing the each course (PATRNHIST) as a column, and the employee's as a row. Now, each column(course) per employee is listing (or, not) the Completion date per course. Question, with this layout - How can I include the Status field (PATRNHIST.COMPLETE_STATS) in a new column right after the complete date, and be sure that this 'F' (code for complete) is for that particular course
4
13306
1
by
Deleted User
9/22/2006 4:47 PM
BOE XI FTP's in binary instead of ASCII
Started by
Carlotta McCormick
Has anyone ever tried to run a Crystal Report on Lawson's Oracle tables through Business Objects Enterprise XI, and then tried to use BOE XI to auto-FTP the file back to Lawson I'm trying to use this process to create an interface file, but the file gets transferred back to Lawson in binary (EBCDIC) format and it needs to be ASCII. I can't find anything on BO's website, and I've had a ticket open with them for over a month, with no luck on their end. They reference Data Integrator to fix the...
1
13789
2
by
Jesse
8/30/2006 4:02 PM
..custom report/parameter pages in LBI 9..
Started by
Jesse
We are currently upgrading our LRS environment from LRS to LBI 9. Our LRS environment was on Windows 2000 with Tomcat as the HTTPd. Our LBI environment is on Windows 2003 with WebSphere as the HTTPd. In LRS we used custom report pages to provide a user with parameters that are then fed into Crystal reports upon run-time. The custom page was a .JSP that would call a SQL Server DB residing on the same box as LRS to query for parameters. The user would then click submit, and the report ran with the...
4
14528
1
by
Jesse
8/30/2006 2:06 PM
Formula Field
Started by
Deleted User
Hey John - or anyone! I am using a formula field to display 'N/A' text on a bad date in lawson review - but thought I had it set to give me the Nth Largest of a review Date. It doesn't. Here is the formula: if{REVIEW.ACTUAL_DATE} = CDateTime (1700, 01, 01, 00, 00, 00) then totext ('N/A') else totext({REVIEW.ACTUAL_DATE},'MM/dd/yyyy') It returns good data, and adds that feature for the 'N/A' but I noticed on quite a few employee's that it does not give the most recent dat...
3
13395
0
by
John Henley
8/17/2006 6:54 PM
LBI Configuration
Started by
Deleted User
Has anyone found any good background information on LBI configuration Lawson help tells us how to configure services but not what they are, what they are used for, how they work etc. When things go wrong, it's hard to debug without background knowledge. For example, we've created attributes and grouped reports into lists. Now we are trying to attach a report list to a dashboard module. If we just paste the list's URL, the user is prompted to login. We are supposed to be able to c...
2
13861
2
by
Deleted User
8/15/2006 1:44 PM
Printing just summary from Crystal
Started by
Deleted User
I have a report that summarizes every employee's PRTIME transactions - comes out to 263,000 records. The problem is, I suppress the detail and just want to print the Grouped Sums...every time I try to export to .CSV it brings all the detail...Help! Thanks!
5
13964
1
by
Matthew Nye
8/14/2006 7:34 PM
Command in Crystal
Started by
Deleted User
I am currently developing an Employee Review report - linking 3 tables (EMPLOYEE, PAEMPLOYEE, & REVIEW) now I want to add a command to just provide an Employees most recent Last Review - does this look correct Also, will adding a command along with tables that are linked - jeopardize the report at all Here is the command: SELECT REVIEW.EMPLOYEE, REVIEW.ACTUAL_DATE, FROM LAWSON.REVIEW REVIEW, WHERE REVIEW.ACTUAL_DATE = (SELECT MAX(REVIEW.ACTUAL_DATE) ...
3
13266
0
by
John Henley
8/10/2006 3:04 PM
Pasting Query to Add Command
Started by
Deleted User
I tried adding this command: SELECT 'employee.company', 'employee.employee', 'employee.last_name', 'employee.first_name', 'employee.middle_init', 'employee.emp_status', 'hrhistory.beg_date', 'hrhistory.date_stamp', 'persacthst.action_code', 'hrhistory.a_value as historical_job_code', 'hrhistory.seq_nbr', 'jobcode.description as historical_job_description' FROM 'hrhistory', 'persacthst', 'employee', 'jobcode' WHERE 'hrhistory.act_obj_id' = 'persacthst.obj_id' AND 'hrhistory.compa...
5
14264
1
by
Deleted User
8/2/2006 1:11 PM
Report for Lawson HR User Fields/Field Codes (PADICT)
Started by
John Henley
Sometimes it's necessary to see what field number(s) are used internally Lawson HR for which fields (including user defined fields) in order to know which FLD_NBR to select from HRHISTORY. This information is stored in PADICT. Here are two reports I use to lookup the field numbers, one for standard fields, the other for user-defined fields. You will need to 'Set Datasource Location' in Crystal to point these reports to your database.
6
21274
2
by
John Henley
7/19/2006 1:32 PM
Multiple Data Sources for report
Started by
Deleted User
Hello there! Currently we use PMM for our MM/Purchasing Suites, and Lawson for GL. As it stands we are generating 5 monthly reports that show (1)Receipt Accruals - PMM, (2)Invoice Distribution - PMM, (3)Issues Summary(stock items) - PMM, (4)GL Transactions - Lawson, & (5)Reconciliation. These five go the acct user as a .CSV which is then uploaded to Access, and finally displayed in Excel using embedded Macros and Formula. There are 5 tabs, and each sheet represents the above mentione...
1
14294
1
by
John Henley
7/17/2006 12:27 AM
Reporting environment question
Started by
Deleted User
Im am using a host of tools (Report Writer, Crystal, Access) to report data against Lawson HR and Financials. However, as I get more and more complex requests, I find myself massaging the data alot in the MS Access enviroment to meet some of my reporting requirements. Id like to understand how other practitioners have their reporting environments setup. Do you use Lawson's data mart solutions Or have you built a custom DW What are the challenges you still face with your solution ...
1
13490
1
by
Chris Martin
7/8/2006 8:53 PM
Lawson LRS Server Can't see instance of report
Started by
Kate Liamero
We are creating instances of large financial reports and pointing the dashboard links to the latest instance of the report and getting the following error: com.crystaldecisions.report.web.viewer.CrystalReportViewer Error in file d:\LawsonDocuments\{74611693-5D8F-4A43-A680-65960C5F0859}.rpt:The request could not be submitted for background processing. Does anyone have any idea Thanks Kate Liamero
1
13507
1
by
John Henley
2/14/2006 9:41 PM
For the Love of Chr..t
Started by
Deleted User
We are being told that LAWSON must come out and install Ent. CR on our server. WHY this seems fairly straightforward. &91Note sarcasm with 'straightforward' and Lawson in the same post&93 Is there any exp. of someone who puts ECR on a server box and runs it against Lawson. I'll worry about the security intertwining later {read - next productline build} Thanks...
2
14839
0
by
Deleted User
1/27/2006 3:55 PM
from where i can find activity name
Started by
Deleted User
i am using table mmdist table for details.But as it having only activity code and accounting_category code.,But i also wants activity name and accounting category name also in my report. Inwhich table i canget them and how i can relate them to mmdist
2
14488
1
by
John Henley
12/14/2005 10:45 PM
Lawson Business Intelligence 9.0
Started by
Jason Beard
Has anyone downloaded and installed this yet Does it give the users a friendlier interface for applying 'VTS'. I took the example .jsp/.js files and modified them to use web user attributes to determine which data a user can see in a report, but it would be nice for the end users to administer this similar to the current version of Report Broadcasting. Thanks Jason
0
15924
0
11/18/2005 8:01 PM
To join the discussion you need to
register
first. (Registration is free!) If you are already a registered user please
login
to join the discussion.
Page 34 of 34
<<
<
30
31
32
33
34
General
--Dealing with Lawson / Infor
--SOx Compliance
--Career Development
--Staffing
--Hosting / Cloud
--User Group Announcements
Infor / Lawson Platforms
--Lawson Landmark
--S3 Systems Administration
----S3 Security
--M3 Application Foundation
--M3 Workplace Foundation
--Infor CloudSuite
User Experience
--Lawson Portal
----Lawson Design Studio
--Lawson Smart Office
----Mashup Designer
--Infor Workspace
--Infor Social Space
--Lawson Add-Ins for Microsoft O...
--Mobility
--Lawson Enterprise Search
Integration / Customization
--IPA/ProcessFlow
--Infor ION
--S3 Interfaces/Conversion
--S3 Customization/Development
--S3 Application Upgrades
Human Capital Management
--Lawson S3 HR/Payroll/Benefits
--Infor Global HR (GHR)
Financial Management
--Infor CloudSuite Financials
--Lawson S3 Financials
--Lawson M3 Financials
--Infor FMS
--Lawson Services Automation (PS...
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operat...
--Infor ERP (Syteline)
Supply Chain Management
--Infor SCM
--Lawson S3 Supply Chain
--Lawson M3 Supply Chain
Enterprise Asset Management
--Infor EAM
--M3 Enterprise Asset Management
Performance Management
--Lawson Business Intelligence/R...
----Smart Notification
--Lawson M3 Business Performance...
--Lawson Opportunity Analyzer
Lawson Healthcare
--Cloverleaf
--Lawson MediSuite
--Analytics for Healthcare
Job Fair
--Positions Available
--People Available
LawsonGuru.com
--LawsonGuru.com Support
Forums
Performance Management
Group: Performance Management
Forums
Topics
Replies
Subscribers
Last Post
Smart Notification
189
635
71
RE: SQL Help
by
Greg Moeller
11/9/2023 2:49 PM