Special Reporting Techniques

    This section will explain the use of parameters. The advantage of parameters over relations is that the reports can be executed more quickly. The parameter is added to the SQL statement. This results in only the filtered data being retrieved from the database.

    In addition, grouped reports and hierarchical reports will be covered in the following sections. In the Sub-Reports section, you will learn how to use a sub-report to generate a single row that shows data from multiple tables.