Hello,
I have an ultragrid bound to a dataset directly which has a master table with 2 details tables (linked to each other with relationships).
The grid display childbands as expected, however we are having the following issue with the UltraGridExcelExporter:
When we filter our parent table from 10,000 records to 10 the excel exporter takes the same amount of time that it takes to export the original 10K (more than 2 minutes!). The exported file eventually will have only the 10 rows but.... why is it taking so long?
Any help would be appreciated, thanks!
When you export the grid, the grid clones it's DisplayLayout and all of it's rows. This is a very powerful thing, because it means that you can make changes to the export layout or the export rows without affecting the on-screen grid.
But it also means that the the filtering and sorting has to be re-applied to the cloned rows.
What version of the controls are you using?