Sometimes you just want to see the results of a report without needing it formatted nicely. The fastest way to see the results is to output to a Data Grid. Click the Data Grid button in the ribbon or the toolbar, choose Data Grid from the File menu, or right-click a report and choose Data Grid from the shortcut menu, to retrieve the data from the report and display a data grid dialog.

The dialog has the following features:

  • If there's a memo field in the data grid, its content for the selected record is shown at the bottom of the dialog. If there's more than one memo field, the content of the selected memo is shown.

  • You can resize a column by dragging the vertical bar at the end of its column header left or right.

  • You can auto-size a column by right-clicking its column header and choosing Auto-size This Column from the shortcut menu. When you resize the dialog, that column is automatically resized.

  • You can auto-fit the columns to match the currently displayed records by right-clicking any column header and choosing Auto-fit Grid from the shortcut menu.

  • You can rearrange the columns by dragging a column header left or right.

  • You can sort a column by clicking its column header. appears in the header indicating the column is sorted in ascending order. Click the header again to sort in descending order and display .

  • Type some text in the search box near the bottom and click the button to find the first record containing that text in any field. Click that button again to find the next record.

  • Type some text in the search box and click the button to filter on that text.

  • Click the button to clear the search and filter.

  • Click the button to output to Microsoft Excel.

  • Press the Home key to jump to the first record or the End key to jump to the last one.


© Keystroke.ca, 2022 • Updated: 12/08/21
Comment or report problem with topic