Somehow obvious: SAP Business One mostly uses a MS SQL Database. Instead of accessing the data via the application to generate reports, you can of course tap directly into the SAP Business One database with Microsoft Query.
The best way to do this is to output the data with Excel as the front end.
Carl Lewis demonstrates how to do this and more about Excel integration with SAP Business One in a webinar.
[contact-form-7 id="23785″ title="Contact-new"]