Home > Report Manager > Maintaining Reports > Add Dataless Report

Add Dataless Report

Sage Intelligence Reporting allows a user to Add a Dataless Report for the purpose of consolidating data from various sources. The Dataless report does not access any database but rather activates a Microsoft Excel workbook that contains Macros designed to consolidate information from workbooks that you have stored previously in other reports. The Dataless report will usually contain some advanced bespoke Macros which will perform a consolidation or reconciliation of some type. The Dataless Report is not to be confused with the Picklist Functionality. Picklists allow you to consolidate data from same and disparate databases.

Typically you will link your Dataless report to a Microsoft Excel workbook that contains macros that references other workbooks that store your information.

Method

1. Right-click on the Report folder.

2. Select Add Dataless Report.

3. Enter a name for the Dataless report in the dialog box and select OK.

4. Notice the Report button , indicating that it is a Dataless Report.

5. You will then need to link the Dataless report to a Microsoft Excel book that contains the functional macros.

   To do this: Open the Microsoft Excel workbook, then from the Report Manager, use the create and link template function to link the workbook as a template file.