Client Invoice / Report

This is really a combination of Crystal Reports and SQL to modify an existing invoice for a specific client. You would have access to the report file, stored procedure and a scratch/test database. I think the bulk of the form probably needs to be handled on the SQL side, which is a bit over my head. I've added a PO filed to the report, (ex PO#, 0002-0215p3859). The line items on the invoice need to be sorted by the number to the left of the hyphen. All line items associated with that number need to display and total. Freight needs to do the same thing in parallel. I don't think it's overly complicated for someone that knows what they're doing in SQL and Crystal Reports. If the basic form can be made functional, I can "pretty it up" and fine tune the final output. The software that generates the invoice EPMS which probably doesn't mean much to anyone.