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.

See also

Reports

Report C# filter expressions