![]() The Filter menu button in the grid toolbar contains all operations related to using a filter. You can use the filter capability in the Data tab to limit the number of rows shown in the grid, using the same syntax as for an SQL WHERE clause. By clicking the blue link, the Data Formats section of Tool Properties will be opened. Note that when a cell is selected, the format pattern used to display the cell value is visible at bottom of the grid. The grid is then sorted on the values in the first column you clicked on (indicated with a 1 next to the arrow), and then all rows with the same value in the first column are sorted on the values in the second sort column (indicated with a 2 next to the arrow), and so on. To sort on more than one column, Ctrl-click (keep the Ctrl key pressed when clicking) on additional columns. Click a third time to show the data in the order it was received from the database.Click the same column header again to sort in descending order, indicated by a down-arrow in the column header. ![]()
0 Comments
Leave a Reply. |