Recent content by abowling

When I take everything off except the effdt line, it pulls a lot of records (pulling one for each type of phone, home/work, etc) So I added the 1 line to select "HOME" but didn't do anything with the status on the job table. Still dropping off 74 emps.

It's still dropping 87 employees. When I run the report with the Telephone_Nbr table alone, and then manually pull it into another spreadsheet via vlookup, it works. But when I add the job table, and exclude anyone with a "T" status, it drops them off. Very strange.

The issue seems to be when it is linked to the job and/or personal_data tables. When I removed all tables, it pulled all employees. Just not sure where to start.

Oh yes, I was trying anything/everything. I actaully did it on the correct link/table but when that didn't work, I tried the other one, just for fun. still no luck either way.

SELECT "PS_JOB"."FILE_NBR", "PS_PERSONAL_DATA"."CITY", "PS_PERSONAL_DATA"."STATE", "PS_PERSONAL_DATA"."STREET1", "PS_PERSONAL_DATA"."STREET2", "PS_PERSONAL_DATA"."ZIP", "PS_TELEPHONE_NBR"."PHONE" FROM "PS_JOB", "PS_PERSONAL_DATA", "PS_TELEPHONE_NBR" WHERE (((("PS_JOB"."EFFSEQ"= ( SELECT...

I tried an "any" list where PHONE is equal to HOME or null, but no luck.

Oddly enough, it's not effective dated. Should I still try the list option?

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

Nevermind - I just figured it out. It was conflicting with another Derived Field I had in the report.

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

Thanks for the answer, however I need to export it to excel, and when I try to do this while checking the "retain formatting" box to download only the totals, it bombs out my Reportsmith. I know there is a derived field that will do this, I'm just not sure what it is.

Dept_Tbl.Manager_ID

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

Thank you, I was making it more difficult than it needed to be!

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.