Hi Nick,
Everything you have here sounds not only doable, but pretty easy. All you would have to do is set the DataSource on the grid and it will automatically pick up the structure of the data source you assigned. You could use the Load and Save methods on the grid's DisplayLayout to save the last layout for each different view, so that when the user switches away from a view and back, the grid would maintain the column sizing, position, sorting, etc. that they had the last time they viewed it.
Regarding the hiding of columns, you can use the ColumnChooser for this. The easiest way to do this is touse the RowSelectorHeaderStyle property and set it up as a ColumnChooser button. Then the users can click it and it brings up a list of the column that they can show / hide just like Microsoft Outlook has.
MIke -
Thanks, this helps greatly, the main purpose of the form is to allow the user to export to the clip board the data in the grid.
I do have another question. Let's say I apply all suggestion and the user filters the data using columns filters and hides a couple of columns in the process. What the best way to copy to the clip board only the rows and columns currect displayed in the grid? Again many thanks. BTW, we are using v 3.1 of the UltraGrid control.
Nick