TRVRowGenerationRule.KeyFieldNames

<< Click to display table of contents >>

TRVRowGenerationRule.KeyFieldNames

A semicolon-delimited list of fields used to distinguish records in cross-tab reports.

property KeyFieldNames: TRVUnicodeString;

This property is used only when building a cross-tab report. Otherwise, it is ignored.

All records (returned by en execution of DataQuery) having equal values of these fields are mapped to the same table row.

If KeyFieldNames is empty, all records are mapped to a single row.

If a field listed in KeyFieldNames does not exists in results of DataQuery execution, this field is ignored, and OnError event occurs with the parameter rvrgeCrossTabUnknownField.

Fields listed in the property may have one of the following types: rvrftInteger, rvrftBoolean, rvrftDateTime, rvrftDate, rvrftTime, rvrftText, rvrftFloat. Otherwise, this field is ignored, and OnError event occurs with the parameter rvrgeFieldUnsupportedType.

If a field listed in this property has rvrftText type, its values are compared using CaseSensitive property.

Default value:

'' (empty string)

Example:

'id1;id2'

See also:

information about building a cross-tab report in the topic on TRVCrossTab