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
Messages: 5
Registered: February 2002
Junior Member

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!
Re: Multiple Rows for each employee [message #88107 is a reply to message #88105] Thu, 14 March 2002 03:21 Go to previous message
Messages: 46
Registered: March 2001
Hi Danielle,
illustrate me your problem with few examples, please.

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