I understand that the employee status history is stored in the HRHISTORY table- it is field 20.  Now the part that I'm having trouble with is getting the status to display that is the one they were BEFORE the one I am running the report for.  Here is my SQL so far-  SELECT 'HRHISTORY'.'EMPLOYEE', 'HRHISTORY'.'FLD_NBR', 'HRHISTORY'.'BEG_DATE', 'HRHISTORY'.'A_VALUE'  FROM   'PRODLAW'.'HRHISTORY' 'HRHISTORY'  WHERE  'HRHISTORY'.'FLD_NBR'=20 AND ('HRHISTORY'.'BEG_DATE'>={ts '2007-01-01 00:00:00'}...

I have a report built from the review table that I post for all the managers to see - so that they know who is coming up due for an appraisal- and it also lists the reviews that have NOT been turned in late.  Unfortunately- since the REVIEW table does not hold the jobcode or department field- I have to link the REVIEW table to the EMPLOYEE table to be able to get the job code and department information.  Does anyone know of a way to make the correct jobcode/department that they are in at the tim...

I need to create a payroll report that pulls current, month to date, QTD, and YTD deduction totals from PAYDEDUCTN, grouped by process level and deduction code.   Ideally, this report would look like this   Process level 100   Deduction   Federal – T000   YTD 1,000,000 QTD 277,777 MTD 80,000 9/21/07 40,000   Process level 200   Deduction   Federal – T000   YTD 2,000,000 QTD 577,777 MTD 180,000 9/21/07 40,000     I am very close to this report using groupings and SUM...

We are currently on LBI 9.0.1.10 and Oracle 9i, we are upgrading to LBI 9.0.2.2 so that i can configure SSL encryption, i am upgrading to Oracle 10g since it is  a requirement. However i have a question about Crystal, we are currently using Crystal XI SP3, but LBI 9.0.2.2 is compatible with Crystal XI R2, i am not familiar with the Crystal  product and would like to know if there are major difference such as run-time performance etc in the new Crystal XIR2 version that will be compatible with 9....

Hello I am running CRX for LRS using SQL Server 2005. I have my a rpt written via an SQL OLEDB connection for speed. I derived a 'date' field through text on PACOMMENTS. I get all four comments lines in CR when I run it locally but only the first line when I run it via Portal on the reporting server. Anyone ever have this issue Any suggestions

In Lawson- it's easy to report on where someone transfers INTO.  But it's another story trying to report on where they transfered FROM.   Does anyone know any easy ways to get this information in a Crystal report

I am trying to clean up one of my personal action reports- and I hoped that someone might have some advice for me on how to do this.  We have action codes and reason codes in our PERSACTHIS table- when someone transfers departments in our organization we do a PA and mark them as ACTION_CODE  = DATACHG and then EITHER REASON_01 = TRANSDEPT OR REASON_02 = TRANSDEPT. When I try to bring in BOTH of those reason codes into ONE crystal report- my results get all messed up.  Currently I have to do tw...

In prepping for our LBI upgrade from 9.0.1.10 to 9.0.2.2, I've identified these issues that we need to address. Without resolving these questions, I can't give The Boss an accurate install estimate. Any help people can give me would be appreciated. I'm hoping that this list of loose ends will help others who are going through this same agony. Issue Issue Description ------- --------------------------------------------------------------- 1 'Apply CTP 48291' That'...

Completely new to Crystal Reporting: The field 'SCHED-DATE' in an Oracle table displays '01-Jan-2008 12:00:00 AM' When i try to run the following formula: {REVIEW.SCHED-DATE} in {Beginning Date} to {Ending Date} Diplays Zero (0) result. And I know for a fact that these records exists. I set up the parameter fields (Beginning Date & Ending Date) to 'Date'. During execution, the only accepted format is 'yyyy-mm-dd'. I've also tried ...

Hi all!! We recently updated to LSF9 technology running on a Sol 10 box. We also have LBI running on 3 windows servers in a distributed formation with Tomcat and Oracle database. Not sure if this was happening before our implementation of DSSO or if it's new, but our LBI dashboards seem to be refreshing themselves every 60 seconds whether you are doing anything with them or not. This is causing very high CPU utilization on our LSF9 box (4 SPARC CPU's and 32 GB RAM) 95 and...

Our company is planning LSF9 and LBI implementations. Our company standard is Webspehere on AIX but it seems LBI needs Websphere on Windows. We are trying to understand the real reason behind it. Why can't LBI work with Websphere on AIX. Any insight is much appreciated. Thanks Sreeni

Let me start out by saying that I'm not a Lawson wiz. I'm merely a user who, after having IE 7.0 loaded on my pc, can't run Enterprise Reporting. I have Windows XP. I believe we use crystal reporting. My LDS group here at my company wants to completely reimage my PC which is so painful. Here's the error I get when I try to access Enterprise Reporting: 'Error, unable to load Enterprise Reporting script (/epm/reporting.js). Enterprise Reporting has not been properly initialized...

Hello Crystal XI and SQL Server 2000 I've created a linked subreport, so that the main report can collect two parameters, company group and fiscal year, from lists rather than the user typing them in. The linked subreport picks up these two parameters and then collects another three. This works a treat in Crystal and means I get the best of both worlds - server-side filtering and parameters from picklists. However, when I publish the report and attempt to run it, I get two parame...

Has anyone seen this error. I am having troubles creating an instance on a report and keep getting this error. The string is non-numeric. Details: errorKind The string is non-numeric. Error in File E:\TEMP\{59CDEF6F-DD88-407B-B733-9378F9645DC3}.rpt: Error in formula . 'tonumber({Convert Date to Period})' The string is non-numeric. Details: errorKind Unable to retrieve Object. The string is non-numeric. Details: errorKind The string is non-numeric. Error in File E:\TEMP\{59CD...

Lawson has told one of my clients that you can't deploy and run 100 or so Crystal Reports written via OLEDB throughout an organization and that all reports should be rewritten via ODBC. Has anyone heard of this All prompts (dynamic and static) don't work and Lawson claims that OLEDB is not meant to be used for such a large number of reports. Obviously, this is nowhere in the support site documentation. Thoughts Thanks.

I'm looking for a reference that uses or has used both MRS and LRS/LBI. Specifically, I would like to understand how these products compliment each other, what each can do that the other cannot and where the overlap is. We're currently at V 8.03 of Env and Apps and just started to use MRS for some non Lawson reporting. We will be installing LRS 9 after we get on LSF 9 and will need to make a decision on which tool would be best to rewrite our legacy Lawson and non Lawson reports with. Thanks.

I have installed the Distributed Single Sign On jar files on my LBI server. I have run the config assitant and install validator and the smoke test and everything checks out. When I try and log into efs I get the login/pw box. I enter my log in password and then I get a blue screen saying 'I don't know this came from a trusted site'. My tomcat logs on the the LBI server show nothing and neither to my webshpere logs on the server. Any help would be greatly appreciated.

Is anyone familiar with bursting Lawson backoffice reports that orginate on an iSeries Has anyone added XML tags to custom reports then bursted in Reporting Services

John, We use crystal XI against an oracle 10g database to publish reports to LBI Dashboards, and I am SQL impaired. I guess if I have to teach myself some basics I should be looking at an Oracle based SQL. Do you have any suggestions Any good book Ideas I know some of the reports can take forever to run. Thanks Kate

Hi! i would like to ask anyone who have worked with RS to may be help me understand RS Events. Specifically Parameter Selection. I have read the documentation but i'm still lost. Is there anyone out there who has sample, or have worked with RS Events.. I would really appreciate it you guys could enlighten me about this... Thank you..

Thanks in advance for any clues! I am from scratch (not DME due to using ODBC) writing a query in Crystal Reports. Below I have 2 tables (Employee & PRDISTRIB). What this is to report is payroll deductions by deduction. So within PRDISTRIB (and there might be a better Lawson table) I have a record for each single deduction (e.g. Check 502 for Mary Brown will have maybe 6 records or more, $10 Dental, $25 Health, $5 Uniform, etc.). So with this query and my corresponding report I get the e...

I have a query below that is erroring that the 'FROM' is not in the correct place... any clues.... Thanks! SELECT EMPLOYEE.EMPLOYEE, EMPLOYEE.FICA_NBR, EMPLOYEE.LAST_NAME, EMPLOYEE.ADDR1, EMPLOYEE.CITY, EMPLOYEE.ADDR2, EMPLOYEE.DEPARTMENT, EMPLOYEE.TERM_DATE, substr(DEPARTMENT,4,2), EMPLOYEE.ZIP, trim(employee.city) || ', ' || trim(employee.state) || ' ' || trim(employee.zip) as city_st_zip...

HRHISTORY: There are 1,400,000 records in this table and CRXI via OLEDB command is taking forever. Date parameters haven't helped too much. I would suspect that the ODBC route would be much easier but Lawson's told me that the dynamic/cascading prompts are only failsafe with OLEDB. Any suggestions here Thanks.

I am trying to split a number into two parts and wondering if anyone has a suggested syntax (e.g. 107511 split into 107 and 511 and then alias each with the 'AS' keyword.) Thanks! Chris Martin posted this when I was trying two join 3 fields into one (I'm kinda doing the reverse now): trim(last_name) || ', ' || trim(first_name) || ' ' || case when trim(middle_init) is null then trim(middle_init) else trim(middle_init) || '.' end

I've used Chris' method to join First M. Last Names together (trim(last_name) || ', ' || trim(first_name) || ' ' || case when trim(middle_init) is null then trim(middle_init) else trim(middle_init) || '.' end) and was wondering if the same would work to join 'City, State Zip' and keep the single spaces in. Thanks!