RowDef Data Clear

Estimated reading time: 1 minute


Data does not clear when multiple columns are defined as the RowDefRange for a ReportVariable. This happens only when the first column of the RowDefRange is missing from the ColDefRange.

Cause of the Error

Here is a report that has columns B and C defined as the RowDefRange in this ReportVariable (Notice the first column of the RowDefRange contains the [!DetailRow]):

This report does not clear the data when executing a Data Clear. The problem is the first column definition is missing in the ColDefRange:

The Solution

To fix the problem, ensure all the columns are found in the ColDefRange: