Create Reports - the Axes Tab

This tab is used to define the report’s axes. This means deciding what type of information will be shown in the report’s rows and columns.

The dimensions can be selected in 3 different ways:

  • In the Available list box, select a dimension and use the drag and drop method to move it to either the Column Definition list box or to the Row Definition list box.
  • In the Available list box, select the dimensions you want to be available to select when you run the report in Reports/Run by ticking the check box. The dimensions that are cleared will not be available in Reports/Run.
  • In the Available list box, clear the check box and then select the dimensions you want to be hard-coded in the pop-up list in the Code column. The selected dimension will always be used in Reports/Run.

Procedure

  1. On the Reports menu, click Create. The Create Reports window opens.
  2. Open the Axes tab.
  3. In the Available list box, select the dimensions you want to define as rows in the report, and use the drag and drop method by placing the cursor in the grey area in front of the row to move them to the Row Definition list box. For example, select Account to be displayed as report rows.
  4. In the Available column, select the dimensions you want to define as columns in the report, and use the drag and drop method by placing the cursor in the grey area in front of the row to move them to the Column Definition list box. For example, select Period and Actuality to be displayed as report columns.
  5. In the Available check box, select the dimensions you want to be available when you run the report in Reports Run. The dimensions that are cleared will not be available in Reports Run.
  6. In the pop-up list in the Code column, select the dimensions you want to be hard-coded in the report. For example, clear the Actuality check box and then select AC in the pop-up list in the Code column. The actuality AC will now always be used when the report is run.
  7. Click Save.
  8. Open the Row Definition tab.