PTO Report (Enterprise)

[Theredia01]

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?


Tammy
HRIS Analyst

 

[CharlesCook]

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.

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[Theredia01]

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

 

[CharlesCook]

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.

http://charlescook.com/images/Examples/SelectionCriteraNoHours.png

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[Theredia01]

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.

 

[CharlesCook]

going from PS to PV can do it. The PV tables have some security built into them. It could also be bad links and/or bad effictive date keys.

Here is a PPT for Effective Dated tables:

http://charlescook.com/PPS/ADP/ReportSmith/Enterprise/Introduction-To-Effective-Dated-Tables.pps

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting