Hello.. This is more a Crystal question than Sage but I thought what the heck maybe someone out there has a quick answer. 

So I'm trying to add the Invoice # field to the report however when I add Inv# from the AR_InvoiceHistoryHeader table the report will print out every invoice in table for each Transaction #. So instead of printing the exact invoice for each transaction for a particular date it will print the all them for each transaction. The report ends up being 25K long. 

Maybe wrong table??  I have try a couple others but can't seem get the right one if its a table issue at all.  S/O is the link between AR_InvoiceHistoryHeader and AR_CreditCardSettlement.wrk