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.
- Open your report.
This example uses the Group by Intervals.rpt included in the Feature Examples directory.
- Click the Design tab.
- 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.
- From the Report Fields list, click Country, then click Add Row.
The Country field is added to the Rows area.
- 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.
- 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
- Click the Style tab.
- Select a style.
Applying a custom style
- Click the Customize Style tab.
- Customize the style as desired.
Finishing the Cross-Tab
- Click OK.
- Place the Cross-Tab in either the Report Header or Report Footer.
- On the Report menu, click Refresh Report Data.
The updated report appears.