Step 1 - Create Your CrossTab
CrossTab Tutorial
Step 1 - Create Your CrossTab
Note: CrossTabs can only be placed in the Footer of your Groups (or in the Summary Band)
Navigate to the Palette Tab
Drag & Drop CrossTab Element onto your summary band, or one of your Group Footers.
When you drop the CrossTab onto your report, a “CrossTab Wizard” will appear.
Click Next to move past the first screen of the CrossTab wizard.
Select the field/variable to use as your Columns
The CrossTab will generate one column for every unique value in the selected field/variable.
For example, if you select the “Grade Level” field, you will get one column for each grade level. Or, if you select the “Site Name” field, you will get one column for each Site in the data.
Click the
>button to move the field/variable into the next column.Click Next
Select the field/variable to use as your Rows
The CrossTab will generate one row for every unique value in the selected field/variable.
For example, if you select the “Grade Level” field, you will get one row for each grade level. Or, if you select the “Site Name” field, you will get one row for each Site in the data.
Click the
>button to move the field/variable into the next column.Click Next
Select the field/variable you want to use as your “Measure”
Click the
>button to move the field/variable into the next column.Select a calculation from the calculation drop down menu.
The available options under calculations will vary depending on whether you have selected a numeric or text field for your measure.
Click Next
Last updated
