The ClearData method clears the control's data. The ClearData method clears/empties the DataColumns collection and the PivotRows, PivotColumns, PivotTotals properties.

The control can load data using one of the following methods:

• Import method, loads data from a CSV file or from specified text.
• DataSource property, assigns an ADO/DAO record set to be loaded.
• LoadXML method, loads an XML file previously saved using the SaveXML method

The following properties may be used to group and summarize the data, once it is loaded:

• PivotRows property specifies the list of DATA columns that determines the first column in the control's list. In other words, the Group-By columns
• PivotColumns property specifies the  list of DATA columns that determines the rest of the columns to be displayed on the control's list
• PivotTotals property specifies the list of total/sub-total functions to be displayed on the control's list.