You can use the Layout property to store the control's layout and to restore the layout later. For instance, you can save the control's Layout property to a file when the application is closing, and you can restore the control's layout when the application is loaded. The Layout property saves almost all of the control's properties that user can change at runtime ( like changing the column's position by drag and drop ). The Layout property does NOT save the control's data, so the Layout property should be called once you loaded the data from your database, xml or any other alternative. Once the data is loaded, you can call the Layout property to restore the View as it was saved. Before closing the application, you can call the Layout property and save the content to a file for reading next time the application is opened.

The Layout property saves/loads the following information:

• PivotRows property
• PivotColumns property,
• PivotTotals property,   
• columns size and position,
• current selection,
• scrolling position and size,
• expanded/collapsed items, if any
• sorting columns,
• filtering options

These properties are serialized to a string and encoded in BASE64 format.

The following movies show how Layout works:

•  The Layout property is used to save and restore the control's view.