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.

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

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'.'...

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.

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

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...

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

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...

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...

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...

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...

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!

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) ...

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...

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.

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...

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 ...

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

We are being told that LAWSON must come out and install Ent. CR on our server. WHY this seems fairly straightforward. [Note sarcasm with 'straightforward' and Lawson in the same post] 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...

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

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