1. Home
  2. /
  3. User Guides
  4. /
  5. Analyser
  6. /
  7. Report Writer
  8. /
  9. DC1 Report Writer in...
  10. /
  11. Report handling
  12. /
  13. Working with columns using...
  14. /
  15. Define a column using...

Define a column using DC1 Report Writer in DC1 Analyser

Related topics

  1. Access the Manage Report definitions menu item and open the applicable report.
  2. In the Report definition edit window, toggle to the Columns page. Click the New icon.
  3. In the Report column edit view window, complete the following information:
    4. Column number
    Enter a sequential number for the column.
    Column headings
    Enter the applicable column headings and/or select from the following options:

    • Use period name
    • Use budget name
    Column type
    Click the arrow to the right of this field and select from the list of valid column types (i.e. Balance, Debit, Credit, etc).
    Balance type
    Depending on the column type you chose, this field will or will not be open for input. If open for input, click the arrow to the right of this field and select from the list of valid balance types. Note: The balance types available depend on the keys you included in the report. As previously mentioned, the system performs a cross validation of combination keys/balance types that can be used.
    Budget
    Depending on the column type you chose, this field will or will not be open for input. If open for input, click the arrow to the right of this field and select from the list of existing budgets on which to base the values in the columns.
    Edit format
    The edit code controls how the figures on the report should be shown. The most commonly used edit codes are:

    • 1 – The values are printed with two decimals, i.e. 123456789.00
    • 2 – The values are printed as integers, i.e. 123456789
    • 3 – The values are printed in thousands with one decimal, i.e. 12345678.9
    • 21 – The values are printed with two decimals and thousand separators, i.e. 123,456,789.0
    • 22 – The values are printed as integers with thousand separators, i.e. 123,456,789
    • The sign for the thousand separator and the decimal separator is controlled by the system value QDECFMT in the iSeries. For more information, contact the System administrator of your iSeries.

    Click the arrow to the right of this field and select from the list of valid formats

    Toggle to the Periods page.

    Periods page
    In this page you define the Year and Period values from which the values shall be retrieved. Select the applicable information from the drop down lists.

    Toggle to the Selections page.

    Selections page
    All the keys that you included in the report (via the Main page of the Report definition edit view window) are displayed.

    In this page you define the From /To and Mask selection values for the relevant keys.

    By making a selection on column level you can further tailor the report, thereby narrowing down the information you want to retrieve and display in the report. You do not have to complete this information now. You can, instead, complete the values with dots (…..) which means that you can complete the selections, instead, during the generation of the report. You need at least as many dots as the field is long. Any dots in excess of the field length will automatically be truncated by the system

    Caution: If you make selection(s) in a column and you have previously made selection(s) for other keys (than in a column) in a version for a Summary report, it is possible that you will not get any result when the report is created. This is because the system will select the appropriate summary level according to the selections defined in the version, and not in the column.

    Example:
    In a column you make a selection on the statistic key Country. In the version connected to the report you make a selection on the statistic key Customer/supplier number. When the report is created (for example, printed), the system will try to find the most appropriate summary level to use according to selections done in the version. If the system finds a summary level defined with only the key Customer/supplier number, that summary level will be used. This means that no summaries exist in the Balance file for Country and Customer/supplier which can result in zero figures.

    To avoid the problem with zero result, also make selections for the same keys as in any column. For example, in this case complete the From and To fields for the Country key and select all countries.

    Mask selection
    This field can be used in the following three ways:
    • If you only want to include country GB, enter GB in the Mask field for the key.
    • Enter dots (….) in the Mask field for a key. This will result in a selection panel when this version is used when a report is printed.
    • You have to enter as many dots as the key is long. For example, if you enter dots for the key Country, you should enter four dots, since this field Country is four positions long.

    If you want to include all customer/supplier numbers with the character “2” in the third position of the code (102000, 112040, 122300), enter __2________ in the Mask column.

    In the first two positions you enter underscores (__), in the third position you enter the character 2, in the next eight positions you enter underscore (________). The total length of characters and underscores, must equal the length of the key. That is why you have to enter eight underscores after the character 2.

    Save the information.

  4. You return to the Report definition edit view window for the Columns page, where the information is updated. Add as many columns as desired via the instructions above, or see Copy a column using DC1 Report Writer in DC1 Analyser.

    5. When finished you are ready to create the layout of your report.

Related topics