Special features in reports created via the DC1 Report Writer in DC1 Analyser

Click the links to expand the instructions for the special features you can implement in your reports to be able to further customise the way in which you want to view the data.

Insert break levels in a version for a summary report

Break levels are a way of breaking the key values on the report. To define that you want break levels on your report do as follows:

  1. Access the applicable report and toggle to the Versions page.
  2. Open the applicable version and toggle to the Sequences page
  3. If, for example, you enter a 2 in the Cust/supp number you are telling the system to break after the first two characters of the customer or supplier number. You will receive the following break levels on the online report:

    10 = first break level for those customers or suppliers whose numbers start with 10. Then the applicable customer or supplier numbers.

    100300

    102030

    109300

    10 = total

    11 = second break level for those customers or suppliers whose numbers start with 11. Then the applicable customer or supplier numbers.

    112500

    115200

    11 = total

    etc.

Print all breaks
To instruct the system to print all breaks for the key in this version do as follows:

  1. Toggle to the Options page.
  2. Check the Print all breaks box if you want to print break levels on your report.
  3. When viewing the report online, you will see the different key values broken down according to the break level. If text was defined for the break level(s) in the Break level text table, this text will also appear on the report. If no text exists, you will receive question marks.

Draw attention to comparison values by defining markings

This is valid in either a Summary or Line report. You do this by defining markings which are specific percentage limits you want to flag and the marking for the limit.

You can define markings for the following column types:

  • Budget achieved %
  • Forecast achieved %

And with the following edit format:

  • Percentage marking (81)

Note: This information is defined on the Columns page for the column.

By defining marking you can compare (track) the percentages achieved with the actual amount.

To define markings do as follows:

  1. Access the applicable report and toggle to the Markings page.
  2. If you had defined the percentage limits and you had a Budget achieved % column defined in your report, the following would be displayed in the online report:
    • All lines that reached 0 to 50% of the budget would be indicated with !!!.
    • All lines that reached 50 to 80% of the budget would be indicated with !!.
    • All lines that reached over 80% of the budget would be indicated with !.

Connect a balance enquiry template to a report

This is valid for either a Summary report or Line report. By connecting a Balance enquiry template you will be able to drill down on a lower level in the online report, to view the balances for the applicable key.

You connect the applicable template to either a Summary report or Line report via the Defaults page.

Click the Find icon to the right of the Template field. You receive the Selection required window where you select the applicable Balance enquiry template.

When viewing the online report you will be able to drill down to the balances (according to the Balance enquiry template).

Connect a summary report to a line report

This feature is ideal for Financial-related reports. Take, e.g., a Balance sheet – which is normally a Line report. If you create a Summary report with the same keys as those in the Line report you can connect the Summary report to the Line report. This will give you the following results:

  • The Line report outlining the sum of accounts and/or account combinations.
  • The Summary report which you can use for internal purposes, thereby drilling down to the details of each account.

To connect a Summary report to a Line report do as follows:

  1. Access the applicable Line report and toggle to the Connections page.
  2. You can connect just a Summary report or both a report and a version. Select the applicable report / version from the drop down lists. Click Save.
  3. When you run the Line report you will see the connected reports selections (i.e. just a Summary report or both report and version.

    When viewing the online report you will be able to drill down on as many levels as there are details.