There is not other way, unless you use ms access, ms excel or crystal reports.
It should not take days. We have over half million inv tran and it is quite fast.
Time to clean up your inv tran table.
Consolidate inv tran
Fix binary Zeros and reindex your table.
but before doing anything, backup, then backup your backup.
Kelloggs