How do I capture data with mixed criteria and effective dates?

[deborahyr]

How do I capture first effective date of Job Title and current Organization while in that Job Title?

Data Rows =
Start Date Job Title Organization
01/2009 Consultant-AP Org 5
01/2008 Consultant-XX Org 5
11/2007 Consultant-XX Org 5
6/2007 Consultant-XX Org 3
01/2006 Consultant-CC Org 2

Want displayed only:
01/2009 Consultant-AP Org 5
6/2007 Consultant-XX Org 5
01/2006 Consultant-CC Org 2

Crystal Reports XI

 

[CoSpringsGuy]

whups /.....


Place the **Job title** field from the database and the two running totals in the footer. hide details and hide group header


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

I'm sorry, I lost track of what you wanted to do. Use my original approach, and group by job title and sort by date descending, and use the earlier formulas to get the org. Then insert a maximum on date at the job title group level, and go to report->group sort and choose maximum of date as your group sort field.

-LB

 

[deborahyr]

lbass, you are the greatest! It works!!! Thank you so so much!