Define New Data Source

Binds a report to a new data source.

1. On the Report Designer tab, in the AVEVA group, click Data Source to display the Data Source Wizard.

2. Select New to define a new data source and click Next.

   

3. Input the name and description for the data source and click Next.

   

4. Select the element types to be included in the report.

   

   At least one element type must be selected. The selected element type is used to populate the report.

   If required, enter a value in the filter field to filter a list of elements.

   

5. Select the required elements. Use the Ctrl and Shift keys to make multiple selections. Use the arrow buttons to move the currently selected elements in the Available Element Types grid to the Base Element Types grid.

   

6. Click Next.

   

   Filters can be added to limit the elements retuned by the data source. These filters can be simple attribute based comparisons, or more complex PML1 expressions.

   Attribute based comparison filters must be entered in the Attribute Filters field, PML1 expression filters must be entered in the Expression Filters field.

7. If required, click the appropriate Add Filter button and enter or select the filter details in the row of fields that is displayed. Multiple filters can be defined.

8. If required, click Delete to delete the currently selected filter.

9. Click Next.

   

   The attributes of the base elements of the data source are displayed in the Available Columns field.

   If multiple elements have been selected for the data source, select All Attributes to display all attributes of the element types, or click Common Attributes to display only those attributes common to all the selected element types in the Available Columns grid.

10. Select the required columns to display in the report. Use the Ctrl and Shift keys to make multiple selections. Use the arrow buttons to move the currently selected columns in the Available Columns grid to the Data Source Columns grid.

    Once one or more columns have been selected, PML1 expressions can be entered into the Data Source Columns grid, the results are available for use in the report. Intelligent text can be entered into the Definition column, this functionality is only available for use with intelligent tables. For example:

    

11. If required, click Back to modify the defined data.

12. Click Finish when the data is defined.

    The new data source is now available for use in the report. For example: