Report Definition Manager
Open the Report Definition Manager from the from the multi data source (MDS) menu on the Reports Wand Excel ribbon. The Report Definition Manager will allow users to create, edit and delete MDS report definitions.
Create a MDS Report Definition
Click on the “New” button. Provide the details required for the report definition and select the relevant data source connection.
Click “Next”. Enter the SQL for the report definition. Required parameters (or bind variables) can be defined using the question mark (?) character.
Click “Next”. The SQL will validate, and move you to the next stage should it be successful.
Update the required parameters should any have been defined in the SQL. Select a list of values. Only MDS List of Values defined for the same data source connection will be available for selection.
Click “Finish”. A confirmation of the report definition will be displayed.
Edit a MDS Report Definition
Select the report definition you would like to modify from the report definition selection stage. Click “Next”, and make any changes necessary to the report definition. Please see the Create a New Report Definition instructions for more information regarding MDS report definition information.
Delete a MDS Report Definition
Select the report definition you would like to delete from the report definition selection stage. Click on the “Delete” button. A confirmation will be displayed before deleting the report definition.
Deleting MDS Report Definitions is permanent and once deleted they cannot be recovered.