Cross Tab

A Cross Tab is an object that summarizes data and presents the summaries in a compact row and column format.  This allows comparisons and identification of trends to be displayed.

This is an example of a typical cross tab report

Inserting Cross Tab:

• Catalog Browser: Click on the icon in the Container tab. 
  
  
• Editor Toolbar: Click on the icon.
  
  
• Menu: Click the menu command Insert/Cross Tab.   The following window will appear.

Highlight a specific field from the query you created in the Data tab.  Either click on Add To Row, Add To Column, or Add To Summary.  If you selected Add To Summary, do not forget to select a function from the Function drop down menu on the right.  You may remove unwanted fields by highlighting them and clicking on Remove.

You can also set a field's group options or background color by clicking a field to select it and then click on either Group Options or the Background drop down menu.