Common field shared by all data sources:
Display name – a name that can be assigned by the user to the data source.
Fill method – a field that specify how the data source is going to behave during the data download, the available values are:
Auto with expand - when downloading the data, the data source is going to move the data sources that are under his space to make room for the data (if the data source is transposed, it is going to move the data source on its right side).
Auto - when downloading the data, the data source is not going to move the other data sources, it is going to write the data on the worksheet and it may overwrite the content of another data source.
Use threshold - when downloading the data, the data source is going to retrieve a number of rows limited to the value specified by Number of rows; as in the same case of Auto, the data source is not going to move the other data sources, it may overwrite the content of another data source.
Unless you need to limit the number of rows, the recommend fill method is Auto with expand.
Number of rows – a field that the user can configure only when the fill method is set to Use Threshold, specify the maximum number of data that should be retrieved.
Datetime format – a field that specify the format to display datetimes, you can bind a parameter to this field to customize the report before running it or to use a shared format across multiple data sources.
Double format – a field that specify the format used to display numbers, you can bind a parameter to this field to customize the report before running it or to use a shared format across multiple data sources.
Show timestamp in UTC – shows the timestamp and datetime in the UTC format.
Anchor row – adds the anchor row to the data source, adding the anchor row forces the fill method to Auto with expand.