There is no way to dynamically select tables in directly Crystal without writing code. However, you could create a stored procedure on your database that would take the parameters passed to it from Crystal and do the table comparison that you're looking for.
The challenge is that the stored procedure must ALWAYS return a dataset with the exact same fields in it. If you were to write non-SQL code to set the tables at runtime, this is also the case. Crystal does NOT handle changing dataset structures at run time very well and is likely to crash if you try to.
-Dell
IP Logged
