Creating a Crosstab Object

Let's assume that you want to examine the development of turnover per year, quarter and country. Proceed as follows in the List & Label Sample Application:

1.  Crosstabs are elements in the report container. Therefore, you add these objects in the "Report Structure" tool window. If you have not yet added a report container to the workspace, select "Report Container" in the "Objects" toolbar and pull the object to the right size in the workspace while holding down the left mouse button.

2.  A selection dialog will appear for the chosen object type. Choose the "Crosstab" object type.

3.  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, choose the "Customers > Orders > Order Details" table in the List & Label Sample Application 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.

4.  A wizard appears which will lead you through the 3 configuration dialogs for crosstabs.