Forums
 Topics
 Replies
 Last Post
180 Topics and 623 Replies Smart Notification  180  623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
180 623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
Search this forum:
Search
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 9 of 9 << < 56789
Topics
 Replies
 Views
 Last Post
1 Replies and 11432 Views Looking for Seurity Tables  11432  1 Started by  Deleted User I need to write a report against the security tables, but I can't seem to find the names/locations of the security tables. I am very new to Lawson (and Crystal), so I hope that this isn't a stupid question. Specifically, I need to compare security class against the employee's RD30 record, which I've found on DBLOWUR. We're running an I-Series/AS400 on the back-end if that makes any difference. Thanks in advance for your help.
1 11432
by  John HenleyJump to last post
02/08/2007 4:37 PM
27 Replies and 16696 Views lsDrillAround Syntax  16696  27 Started by  Bob Beverley 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 16696
by  Bob BeverleyJump to last post
01/25/2007 9:27 AM
2 Replies and 10976 Views ACTRANSREL.mx_value_3  10976  2 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 10976
by  Deleted UserJump to last post
01/19/2007 7:51 AM
1 Replies and 10887 Views Employee record & Change Notice  10887  1 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 10887
by  John HenleyJump to last post
12/20/2006 6:42 PM
1 Replies and 10998 Views Years of Service  10998  1 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 10998
by  John HenleyJump to last post
09/29/2006 12:10 PM
2 Replies and 11454 Views COBRA - Outsourcing report  11454  2 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 11454
by  Shane JonesJump to last post
09/28/2006 11:50 AM
1 Replies and 11497 Views XTRA: parameters  11497  1 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 11497
by  Matthew NyeJump to last post
09/27/2006 4:25 PM
4 Replies and 11227 Views Training requirements  11227  4 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 11227
by  Deleted UserJump to last post
09/22/2006 12:47 PM
1 Replies and 11874 Views BOE XI FTP's in binary instead of ASCII  11874  1 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 11874
by  JesseJump to last post
08/30/2006 12:02 PM
4 Replies and 12284 Views ..custom report/parameter pages in LBI 9..  12284  4 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 12284
by  JesseJump to last post
08/30/2006 10:06 AM
3 Replies and 11141 Views Formula Field  11141  3 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 11141
by  John HenleyJump to last post
08/17/2006 2:54 PM
2 Replies and 11683 Views LBI Configuration  11683  2 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 11683
by  Deleted UserJump to last post
08/15/2006 9:44 AM
5 Replies and 11555 Views Printing just summary from Crystal  11555  5 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 11555
by  Matthew NyeJump to last post
08/14/2006 3:34 PM
3 Replies and 11249 Views Command in Crystal  11249  3 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 11249
by  John HenleyJump to last post
08/10/2006 11:04 AM
5 Replies and 12057 Views Pasting Query to Add Command  12057  5 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 12057
by  Deleted UserJump to last post
08/02/2006 9:11 AM
6 Replies and 17659 Views Report for Lawson HR User Fields/Field Codes (PADICT)  17659  6 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 17659
by  John HenleyJump to last post
07/19/2006 9:32 AM
1 Replies and 12028 Views Multiple Data Sources for report  12028  1 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 12028
by  John HenleyJump to last post
07/16/2006 8:27 PM
1 Replies and 11653 Views Reporting environment question  11653  1 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 11653
by  Chris MartinJump to last post
07/08/2006 4:53 PM
1 Replies and 11563 Views Lawson LRS Server Can't see instance of report  11563  1 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 11563
by  John HenleyJump to last post
02/14/2006 4:41 PM
2 Replies and 12442 Views For the Love of Chr..t  12442  2 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 12442
by  Deleted UserJump to last post
01/27/2006 10:55 AM
2 Replies and 12388 Views from where i can find activity name  12388  2 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 12388
by  John HenleyJump to last post
12/14/2005 5:45 PM
0 Replies and 12937 Views Lawson Business Intelligence 9.0  12937  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 12937
11/18/2005 3: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 9 of 9 << < 56789


RSS Feed Available