| Start with an example for the Xtreme Mountain Bike Companythe 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. Follow these steps to create this report: 1. | Create a new report by choosing File, New and when the Report Gallery appears, choose As a Blank Report and then click OK. | 2. | The Database Expert appears. In the Available Data Sources list, expand the following nodes: Create New Connection, ODBC. Select the Extreme Sample database 11, click Next, and then click Finish. | 3. | Expand Tables, and double-click on Customer and Orders. Click OK. | | | 4. | The Database Expert dialog appears again. Click OK again to accept the default linking and click Finish to go to the report. | 5. | Insert a cross-tab by choosing Cross-Tab from the Insert menu, or click the Insert Cross-Tab button on the Insert toolbar (the fourth item from the left). This will present you with a shadowed box attached to your cursor. Place the box in any Header or Footer of your report (not on a page header or footer) and in this case put it in the upper-left corner of the Report Header. The box will become an empty cross-tab. | 6. | Set up the initial cross-tab. Right-click on the empty cross-tab and choose Cross-Tab Expert. The rows of the report are the countries, so select Country from the Available Fields and then click the arrow button (>) under Rows. The column grouping is going to be by Order Date, so choose Order Date from Available Fields and then click the arrow button (>) under Columns. Because the Order Date is supposed to be by quarter, click on the Group Options drop-down under Columns and change the third list box from Each Day to For Each Quarter. Finally, choose Order Amount from Available Fields and click the arrow button (>) under Summarized Fields so that the cell's summary is also selected. The final result looks like Figure 10.3. Figure 10.3. Cross-Tab ExpertCross-Tab tab.
| | | 7. | Click the OK button to close the Cross-Tab Expert and see the result in the report Preview, as shown in Figure 10.4. Figure 10.4. Cross-tab in Preview.
| 8. | Before continuing, save your work. Choose File, Save As. Call this cross-tab1.rpt and then click OK. |
|