1. Show Header Group Panel.
2. When create your SQL statement to go get the data just build your values into a 'description' column in the select statement, including what you would group on.
3. Retrieve the data using your SQL statement into an ADO recordset.
4. Set the gridname.recordset = yourRS
5. group the grid by the description column....
This is advance grid magic and not for the faint of heart.....you'll have to build the grid by hand for example....
We've even included a row of buttons across the top of the grid to allow the user to choose how they will sort and group the grid with the subtotals......and used recordset sorts (in the old days, SLX does this now for you if you have the user click on a header caption).
|