How good are your SQL skills? You're probably going to have to use either a Command or a view in the database for this instead of linking tables together. A Command is nothing more than a SQL Select statement that you enter in the Command Editor in Crystal to pull ALL of the data for the report.

In general, you don't want to have a Command linked to anything (another command, tables, etc.) in your report because Crystal is not able to push the filter or the joins to the database. Instead, Crystal will pull ALL of the data into memory and do the joins and filtering there, significantly impacting the speed of the report.


Also, when you use a Command, you should NOT use the Select Expert to filter the data for the report - for the same reason - Crystal can't push it to the database so your report will be slow. Instead, you'll put any filtering into the "Where" clause of the SQL in the Command.

If you need to use parameters, you MUST create them in the Command Editor which cannot "see" any parameters that are created in the report itself. There are very limited options for configuring the parameters in the Command Editor, but params created there will appear in the Field Explorer after the command has been saved. You can then edit them from there.

-Dell