• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Department Transfer Report

Hi,

I'm trying to create a report that shows employees who transfered from one department to another.  I have only one difficulty though. I want to show their current department and their previous department. How can I show the previous department?
There is a position history table that shows all the departments that an employee has been to. So basically the last entry in that table shows the current department ,and the entry before the last shows the previous department. How can I show the entry before the last in my report?

Thanks
0
cadkins
Asked:
cadkins
  • 2
  • 2
1 Solution
 
peter57rCommented:
I assume the records have a PersonID and an appointment date in each record?
0
 
cadkinsAuthor Commented:
Yes they do
0
 
peter57rCommented:
OK.
Create a group based on the ID.  Sort the records into descending date sequence within the group.
Add a Running total field to the detail line. The running total should be a Count of the id field, evaluated for each record and reset on change of group.
Use a conditional suppression on the detail line:

{Rtotal0}>2

You can suppress the group headers and footers if you want.
0
 
cadkinsAuthor Commented:
Thanks!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now