Home » Developer & Programmer » Reports & Discoverer » Multiple Rows for each employee
Multiple Rows for each employee [message #88105] Wed, 13 March 2002 08:35 Go to next message
Danielle
Messages: 5
Registered: February 2002
Junior Member
Hi

I have recently started at a company and am trying to fix the headcount report. It is pulling mulitple rows for each person which reports on each change made in the employee's oracle file. I have managed to TRUNC(sysdate) any changes in the People and Assignment screen as both of those have effective from and to dates. However, there is a field that reports Parent Organization and it does not appear to have an effective from and to date. Does anyone know what the command is to pull only the most recent Parent Organization?

Thank you!
Danielle
Re: Multiple Rows for each employee [message #88107 is a reply to message #88105] Thu, 14 March 2002 03:21 Go to previous message
marco
Messages: 46
Registered: March 2001
Member
Hi Danielle,
illustrate me your problem with few examples, please.

Cheers,
Marco
Previous Topic: Re: Producing oralce Reports in Excel
Next Topic: Re: printing reports usings forms 6i on web
Goto Forum:
  


Current Time: Fri May 17 23:47:57 CDT 2024