View

Alchemex 7.1

Home > Connector > Data Containers > Adding a View Container

Adding a View Container

Sage Intelligence Reporting supports the use of a View as the source for Data Containers for certain Database systems.

Method

  1. In the Connector, add a new Container to your Connection. When prompted to Select the Container Type, select View.
  2. The Container name will default to the View name.
  3. When prompted, select the View that you would like to use as the source for this Data Container.
  4. Click OK to complete adding the container.
  5. Right-click on the new container and select,  Add Expressions. When prompted for the Expression Type to add, select Data Fields.
  6. The list of fields that the View holds will appear. Select those fields which you would like to be available for reporting on, and click OK.

The Container is now ready to be used in reports.