Crystal Reports  

Cross-Tab Screen (Cross-Tab Report Creation Wizard)

Use the Cross-Tab screen to create and format a cross-tab object for your report. This screen appears only in the Cross-Tab Report Creation Wizard.

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 arrow 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.
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.
Up or down arrow buttons
Use the up and down arrows adjacent to each list to change the order of fields you've added from the Available Fields list.
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 > arrow adjacent to the Columns list.

If you choose a Date field or a Boolean field, the adjacent list becomes available with options that apply to that type of field. For example, if you pick a date field, you can select options such as "for each day," 'for each week," "for each two weeks," and so on.

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 > arrow adjacent to the Rows list.

If you choose a Date field or a Boolean field, the adjacent list becomes available with options that apply to that type of field. For example, if you pick a Boolean field, you can select options such as "on any change," "on change to yes," "on change to no," and so on.

Summary 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 > arrow adjacent to the Summary Fields list.

If you add your summary field, the adjacent list becomes available with summary options. Choose the kind of summary you'd like to apply to the field.

See Also

Inserting Cross-Tab Objects