Adding & Creating a New report

Alchemex 7.1

Home > Getting Started Guide > Adding & Creating a New report

Adding and Creating a New Report

To create a new report from existing containers, it is advisable to create a new folder or the other option is to create the report in an existing folder. Remember that folders contain all the reports related to a particular topic, for example, all reports related to Sales. You cannot create sub folders.

Creating a New Report from Existing Containers

This process consists of two steps:

  • Adding a folder

  • Adding a report

To add a folder

  1. Open the Sage Intelligence Reporting Report Manager.

  2. Click on the Home object.

  3. Right-click and select Add Folder.

  4. The Enter a Name for the Folder window appears.  Enter a name for your folder; for example, Sales Test.

  5. Click OK.

To add a report

  1. Select the Folder where you want to add the report; for example, Sales Test.

  2. Right-click and select Add Report.

  3. Select the type of report to add when prompted. You will add a Standard Report.  A Union Report is made up of 2 or more standard reports.

  4. Enter a new name for the report.

  5. Click OK and the Select Data Container window appears.

  6. Select the data container from which you want to source your data. The Choose Column fields window appears.

  7. Select the columns you require in your report.

  8. (Optional) Click Select All to select all of the expressions.

  9. Click OK. Your new report is now in your specified folder.

  10. To run the report:  In the object window select the report you have just created and click on the Run icon   on the Report Manager Toolbar.

     

    Your data will be opened in Microsoft Excel in the required format.