Presume you mean via sql? Manager is obtained via table per_assignment_supervisors_f. Smple query below for an Emps manager If you want the manager's manager - you just need to add the relevent table…

Hello- can you not get all that info from the one "Assignment real time" subject area? (You should try and just use one if possible -avoids aditional joins which could maybe then result in …

Can't you just add a filter : Assignment Status = Active - Payroll Eligible then will just pick the current record and not the previous one that is now inactive?

Yep mandeeps solution works. Can also use a subquery to achive the same: Create a report whch will be used as a subquery report which returns the person number and max(assignment number). - so that w…

So you want to enter an account value in a prompt and then return whatever segment it is in? If so this should work : Create a prompt and under prompt options - set a presentation variable eg AC_VAR.…