×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Control Hours Report

Control Hours Report

Control Hours Report

(OP)
Good afternood;
I have a report bulit to give me Ctrl Hrs 1, currently I have to type in the Process effective date.  I would like to automate this process to pull in the Max process effdt.  Does anyone know how to do this?

-Enterprise V3.
Table I'm using is:
PS_AL_YTD_CNTL_HRS.AL_PROCESS_EFFDT

-Thank you ponytails

RE: Control Hours Report

In your select criteria, you will need to write a MAX statement.  I am making two assumptions in the following, that your table alias is CNTL_HRS, and that your key field is EMPL ID

FollOw this:
Data Field CNTL_HRS.AL_PROCESS_EFFDT is equal to formula:

(SELECT MAX (AL_PROCESS_EFFDT) FROM
PS_AL_YTD_CNTL_HRS A WHERE
CNTL_HRS.EMPLID=A.EMPLID)

RE: Control Hours Report

(OP)
The control hrs table does not contain emplid. I changed to File_nbr, but am getting a missing expression message.  Any suggestions?
I would paste a copy of my selection, but not sure how to do that.  ponder

RE: Control Hours Report

(OP)
Wait, I got it.  But its only pulling the Max for the pay group just processed.  I'm thinking I need to add an any statement to get the max of all paygroups???

FYI-
This is how I got it it work
(SELECT MAX (AL_PROCESS_EFFDT) FROM
SYSADM.PS_AL_YTD_CNTL_HRS A WHERE
FILE_NBR=A.FILE_NBR)

Were on Oracle.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close