You can create reports with tables, cross tabs, and charts. Then add parameter filters, page controls, labels, images, and videos to the report.

For example, you might create a tabular report that displays the customer ID, name, and last order date for all retired customer records. You can add filters to allow the user to select customer-status levels. Or, you might create a pie chart that shows the percentage of archived customer records that have the platinum, gold, or silver status level.

You create a report by specifying the data you want in the report. You can specify the data for the report in one of the following ways:

Select the tables from the report-creation wizard. If required, create relationships between fields within and between tables.
Enter an SQL query with the schema and table details.

After you specify the data for a report, design, save, and run the report.