Crystal XI - Counter on Group 2

[marisam]

I've been trying to work this problem but my counter keeps coming out wrong. I hope someone can help me.

I have data where I must obtain the earliest grant date in the application group of each employee. Then I must create a running total so that the earliest grant date for each employee is labeled #1, #2, #3 etc.


App No. Div Ctry Grant Date Grant # Name
APP01 US 15-Nov-05 6965726 SMITH FRAN
APP02 US 20-Sep-05 6948185 SMITH FRAN
APP03 US 31-Oct-06 7130526 SMITH FRAN
APP04 US 23-Nov-04 6823131 SMITH FRAN
APP05 GB 8-Sep-04 1222822 SMITH FRAN
APP06 GB 16-Jul-03 1222824 SMITH FRAN
APP07 1 GB 5-Jan-05 1158796 SMITH FRAN
APP33 GB 13-Dec-06 1372340 BAYER SAM
APP33 US 4-Sep-01 6285413 BAYER SAM
APP33 1 GB 21-Apr-04 963112 BAYER SAM
APP15 GB 3-Jan-07 1642413 BAYER SAM
APP14 GB 3-May-06 1557025 BAYER SAM
APP17 GB 8-Mar-06 1169831 BAYER SAM
APP12 GB 23-Nov-05 1069770 AND KIM
APP12 US 28-Jun-05 6911986 AND KIM
APP20 GB 5-Jul-06 1154642 AND KIM
APP10 GB 9-Nov-05 1154643 AND KIM
APP10 US 15-Jun-04 6750918 AND KIM
APP21 GB 15-Feb-06 1372181 HUNT ENZO
APP22 US 15-Aug-06 7091655 HUNT ENZO
APP23 US 31-May-05 6900583 HUNT ENZO


So each employee I must find the earliest grant date for each application and then place a counter on the grant date.

Desired Results
Name App No. Div Ctry Grant # Grant Date Count Count
BAYER APP33 US 6285413 4-Sep-01 1
BAYER APP17 GB 1169831 8-Mar-06 2
BAYER APP14 GB 1557025 3-May-06 3
BAYER APP15 GB 1642413 3-Jan-07 4


Name App No. Div Ctry Grant # Grant Date Count
SMITH APP06 GB 1222824 16-Jul-03 1
SMITH APP05 GB 1222822 8-Sep-04 2
SMITH APP04 US 6823131 23-Nov-04 3
SMITH APP07 1 GB 1158796 5-Jan-05 4
SMITH APP02 US 6948185 20-Sep-05 5
SMITH APP01 US 6965726 15-Nov-05 6
SMITH APP03 US 7130526 31-Oct-06 7

Cheers and Thanks so much

 

[synapsevampire]

Group by the name, and then sort by the date.

Place a Running Total which resets at the name group, and have it count any field.

-k

 

[lbass]

You will need to group by name and then by App No. Sort by date ascending and drag the fields into a group footer section and suppress the details. Then insert the running total that is a distinctcount of app Id and resets on change of name.

-LB

 

[marisam]

Synapsevampire and Lbass your suggestions worked! Thanks!!!