Select ONLY first matched record for Mailing Labels

[MJRBIM]

CR 8.5 Pro, MS SQL 2000 Database via ODBC

I'm creating a Mailing Label (Avery 5161) using the built-in template in CR 8.5

The labels are run against three tables CustomerAccount, CustomerAddress, and JournalHistory - and select based on purchases in the Customer's JournalHistory.

A customer may make multiple purchases of the same product, so I get multiple labels in the DETAIL section for each customer - one per purchase.

Normally, I would Group by CustomerID and have the label only print ONCE at the Group Footer...but I don't seem to be able to do that when I'm using this template. I don't have the "Format Groups with Multiple Colums" option on the LAYOUT tab.

I'm guessing that I will have to apply a different RECORD SELECTION to ONLY return the First TransactionID/ SequenceNumber from JournalHistory for each MemberID.

Any assistance on the Crystal syntax for this would be appreciated.

Thanks in advance....

 

[MJRBIM]

Solved it using a Shared Number Var to do a record count per CustomerID...and supressing DETAIL where Counter > 1