I have a complex report that is grouped by ID and therefore sorted by ID.  We would like it to be sorted by Company name so we can match them up with invoices (that are sorted by company).  Is there a way to do this?  Someone mentioned a staging table, but I'm not sure what that means.

Twisting what DBlank said, I would assume that in the record that there is a company as well as the Invoice ID.

You can easily create a formula like:
{table.company} + "-" + {table.invoiceID} (adjusting for converting to string if needed) and group on that, which will sort as you desire...

Depending on how it adds to the complexity, you could just add a group above the invoice that is based on Company...then you would see the company and could run totals etc.

And we all know that sometimes, something that souunds as simple as adding another group, is way more complex and undoable.

HTH