How to export order data for reporting
You could also export the data to a CSV with your own SQL commands. These commands could be created in a way to take parameter that your client could set through the CP.

You'd need to create a plugin with a controller method that runs your SQL query. Take a look at the docs for more info on querying the database.