|
Query Window - Grid Results - Grids and
Grid Charts
Grid results displays data in tables 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
 |
 |
Click on
Header
|
Sorted Rows
|
Columns can be Rearranged
left to right by dragging them from one location to
another
 |
 |
Drag Column
|
Rearrange
|
Quick
Filter - 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
 |
 |
Before Filtering
|
Using Quick Filter
|
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
 |
Aggregate Functions
|
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
 |
 |
Script to
Window
|
Aqua Commands
|
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
 |
|
Save As |
View in Excel
Viewer - Displays selected data from the grid in
Excel or Excel Viewer
 |
Excel
Viewer
|
Grid
Printing - Allows printing of grid results. Print
margins are adjustable
 |
ADS Printing Options
|
|
