QueryTree's advanced report builder comes with a selection of tools in the toolbar down the left hand side of the application, each of which does a unique job. You can connect these tools together in a chain to combine their effects. This page gives an overview of the tools that are available.
Getting the Data You Want
QueryTree has three different tools for loading data into the worksheet:
The Data Table Tool
The Data Table Tool lets you select a table from your database to load data in from.
Making Sense of the Data
QueryTree has a number of tools for manipulating and exploring the data on the worksheet:
The Sort Tool
The Sort Tool can sort data from its connected source tool based on a particular column.
The Filter Tool
The Filter Tool lets you trim data from its connected source tool down to only those values that you want.
The Join Tool
If you have two tables with with a shared or common column, for example, a County or City name, then the Join Tool can be used to glue those two tables together into one.
The Select Tool
The Select Tool lets you select which columns you want. If you've loaded some data in from elsewhere, the chances are you don't want all the columns that you've got. The Select Tool lets you pick which columns you want and in what order you want to see them.
The Append Tool
The Append Tool takes 2 or more input tables and appends them together one after the other. If the input tables have columns with the same name, then these will be merged together into one column.
The Statistics Tool
The Statistics Tool gives some statistics about the rows in your table such as the number of unique values and the overall total, average, minimum and maximum for columns containing numbers.
The Extract Tool
The Extract Tool can be used to extract a portion of the data in one column into a new column. It is useful for extracting parts of dates, sub-sections of text and separating out fields that are joined by delimiting characters such as colons or dashes.
Visualizing the Data
The Line Chart Tool plots a line graph. Select one of your columns to use as the labels on the horizontal (x) axis and then drag one or more columns into the list of data series to plot.
The Bar Chart Tool plots a vertical column graph. Select one of your columns to use as the labels on the horizontal (x) axis and then drag one or more columns into the list of data series to plot.