Consolidated Fixed Asset reports for Tax Return Review

What does everyone do to get the consolidated Form 4562 and Form 4797 for your consolidated federal and unitary state tax returns? We have over 70 databases that get combined together in the tax returns, and we are currently consolidating the data in Excel to verify information is represented correctly. This is a huge time strain, and would like to see a report that will do this in the Sage Fixed Asset Premier product.