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.
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'...
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.
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.