Export entire result of an aggregate to Excel

Export entire result of an aggregate to Excel

  

Hi, I would like to export the entire resultset of an aggregate to Excel, not only the actual records displayed on the screen in the ProjectTable.


In this specific case the aggregate return more than 4000 records, of which 25 are displayed on the screen (Line Count ProjectTable). Only these 25 are exported. How can I export all 4000 of them to Excel?

Assuming your query used to display the results is in the preperation, use a refresh query () and make sure the Max. Records property is not set. Use the Query.List in the RecordListToExcel widget (instead of the TableRecords.List).

That does the job, thanks Kilian!

You're most welcome :). It's a pattern we've had at hand many times.