Skip to Content (Press Enter)
2020-04-29 14-31-37
Charles Betman
186Views
3Comments
Export entire result of an aggregate to Excel
Question

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?

0
0
17 Feb 2017
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

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).

0
0
17 Feb 2017
Copy Link
2020-04-29 14-31-37
Charles Betman

That does the job, thanks Kilian!

1
0
17 Feb 2017
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

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

1
0
17 Feb 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.