Add Advanced Query Columns

You can add, expand, or remove columns. You can also drag and drop any column header to any position in the grid.

The best fit function resizes the columns to best fit the information entered. To size a single column, right-click inside the desired column header, then click Best Fit. To size all of the columns at once, right-click inside the desired column header, then click Best Fit (all columns).
  1. On the Reports tab, click Advanced Queries.
  2. In the Report Menu, select the query you want to change.
  3. In the Actions group, click Run.
  4. The query results display. Right-click inside the column header, and click Column Chooser. The Customization window displays in the bottom right corner of the page.
  5. Double-click the column name you want, or drag and drop the column name to the correct position in the grid. You can drag and drop any column header to any position in the grid.
  6. Close the customization window.
After adding query columns, you can expand them by holding your cursor over the section divider, then dragging them to the desired size. You can also removed unneeded columns.