software

Tutorial 2

Adding grouping to the previous query

Sat, 01/30/2010 – 07:59 — brian

This tutorial will assume you now have a limited knowledge of the NuVu Query Designer, having worked through the first tutorial. After this tutorial you will have the knowledge to advise grouping on the sorted fields of a query, showing these as new total rows.

Perform the following steps:

  • If the Query Designer Tool is already running, please close it down. Invoke the NuVu Query Designer from the NuVu Query program group from the windows Start menu. The main NuVu Query Designer window will be displayed, and a welcome dialog window will also be displayed that shows recently saved/opened queries. We are going to create a new query from the original query (tutorial1), so double-click on the ‘tutorial1′ item that should be displayed inside the Welcome dialog window (if you have successfully performed the first tutorial and saved it as specified in that tutorial with a name of‘tutorial1′). The original query will open inside the Designer. We need to now save this as ‘tutorial2′ before we start working with the query, so click on theFile->Save As menu item and advise a new Query name of tutorial1 when the save properties are displayed.Click the  button to save the query with the new advised name.
  • Click the  (group) button to invoke the Group dialog window.
  • Once the Group dialog window is display, tick the options as shown below:
  • Click the  button to apply the changes to the query and close the dialog window.
  • Click the  button to start execution of the query. A dialog window will appear briefly indicating the various steps that are being performed. Once the query results have been retrieved, this dialog window will disappear and the results will be shown inside the grid on the designer window, as shown below:
  • Note the automatic treeview that has appeared to the left of the result rows, and total rows showing the Country and numeric fields all automatically totaled.
  • Finally we will save the changes made to this query (as this will form the base query for the next tutorial), so simply click the  button and close down the query tool.

We are complete with the tutorial. An exported query containing this tutorial is available by right-clicking here and choosing Save Link As (Firefox) or Save Target As (Internet Explorer) to save the query import format file to a file on your hard disk, and then importing that query into the query tool (hint: choose File->Import Query from the main menu of the Query Designer).

End of Tutorial