Crosstab Report Dialog Box. Use this option to print the all columns before printing the rows that do not fit on the first printed page. Expand Product and double-click Product line to add it as rows.
Designer displays the Create Crosstab dialog box when you select Insert Crosstab or drag the Crosstab icon from the Components panel into a report and provides you with different options in the dialog box. Expand Product and double-click Product line to add it as rows. After adding a crosstab object to the report the Crosstab Editor dialog is where you set up the crosstab report table.
In the Select tables dialog box enable the check boxes next to the database tables you want to add to the CrossTab report.
On the Crosstab tab of the Query dialog box select data items. Shows the Data tab in the Query dialog box. Double-click the Products folder to open it click Productline click the rows button and confirm that this item appears in the Rows box as shown. Crosstab Formula Editor Dialog Box.