Search results for query: *

Hello, I am trying to include the Home Phone in a simple report; however when I used the Telephone_Nbr table, there are approximately 125 employees dropping off. I assume these are employees who do not have a telephone number entered. I tried checking the "include unmatched records" box in...

Hello, I am receiving the following error: ORA00923 Keyword FROM not found where expected. Here is my derived field: DECODE("PS_LOCATION_TBL"."LOCATION", 'REMOT' ,'Other U.S. Location', 'AZTEM', 'Tempe', 'CAIRV', 'Irvine', 'CASF', 'San Francisco', 'FLSUN', 'Sunrise', 'LANO', 'New Orleans'...

Hello, I know this question has been asked several times, but I was unable to find the answer. I am on Reportsmith, Oracle. I have a report that has several different earnings codes; therefore pulling multiple rows per employee. I have created separate derived fields for each earning code...

I have a report that has zipcodes listed as follows: 75201 75201-1111 75201-1234 752011234 752011111 I need for all to be consistent(without dashes) as follows: 752010000 752011111 752011234 752011234 752011111 Any help would be greatly appreciated.

I have a derived field to calculate the hourly rates for a group of employees who are paid semi-monthly. This derived field looks like this: 10.00 12.23 16.50 8.82 etc... I need to format it to look like this: 000000001000 000000001223 000000001650 000000000882 Is there a derived field...

Hello, I am using Reportsmith Version 3.10 I need a derived field to do the following: Look at the termination date field. If it is less than the hire date then make the field null or ' ' else, list the term date. I have tried several things like below but can't get anything to work. CASE...

I am needing a derived field to do the following: If Termination Date < 01-JUN0-2005, then make term date null, otherwise, list the term date any suggestions?

What is wrong with this derived field? I keep getting 'missing right parenthesis': SUM("CASE TABLE_NAME.DED_CODE" WHEN 'TRC' THEN "TABLE_NAME_AMOUNT" ELSE 0 END)

I need a derived field to change the SSN from 123-45-6789 to XXX-XX-6789 Any help would be greatly appreciated.

Hello, I have created a master-detail report (benefits statement); however I am having problems with the formatting. The master report consists of the employee information, address, ss#, etc. Then there is a Health, Life, Disability, FSA, and Dependent section (each its own detail report)...

Hello, I need a derived field to calculate the # of Remaining checks for our employees who are paid Monthly. I can figure this out easily in my head, however I need to have a derived field in my report to calculate some other items. 52 # of checks in a year 12 # of checks they are paid in a...

Hello, I need some help with a derived field. I have a report I am working on for FSA benefit contributions, and determining if employees are going to meet or exceed their annual pledge amounts. I included pay frequency (weekly, monthly, semi-monthly and bi-weekly) Based on the pay...

I have a list of employee annual salary rates. I would like to return a value (ie A, B, C etc) when the annual salary rate falls within a salary range. Here is what I tried: CASE "PS_EMPLOYEES"."ANNUAL_RT" WHEN '>22359 AND <28080 THEN 'A' WHEN '>28079 AND <35360 THEN 'B' ELSE 'NONE' END I...