I'm creating a VisualForce page that displays the results from a query using a custom list controller. The purpose is to give the users a report that can't be created with standard reporting. It's a "does not have child object" report, but I can't use rollup summaries because the criteria has to include the result of a formula field on the child. This would be so much easier if reports could be based on a SOQL statement (hint hint).

My query will return potentially thousands of records and displaying them in the VF page with a paginator works great. However I want to give them the option to export the full result set to Excel, much like a standard report will. Unfortunately getRecords only returns what's in the current page set. How can I get the full result set (up to 10,000 of course) exported to Excel?

Mark