The report creation process

Alchemex 7.1

Home > Tutorials > Report Manager Tutorial > Report Creation Overview > The Report Creation Process

The Report Creation Process

The main purpose of the Report Manager is to create and maintain Sage Intelligence Reporting reports linked to Microsoft Excel. Creating a report is a five part process:

Report Manager

Report Creation Process

  1. Add a Folder

    Folders contain all the reports related to a particular topic. For example, all reports related to a particular financial year or reports related to the stock of a company. You cannot create subfolders.

  2. Add a Report

    The report process is wizard driven and you are required to select a container to create the report from.

    Note: The data container is created in the Connector.

  3. Set Output Properties

    Output properties govern the type and manner in which your data is displayed in Microsoft Excel. For example, you are able to apply filters to restrict the amount of data displayed or apply aggregate functions to summarize the data.

  4. Run the Report

    The first time a report is created it is necessary to run the report and then link it back to Sage Intelligence Reporting as a Microsoft Excel template. Subsequent report runs of the report will automatically use the allocated template.

  5. Link Microsoft Excel

    Once a report’s data has been exported to Microsoft Excel it is necessary to link it to Sage Intelligence Reporting as a Microsoft Excel template. This process enables you to create complex templates that will always have access to the latest data at the reports run time.

The following exercises take you through these processes.

Next-->