Using CRXI and a SQL2K8 db.
This seems pretty simple, but for the life of me, I can't figure it out - searched the forum so if I missed the answer, I apologize for the clutter.
Trying to return and summarize 1 record per group.
3 fields: App#, ActivityDate, Operator
For each App# there are multiple instances of ActivityDate & Operator, but I would like the report to return only the first (minimum) date and operator. Need to be able to summarize (count) instances.
Results should look like this:
Smith,John
App1 10-01-2009
App4 10-02-2009
Total: 2
If Jones,Keith also worked on App1 on 11-15-2010, this record would not be included in the report.
Thanks in advance for the help!!
This seems pretty simple, but for the life of me, I can't figure it out - searched the forum so if I missed the answer, I apologize for the clutter.
Trying to return and summarize 1 record per group.
3 fields: App#, ActivityDate, Operator
For each App# there are multiple instances of ActivityDate & Operator, but I would like the report to return only the first (minimum) date and operator. Need to be able to summarize (count) instances.
Results should look like this:
Smith,John
App1 10-01-2009
App4 10-02-2009
Total: 2
If Jones,Keith also worked on App1 on 11-15-2010, this record would not be included in the report.
Thanks in advance for the help!!