I am new to grids. I have a form in which I have a 9 column grid. But when the form is run, the Grid shows 10 column (i.e one additional unwanted column at extreme right). Please see the attached Screen shot.

Second, I have used SQL to create a table and the table is the source for the above Grid.(Table Name Searchreport)
The Table is Order By Invoice No. Now, I am looking forward to do that when the user Clicks on the Header column, the Grid items shall be sorted by the header on which click is made.

Will I have to copy the same select statement statement inside Grids.header.click and refresh the Grid or there is some other trick also.

Harsh