To add a Cross-Tab to an existing report

In this example, a Cross-Tab is added to an existing report to show the sales in North America compared to the rest of the world.

1. Open your report.

   This example uses the Group by Intervals.rpt included in the Feature Examples directory.

2. Click the Design tab.

3. On the Insert menu, click Cross-Tab.

   The Format Cross-Tab dialog box appears. This dialog box is made up of three tabs: Cross-Tab, Style, and Customize Style.

   

Defining the structure of the Cross-Tab

Add fields to the Rows, Columns, and Summarized Field areas.

1. From the Report Fields list, click Country, then click Add Row.

   The Country field is added to the Rows area.

2. From the Report Fields list, click Last Year's Sales, then click Add Summarized Field.

   The Last Year's Sales field is added to the Summarized Field area.

3. Apply additional structure:
   • Click Country in the Rows area.
   • Click Group Options.
   • Select in specified order from the drop-down list.
   • Type North America for the Name of the Named Group.
   • Click New.
   • Choose is one of from the drop-down list.
   • Select Canada, Mexico, and the U.S. from the drop-down list.

     

   • Click OK to close the Define Named Group dialog box.
   • Click OK to close the Cross-Tab Group Options dialog box.

Choosing a predefined style

1. Click the Style tab.
2. Select a style.

Applying a custom style

1. Click the Customize Style tab.
2. Customize the style as desired.

Finishing the Cross-Tab

1. Click OK.
2. Place the Cross-Tab in either the Report Header or Report Footer.
3. On the Report menu, click Refresh Report Data.

   The updated report appears.