(Repeated Thread)

Taken Some Data In a Cursor 'SEARCHREPORT ' using Select command,I have designed a GRID. The GRID initially displays all the records. The Total of the column is also displayed at the end/bottom of the grid..

Now, I have a combo which has DISTINCT Excahnge Codes. I need that when the user selects any one of the exchange code from the combo the GRID Items should Changed
accordingly and should display only the records pertaining to that Exchange code. The amount at the bottom should also change accordingly.


In order to do so, I placed the following Code in Click Method of combo

SET FILTER TO EXCHANGE=ALLTRIM(This.Value)
 SUM(AMT) to C for Exchange=ALLTRIM(This.Value)
Thisform.Grid1.Refresh

But the things are not working. I googled a lot but could not fetch a proper solution. While I was Googling, I encountered that in such cases the Grid Losses its original Formatting, How to overcome this problem ? Kinldy also tell that if I want that the first element of my combo box should be "All Exchanges"."

All Exchanges" is Not any of the exchange and therefore Not is the DISTINCT List, Currently the fisrt element is the name of one of the exchange.

Kindly Guide on the above three Problems