I'm trying to page the records (server mode) as there are hundreds of thousands of records.....
And you would like the records to be fetched only when they are displayed because you can't afford to load them all in memory right?
DevExpress server mode is based on an interface, it should be possible to implement this interface with llblgen code but although I haven't tried I'm sure it would be hard work to handle all possible sortings, groupings, filterings...
Can you afford to provide a few controls (comboboxes, textboxes) which would allow the user to be a bit more specific about the actually needed records ?