selectively extracting data from multiple entries

[smmedeiros]

Looking for guidance. I have an issue similiar to posting thread181-27567 - which did not offer a solution.


I have 3 variables

Act.log.type
Act.log.date
Chg.number

Sample data:
234123 Closed 10/01/09 17:01
234123 Resolved 10/01/09 15:45
542314 Resolved 09/28/08 16:45
433671 Closed 10/03/09 15:00
454356 Closed 09/27/09 16:45
454356 Resolved 09/25/09 08:05


My desired output would be:
234123 Resolved 10/01/09 15:45
542314 Resolved 09/28/08 16:45
433671 Closed 10/03/09 15:00
454356 Resolved 09/25/09 08:05


If based on the chg.number, I have both a ‘closed’ and ‘resolved’ entry, I want to pick up only the value for the ‘resolved’ If I have only a ‘closed’, then I want to take that value.

Any advice how to read through this and report back?

 

[CoSpringsGuy]

try grouping your data on chg.number.

sort your records by log type ascending

put the fields you want to show in your report in the group footer. hide details and group header

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