Eliminating duplicate rows from the report
In Prompted Query, you can request that rows with duplicate information not appear in your report.
About this task
If you create a query that is based on the sample tables that shows all departments that have salespeople, the report will show duplicate rows for each department with more than one salesperson. Such a report is shown in the following figure:
To eliminate duplicate rows:
- On the Specify panel, select Duplicate
Rows. The Duplicate Rows panel displays, as shown in the following figure.
- Select Single copy of each row.
The Prompted Query panel displays with your query in the echo area. The Specify panel does not display because eliminating duplicate rows is the last step in creating a prompted query. Press the Specify key to display the Specify panel if you want to work on your query again.
When you run the query, QMF displays a report that shows one row for each department, as shown in the following figure.