Defining data sources
How to define custom report data sources
Overview
In order to generate a custom report, you need to define one or more data sources that can be used to make up the content of the report. Data sources define where the data is located and are populated when the report is run. When you access the Report Builder the Data sources tab is displayed by default and allows you to create the data sources.
Creating data sources
To create a data source that is going to be used within the report use the following procedure:
- Select the Create data source button, the Create data source dialog is displayed.
- Use the following fields to configure a data source:
- Name - you need to enter a name for the data source.
- Required - this yes / no field is used to define whether the data source is required to be populated when the report is run. By choosing no the data source will allow a user running the report to leave this data source empty.
-
Type - this allows you to select one of the following types of data source:
- Alloy Id - this type of data source is populated from an Alloy Id value, see Create Constant data source.
- AQS - this type allows you to define an AQS query to populate the data source, see Create AQS data source.
- AQS statistics aggregation - this data source is populated from AQS statistics aggregations result, see Create AQS statistics aggregation.
- Date - this type of data source is populated from a Date value, see Create Constant data source.
- Date Time - this type of data source is populated from a Date Time value, see Create Constant data source.
- Geometry - this type of data source is populated from a geometry value, see Create Constant data source.
- Item - this type use the attributes and properties from a single item to populate the data source, see Create Item data source.
- Join - this type of data source is populated by joining two other data sources together, see Create Join data source.
- Number - this type of data source is populated from a number value, see Create Constant data source.
- Seasonal - this type of data source is populated from a seasonal value, see Create Constant data source.
- Text - this type of data source is populated from a text value, see Create Constant data source.
- Time - this type of data source is populated from a time value, see Create Constant data source.
- Yes/No - this type of data source is populated from a Yes/No boolean value, see Create Constant data source.
The appearance of the following fields depend on the Type that you previously selected
- Design or interface - when you specify the type of data source to be either an AQS query or and Item then you need to use this field to choose the design or interface that they are based on.
- When you have completed all the fields select the Create button. The data source is added to the list.
You can repeat the process to add other data sources to the report.
Removing a data source
To remove a data source from the list select the icon for the data source that you want to remove, you will be prompted to confirm the deletion of the data source.