Let's assume that you want to examine the development of turnover per year, quarter and country. Proceed as follows in the Sample Application:
1. Crosstabs are elements in the report container. Therefore, you add these objects in the "Objects" tool window. If you have not yet added a report container to the workspace, select Insert > Report Container (Objects > Insert > Report Container) and pull the object to the right size in the workspace while holding down the left mouse button.
2. Alternatively - if supported by the application - a crosstab can also be placed directly as an object. Select Insert > Crosstab (Objects > Insert > Crosstab) and drag the object to the desired size in the work area while holding down the left mouse button.
3. If you drag fields into an empty area or into an existing report container, a new crosstab is created. For more information on drag & drop, see chapter Variable/Field List and Drag & Drop.
4. A selection dialog will appear for the chosen element type. Choose the "Crosstab" element type.
5. In the following dialog, now select the data source. All available tables are shown hierarchically, in other words, under the tables you will find the related tables in each case.
For our turnover analysis, e.g. choose the "Customers > Orders > Order Details" table so that you have all three tables at your disposal. The "Customers" table contains the country, the "Orders" table the order date and the "Order Details" table the turnover.
6. A wizard appears which will lead you through the 3 configuration dialogs for crosstabs.