Hello Yann,

One of the downsides of moving all the transactions into a single file is that it's much larger (although thisnow allows the creation of some kinds of reports that were previously impossible to create). You might find it faster to use ODBC lInked to Crystal, as it makes slightly better use of indexes than some of the joins in Crystal Reports for Adagio. Generally, you'll want to link on a one-to-one basis for the best performance if you are running the report for all customers.

Enjoy the weekend.