▪ If you drag more than 2 fields into an empty area or into an existing report container, a new table or chart is created. You select the desired object via a dialog. For charts, a dialog then opens for further configuration of the chart.
Figure 3.21: Drag & drop dialog for charts
▪ If you drag only 1-2 fields into an empty area or into an existing report container, the 'Cross table' object is also available in addition to the table and chart. Additional data fields can then be added using drag & drop.
Figure 3.22: Drag & drop dialog for crosstabs
▪ When you drag fields from a relationally linked table to an existing table (e.g. fields from "Orders" to the table "Customers"), a new sub-table will be created.
▪ If you wish to add additional columns for existing rows in tables, you can simply drag the desired fields from the list to the corresponding location using your mouse. In this case, the field can be added to the left or right of an existing column; the insertion position is indicated visually with the help of a symbol. The column (default width 30 mm) will then be inserted in the corresponding row. Note that this may also create columns in invisible areas.
For numerical fields, this also automatically creates a footer with sums. If you do not wish to create a footer, hold down the CTRL key.
▪ If you have selected multiple fields, the order of the selection will be remembered and the fields will be placed in the corresponding order.
▪ If you select the report container, you can drag and drop one or more fields onto the black areas at the top right and bottom right to automatically create a table or cross table as the first or last entry in the report container.
Figure 3.19: Black buttons for drag & drop on tables/cross tables
▪ If you drag fields to an existing cross table, a new grouping or results cell is created. Of course, you can also drag the formula variables below the fields directly to the cross table, e.g. as a grouping for the year of a purchase order. You can also add further groupings (for example, by quarter) below or above this grouping using drag and drop.
Figure 3.20: formula variables