Let's work through an example for the Xtreme Mountain Bike Company—the fictitious company that corresponds to the sample database provided with Crystal Reports.
Xtreme management needs a summary report to provide a quick glance at its shipped orders. The managers want to know how much has been spent by country for every six-month period, but they only want to see the top 10 countries. The following steps show you how to create this report:
Create a new report by choosing File, New and when the Report Gallery appears, choose As a Blank Report and then click OK.
The Database Expert appears. In the Available Data Sources list, expand the following nodes: Create New Connection, ODBC. Select the Extreme Sample database ...