Add Dataless Report

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Picklists allow you to consolidate data from same and disparate databases.

What if you need to consolidate data from sources other than a database?

Alchemex allows you to Add a Dataless Report for the purpose of consolidating data from sources other than a database.

The Dataless report does not access any database but rather activates an Excel workbook that contains Macros designed to consolidate information from workbooks that you have stored previously in other reports.

Method

1.In the Report Manager Module, right click on the report folder

2.Select Add Dataless Report

Add Dataless Report

3.Enter a name for the Dataless report in the displayed box

Add Dataless Report

4.Select OK

Add Dataless Report

8. Navigate to the report that contains the functional macros

Add Dataless Report

9. Select Open

10. The report will now be linked to the Dataless Report folder:

Add Dataless Report