flynn60
asked on
show date for last time field was updated
I am creating a Crystal Report in Version 10. I have a table with employee information and a sample looks as follows:
Emp ID Class Rate Effective Date
100 acct 20.00 10/01/2010
100 acct 22.00 3/01/2011
100 acct 21.75 6/1/2011
100 hr 21.75 8/1/2011
I need to show a summary line that shows current class and pay rate and the date for the last pay rate change. (not the last date record changed)
For example:
Emp ID Class Rate Date of Last Rate Change
100 hr 21.75 6/1/2011
By grouping by employee ID and sorting by date and using max, I can get the current class and rate, but I cannot get the date for the rate change. Unfortunately sorting by rate won't work because the change in rate is not always an increase.
Ideas?
Emp ID Class Rate Effective Date
100 acct 20.00 10/01/2010
100 acct 22.00 3/01/2011
100 acct 21.75 6/1/2011
100 hr 21.75 8/1/2011
I need to show a summary line that shows current class and pay rate and the date for the last pay rate change. (not the last date record changed)
For example:
Emp ID Class Rate Date of Last Rate Change
100 hr 21.75 6/1/2011
By grouping by employee ID and sorting by date and using max, I can get the current class and rate, but I cannot get the date for the rate change. Unfortunately sorting by rate won't work because the change in rate is not always an increase.
Ideas?
ASKER
This has the same result as sorting ascending and putting info in footer. You get the last date on the record and not the date where the data changed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! It worked perfectly.
Sort by date (Descending)
Put the information in the group header
mlmcc