Department Transfer Report

Posted on 2007-08-09
Last Modified: 2011-10-03

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?

Question by:cadkins
    LVL 77

    Expert Comment

    I assume the records have a PersonID and an appointment date in each record?

    Author Comment

    Yes they do
    LVL 77

    Accepted Solution

    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:


    You can suppress the group headers and footers if you want.

    Author Comment


    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now