The Query Wizard TOP Step

Specify how many records you want to retrieve from the database in the TOP step.  For charts, this is an important option because usually you want to show only the most significant five or ten numbers and combine all the rest in a remainder or “Others” value.  For charts, this can be configured on the Options step of the Charting Wizard.

For reporting controls (Sums and Counts) it makes sense to retrieve All the records, because values retrieved are based on the ID of the row which must be stored in the data source.

See Also

Customizing Database Queries with the Query Wizard

The Query Wizard JOIN Step

The Query Wizard SELECT Step

The Query Wizard TOP Step

The Query Wizard WHERE Step

The Query Wizard ORDER BY Step

The Query Wizard FINISH Step