Using a SQL statement in Crystal Reports

Have you ever had a complicated report that you just couldn't write using the "wizards" in Crystal Reports? Well you can write an SQL query and enter it directly into Crystal using a Command.

When adding tables you can add a query by clicking on Add Command.



That will open a box where you can enter a query. You can even add prompts (Parameters).

The data returned to in you Select statement is then available in your report.

Applies to TIMSS5 & TIMSS6