I have looked at all of the above. In the transaction payment history it gives you information from both check history and invoice history. They are not so well joined in crystal or access. I did see the menu report and saw it was a work table,  but I could change and place it on the menu and pull from there. If generating in crystal it doesn’t populate work tables when you want to preview the report.

If you use the standard report on the menu, then you create a report setting under it and use it to populate the Wrk table by specifying your criteria like you normally would and then preview and export or set the printer to Export Data Only and click Print.

You would just modify the Crystal Report behind the report setting so that it cleanly exports the data you want to Excel in a row and column format.

That what I was thinking if I just save a diff name and change the format from there. Thanks! I’ll let you know how I make out.