Difference between revisions of "Query Results"

Revision as of 17:46, 19 September 2013

This topic is for AquilaCRS

(TODO: Work in progress)

Introduction

The query results are divided into two sections: the data table and the pivot table.

Results Data Table

Query results are presented in a data table which allows local filtering, sorting and grouping.

See the Data Tables topic for more details on sorting, filtering and grouping.

Record Limits

For speed of response, only the first 200 records of any query are returned. To return more, or all records, select View > Max Records and set the appropriate value.

Transferring large amounts of data across the network can result in slow response times or time-outs. Try to restrict your results by carefully entering your Query Filter and selecting only the necessary fields in the Output Field list.

Exporting data

From version 1.2 users will need the Export permission in order to take data out of the database

Excel

Menu: Export > Export to Excel...

Since version 1.1.8 it is no longer necessary to have Excel installed on your machine in order to export to Excel.

Selecting this menu option will prompt you for a folder and file name, and also a file type that is equivalent to the different versions of Excel files.

Navigate to your required folder and enter a meaningful filename & press OK.

Once the export has completed Windows Explorer will be opened with your file highlighted. If you have Excel installed you can double click to open the worksheet directly.

CSV (Comma Separated Values)

Menu: Export > Export to CSV...

The CSV format is a commonly used data inter-change format. Exporting to CSV can be used when you need to import the data into a database or spreadsheet product other than Excel.

The data is exported in a format similar to this snippet (with headers):

 "UK Postcode District","Year","Month","Injury Week"
 "SK3","1987","5","16"
 "SK9","2002","5","16"

When choosing to export to this format you are prompted to set specific values for the delimiter, separator and other values:

Select the folder & file name. Generally you will leave the remaining options as is, unless you have a specific requirement. Press OK to export.

Once the export has completed Windows Explorer will be opened with your file highlighted. You can now work with your file independently.

PDF

Menu: Print > Report to PDF

Use this option to create the PDF file from the currently displayed data table.

Menu: Print > Report Page Setup

Use this option to adjust page sizes, orientation, etc.

Menu: Print > Report Preview

Displays a preview of the PDF output on screen. Use this option to check the output is correct before saving to PDF.

Results Pivot Table

(TODO: Pivot Tables)