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:
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 5 of 5 << < 12345
 Last Post
5 Replies and 11357 Views general reporting question  11357  5 Started by  Phil Simon I really enjoyed the series on reporting. Let me make sure that I understand XI's limitations with Lawson's OLEDB connector. While you get the benefit of security, you have the disadvantage of reporting on only 'Lawson-approved' relationships). As a result, more complex reports aren't possible without some creativity. You wrote about the benefits of doing Crystal Reports based on SQL queries. For this to work through Crystal Enterprise for light users (i.e., not hard core developers on t...
5 11357
by  Phil SimonJump to last post
07/12/2007 2:36 PM
3 Replies and 10802 Views Crystal and Lawson  10802  3 Started by  Deleted User We are currently using version 8.0.3 Applications, 8.0.29 Environment and Crystal Enterprise 8.5. We will be upgrading soon and I am trying to find out if anyone knows what versons of Crystal are compatible with the Lawson 8.0.3 Environment. We will be moving to the Lawson 8.0.3 environment later this summer, with a move to 9.0.0 sometime next year. So that is two Environment upgrades and I am only looking to make one upgrade of Crystal to the highest version available that is compatible with...
3 10802
by  John HenleyJump to last post
05/24/2007 12:18 PM
0 Replies and 11072 Views Framework and LRS Validation Problems  11072  0 Started by  Larry Taylor I installed Framework Services 1.2 and the install validator passes all tests with flying colors. Next, I installed Reporting Services, ran the install validation process and again, every passes with flying colors. I've Registered Reporting Services/Framework Services, and again, no problems. I can publish any type of report that I want and during the publication process, the report loads and displays just fine. The problem that I am experiencing is that when I mount a published report on a dash...
0 11072
05/11/2007 1:07 PM
0 Replies and 10852 Views Mandatory Education Reports  10852  0 Started by  Deleted User Lawson 8.03 I wrote a report using PATRNHIST, EMPLOYEE to capture the Employee Training/Course history. There are a few Mandatory Courses that encompass several Course Numbers - For example: BLS Course is select {PATRNHIST.COURSE} case '2C00000001': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/yyyy') Case '2C00000002': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/yyyy') case'2C00000003': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/y...
0 10852
03/21/2007 11:13 AM
7 Replies and 12877 Views LBI/LRS and Crystal Report using ODBC Driver  12877  7 Started by  Kate Liamero We have crystal reports designed using data direct ODBC driver to oracle database 10G. The datasource that we are using to design the reports are also setup on our LBI/LRS servers exactly the same way. We have PROD TEST and DEV environments. PROD and TEST are remote installs with the db, apps and lbi/lrs residing on 3 different servers. DEV is all on one box. DB and APP boxes are Unix/Sun. LBI/LRS Windows Version 9 for everything. We are saving the login information with the ...
7 12877
by  John HenleyJump to last post
03/12/2007 7:53 PM
1 Replies and 10822 Views Limit access to reports  10822  1 Started by  Deleted User Is there a way to control access to reports I create. People use them and throw off my formatting. I would also like to limit access to certain acct groups. Thanks Nigel
1 10822
by  John HenleyJump to last post
03/01/2007 12:40 PM
2 Replies and 11345 Views Repository in LBI/LRS Version9  11345  2 Started by  Kate Liamero I know there was no repository in LRS1.3 is there one in the 9.0 version. We want to have a central place to store formulas, logos etc. I know it exists in Crystal Enterprise but is there such a thing in the new LBI/LRS 9.0 or are the still only using RAS Thanks Kate Liamero
2 11345
by  John HenleyJump to last post
02/11/2007 8:34 PM
1 Replies and 11589 Views Looking for Seurity Tables  11589  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 11589
by  John HenleyJump to last post
02/08/2007 4:37 PM
27 Replies and 16862 Views lsDrillAround Syntax  16862  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 16862
by  Bob BeverleyJump to last post
01/25/2007 9:27 AM
2 Replies and 11063 Views ACTRANSREL.mx_value_3  11063  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 11063
by  Deleted UserJump to last post
01/19/2007 7:51 AM
1 Replies and 11007 Views Employee record & Change Notice  11007  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 11007
by  John HenleyJump to last post
12/20/2006 6:42 PM
1 Replies and 11173 Views Years of Service  11173  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 11173
by  John HenleyJump to last post
09/29/2006 12:10 PM
2 Replies and 11551 Views COBRA - Outsourcing report  11551  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 11551
by  Shane JonesJump to last post
09/28/2006 11:50 AM
1 Replies and 11599 Views XTRA: parameters  11599  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 11599
by  Matthew NyeJump to last post
09/27/2006 4:25 PM
4 Replies and 11330 Views Training requirements  11330  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 11330
by  Deleted UserJump to last post
09/22/2006 12:47 PM
1 Replies and 11973 Views BOE XI FTP's in binary instead of ASCII  11973  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 11973
by  JesseJump to last post
08/30/2006 12:02 PM
4 Replies and 12394 Views ..custom report/parameter pages in LBI 9..  12394  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 12394
by  JesseJump to last post
08/30/2006 10:06 AM
3 Replies and 11269 Views Formula Field  11269  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 11269
by  John HenleyJump to last post
08/17/2006 2:54 PM
2 Replies and 11831 Views LBI Configuration  11831  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 11831
by  Deleted UserJump to last post
08/15/2006 9:44 AM
5 Replies and 11717 Views Printing just summary from Crystal  11717  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 11717
by  Matthew NyeJump to last post
08/14/2006 3:34 PM
3 Replies and 11339 Views Command in Crystal  11339  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 11339
by  John HenleyJump to last post
08/10/2006 11:04 AM
5 Replies and 12216 Views Pasting Query to Add Command  12216  5 Started by  Deleted User I tried adding this command: SELECT '', '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 12216
by  Deleted UserJump to last post
08/02/2006 9:11 AM
6 Replies and 18145 Views Report for Lawson HR User Fields/Field Codes (PADICT)  18145  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 18145
by  John HenleyJump to last post
07/19/2006 9:32 AM
1 Replies and 12147 Views Multiple Data Sources for report  12147  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 12147
by  John HenleyJump to last post
07/16/2006 8:27 PM
1 Replies and 11734 Views Reporting environment question  11734  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 11734
by  Chris MartinJump to last post
07/08/2006 4:53 PM
1 Replies and 11669 Views Lawson LRS Server Can't see instance of report  11669  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: 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 11669
by  John HenleyJump to last post
02/14/2006 4:41 PM
2 Replies and 12587 Views For the Love of Chr..t  12587  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 12587
by  Deleted UserJump to last post
01/27/2006 10:55 AM
2 Replies and 12516 Views from where i can find activity name  12516  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 12516
by  John HenleyJump to last post
12/14/2005 5:45 PM
0 Replies and 13107 Views Lawson Business Intelligence 9.0  13107  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 13107
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 5 of 5 << < 12345

RSS Feed Available