Chris,

Follow-up, because I just now realized you had a setdatasource in your original code.

I don't know if dsOrder is a dataset that you created in code, or something you pulled back from SQL Server. But at runtime, you can specify an entirely different set of tables from a dataset (including tables that contain just one order), so long as they follow the same structure and order as the tables you used at design-time.

So at design-time, when you use the database expert, you can point to tables from SQL to get the structure, or you can use an XSD definition that you created in VS.NET (I prefer the XSD approach) - and then at runtime, you can use setdatasource on each table to tell Crystal where to get the actual data.

Again, let me know if that helps.

Kevin