Crystal Reports  

Cross-Tab Tab (Cross-Tab Expert)

The Cross-Tab tab contains the basic functionality you need to create a cross-tab. You can define rows, columns, and summarized fields. As well, you can create groups and formulas directly from this tab.

Available Fields
This list displays all the tables and fields that you have activated for use in the report.

Select the field you want to use and drag it into the appropriate list, or click the appropriate Add button. Repeat this process to add additional fields.

Browse Data
Click the Browse Data button to view the values for a field you have selected in the Available Fields list.
Find Field
Click this button to enter the name of a field you'd like to locate in the Available Fields list.
New Formula
When you click this button, the Formula Name dialog box appears. Enter a name for your new formula and then click OK. The Formula Workshop dialog box appears with the Formula Editor active so you can create the new formula.
Edit Formula
When you click this button, the Formula Workshop dialog box appears with the Formula Editor active. Use the editor to edit the selected formula. Edit Formula is available only when a formula field is selected in one of the lists.
Columns
This list displays the fields that you have selected as column headings for your cross-tab. If you have multiple column headings, they will appear on your report in the order in which they appear on this list.

To add a column heading to this list, select a field from the Available Fields list and then drag it onto the list, or click the Add Column button.

Rows
This list displays the fields that you have selected as row headings for your cross-tab. If you have multiple row headings, they will appear on your report in the order they appear on this list.

To add a row heading to this list, select a field from the Available Fields list and then drag it onto the list, or click the Add Row button.

Summarized Fields
This list displays the fields that you have selected as summarized field headings for your cross-tab. If you have multiple summarized field headings, they will appear on your report in the order they appear on this list.

To add a summarized field heading to this list, select a field from the Available Fields list, then drag it onto the list, or click the Add Summarized Field button.

Add or remove arrow buttons
Use the > arrows adjacent to each list to add fields from the Available Fields list. Use the < arrows to remove fields you've already added.
Group Options
When you click this button, the Cross-Tab Group Options dialog box appears. Use this dialog box to enter a group for your cross-tab. Group Options is available only for rows and columns.
Change Summary
When you click this button, the Edit Summary dialog box appears. Use this dialog box to change the summary type of the cross-tab's summarized fields. Change Summary is available only for summarized fields.

See Also

Cross-Tab Expert Dialog Box | Style Tab | Cross-Tab Group Options Dialog Box | Formula Editor | Edit Summary Dialog Box | Crystal Report Creation Wizards