Report query (Fields)
This table regulates the queries on reports.The following fields can be edited.
TargetSheetAndCell
The sheet and cell number where the query is to be placed.
ShowColumNames
If true, the colum names of the query will be shown on the report.
InsertTargetRow
If true, this function copies the cells that are not filled in by the dataprovider (formulas, text etc.) down row by row.
DataProviderSettings
These are the optional settings that govern the behavior of the dataprovider. They are specific per dataprovider (query) and not interchangeable.
FilterExpression
Enter an expression here that filters certain part of the query.
AssignExcelNamesToValuesInFirstRow
If true, excel assigns names to the columns based on the values in the first row.