I receive a Crystal Reports.xls file each day that contains a list of payments similar to the one shown in the picture below. I would like to loop through the file and append the name of the law firm, payment type and clerk name to the end of each payment record.
The client name and law firm name appear only once at the top of the report as shown in the picture'
The Payment type is either Non-Direct or Direct.
The clerk names can change all the time but they always precede an actual payment record(s)
I have attached a sample file as well. Any assistance appreciated!!