View the result of a report using DC1 Report Writer in DC1 Analyser

Related topics

If you chose to view the report online, when you ran the report, you will automatically receive the information on your screen. Otherwise, you can select View reports from the Report Writer menu.

Depending on the data in the report (determined by the keys and periods included in the report), the result will vary.

The first line of a Summary report is the grand total. You can drill down to any detail levels to view the applicable information.

The drill-down capabilities allow the following:

  • If there is a connected report for the report you ran, you can click the Drill down icon to view the next level.
  • If one of the keys is the Originating company, you can click the Company drill down icon to access the Originating company’s data. (See Drill down to data in another company below).

Viewing lower level transactions

You have the possibility to view the following lower level transactions. You access these transactions by choosing Actions/Transactions/View selected from the menu bar.

Note: Depending on the type of transaction that you drill down to, the associating keys and time period will be transferred and used as a filter in the launched transaction browser.

  • A/P Transactions
  • A/R Transactions
  • G/L Transactions
  • Purchase orders
  • Purchase order lines
  • Sales quotations
  • Sales quotation lines
  • Invoices
  • Invoice lines
  • Sales orders
  • Sales order lines

Drill down to data in another company

If the following is true:

  • At least one of the keys in the report you are viewing is company code (i.e. Originating company)
  • The ACS application is activated in Work with companies for the Analyser company in which you are viewing the report
  • The ACS application is activated in Work with companies for the company to which you are going to drill down.

You can drill down to the applicable company’s data. The drill down is normally from the corporate company to the originating company.

  1. View the applicable report in the Report Writer
  2. Click the Company drill down icon

A new session of Analyser will be started. The result will be a new window where you can view the data in the Originating company.

Utilising standard behaviour

All standard table behaviour is also valid for online reports (i.e. being able to move columns around, inactivate/activate columns, convert to html, etc).

You can easily distribute this by email to the applicable recipient.

Related topics