Questions on Reporting - Data Dump, Additional Detail, and Multiple Years

I am looking to improve our reporting in Sage 50, and am hoping others have come up with solutions or workarounds that they could share.

1. I would like to dump unformatted data into Excel so we can manipulate the data to meet our formatting needs. Is there any way to do this?

2. I need additional detail displayed from Purchase Journals. Currently, the G/L Detail report displays the vendor name as the "Comment", even if there is a line comment in the Journal. How can we display the comments in the reporting to provide the detail we need for analysis?

3. Is there any way to run a G/L report with more than one year of information?

Thank you all so much!