:banghead:
probably a dumb question:
Doing a report but when I pull in the Pay_Rate field from EMPLOYEE table it shows up blank for some exempt people - others I see fine.
I can see them on the HR11 screen. I even tried pulling in the field from PRTIMEHIST table
How can I get this to show up on my report? I need to do a calculation of this field...
:somb: :somb:
A couple of questions first...
1) You are using Crystal against an Oracle database using an odbc or native oracle connection, correct?
2) Run the following query in a query tool (ie TOAD, SQL*Plus, etc):
| CODE |
select count(*)
from [I]schemname[/I].employee
where trim(pay_rate) is null
|
How many results do you get?
I will try this cjmart - thanks you sir.
But, good news is I was able to retrieve the pay data by linking EMPLOYEE >and< PRRATEHIST
Thanks! You rock! :thumb: :thumb: :bow:
You worked it out yourself...you don't need my help on this one.