Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PTO Report (Enterprise)

Status
Not open for further replies.

Theredia01

Technical User
Oct 26, 2006
13
US
I need some help, I have a basic roster report that I need to add PTO balance to. I have the table added, my problem is once I added the pv_al_ytd_cntl_hrs, I only get people who qualify for PTO...how can I get everyone reguardless if they have control hours 1 if I only want to see control hrs 1?

[ponytails]
Tammy
HRIS Analyst

 
You prob have a Selection Critera for control hrs = 1?

If you get rid of the Selection Critera you will get everyone. Then you could do a SQL Derived field to only show the value if control hrs = 1.

Specializing in ReportSmith Training and Consulting
 
Charles,
Thank you, it worked. I hit another wall, if course. My report is pulling in based on process date in order to capture the most recent balance. Some of our employee's don't qualify for PTO so they have nothing on the pv_al_ytd_cntl_hrs table. Is their a magic way to put them in? I know I have to do something with the process date, but not sure what. I already tried the unmatched records on the job table side, no luck...

[ponytails]
 
I think what you need to do is include unmatched records on the job table side AND a Selection Critera List where Any of the following apply. process date is equal what ever you use now and another line where process date is null.

Something like lines 1, 1.1 and 1.2 in the following pic.


Specializing in ReportSmith Training and Consulting
 
Charles,
I have some random people falling off, and I'm not sure why. Do you know if changing tables from PS to PV would effect the data? I did not think it would, I have full access to all the tables, but this is the only thing I can think of.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top