Query Window - Grid Results - Grids and Grid Charts

Grid results displays data within a grid that can be sorted and rearranged.

Column data can be sorted in descending or ascending order by left clicking on column headers.

Columns can be rearranged left to right by dragging them from one location to another

There is a quick filter on the grid with which you can focus on a particular field. When you type in the quick filter, an "X" appears at the end of the filter that erases the text entered when it is click on. You can also produce a chart of the filtered data the same way that you produced a chart of the whole block of information.

Aggregate Functions - Aggregate Functions allow users to calculate Count, Count Numbers, Sum, Min, Max, Average, and Standard Deviation functions on the grid data highlighted.

Once data has been highlighted in the grid, right click on the Aggregate Functions button at the top right of the grid. Choose the desired function and its results are displayed within the button itself.

Script to Window - Automatically generates Aqua Commands for the pivot grid/pivot chart for exporting by right clicking within the grid view. This Aqua Command will include all of the settings of the grid/graph display. If these settings are stored with a query, users can reexecute and generate the same grids and graphs again as many times as needed.

By using "Save As" from within the query toolbar, it is possible to save the query and Aqua Commands together in a shared directory so that multiple users of Aqua Data Studio can access the layout and results.

View in Excel Viewer - Displays selected data from the grid in Excel or Excel Viewer

Grid Printing - Allows printing of grid results. Print margins are adjustable.