Hi Steve,

So is your comment that the Sales Statistics for a specific location cannot be done, or that it just doesn't work as fast? I suspect the latter.

Any custom inquiry or report will never be as fast because there is so much less underlying data for the Statistics. We don't store much detailed information here, so that it will be fast and can be presented in the way it is.

For a database that has a million transactions, you might have to do a customized view that generates overnight and that your client's investigation happens on this summary snapshot of the data, rather than 'live' data. Perhaps the next release of GridView can be helpful. It will be able to export Adagio records to an ODBC compliant database or MySQL, even overnight in the same way as Excel Direct works. So searching on a data snapshot in that environment might help satisfy the speed requirements.