I am using CR XI
Trying to use only the record with the maximum date in running totals and grouping when more than on date exists for that entry.
For Example:
GP1 (ID)
ID Date Transferred
PPQ 01/02/2011
PPQ 03/01/2011
PPQ 05/03/2011
I need to further group by month which changes my totals.
GP 1 Jan 2011
GP 2 (ID)
ID Date Transferred
PPQ 01/02/2011
GP 1 March 2011
GP 2 (ID)
PPQ 03/01/2011
GP 1 May 2011
GP 2 (ID)
ID Date Transferred
PPQ 05/03/2011
I only want the entry for May 2011 to show in the report and in totals.
GP 1 Jan 2011
GP 2 (ID)
ID Date Transferred
GP 1 March 2011
GP 2 (ID)
ID Date Transferred
GP 1 May 2011
GP 2 (ID)
ID Date Transferred
PPQ 05/03/2011
Any help would be greatly appreciated.
Trying to use only the record with the maximum date in running totals and grouping when more than on date exists for that entry.
For Example:
GP1 (ID)
ID Date Transferred
PPQ 01/02/2011
PPQ 03/01/2011
PPQ 05/03/2011
I need to further group by month which changes my totals.
GP 1 Jan 2011
GP 2 (ID)
ID Date Transferred
PPQ 01/02/2011
GP 1 March 2011
GP 2 (ID)
PPQ 03/01/2011
GP 1 May 2011
GP 2 (ID)
ID Date Transferred
PPQ 05/03/2011
I only want the entry for May 2011 to show in the report and in totals.
GP 1 Jan 2011
GP 2 (ID)
ID Date Transferred
GP 1 March 2011
GP 2 (ID)
ID Date Transferred
GP 1 May 2011
GP 2 (ID)
ID Date Transferred
PPQ 05/03/2011
Any help would be greatly appreciated.