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 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.  A selection dialog will appear for the chosen element type. Choose the "Crosstab" element 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, 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.

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