Advanced Report Builder Tools


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:

Data TableThe Data Table Tool
The Data Table Tool lets you select a table from your database to load data in from.
More Info

 

Making Sense of the Data

QueryTree has a number of tools for manipulating and exploring the data on the worksheet:

SortThe Sort Tool
The Sort Tool can sort data from its connected source tool based on a particular column.
More info.

 

FilterThe Filter Tool
The Filter Tool lets you trim data from its connected source tool down to only those values that you want.
More info

 

JoinThe 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.
More info

 

SelectThe 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.
More info

 

AppendThe 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.
More info

 

StatisticsThe 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.
More info

 

ExtractThe 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.
More info

 

Visualizing the Data

Line ChartLine Chart
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.
More Info

 

Bar ChartBar Chart
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.

More Info