Hello
I am new to this form and to crystal reports. I am trying to run a report on an Excel spreadsheet with about 53000 rows.
Column A is Customer ID
Column d is Procedure code.
Each row contains an individual visit with the Customer Id and type of Procedure(PP SP TP DP TD)
The customers may have had different procedures on different vists.
I would like to show only customers who only have done the (SP) procedure and no other procedures are listed for that Customer Id.
I am hoping someone can steer me in the right direction on this.
Thanks for any help.
Mike