Difference between revisions of "Query Results"
(Added more export options) |
|||
| Line 9: | Line 9: | ||
| − | + | = Results Data Table = | |
Query results are presented in a [[data tables|data table]] which allows local filtering, sorting and grouping. | Query results are presented in a [[data tables|data table]] which allows local filtering, sorting and grouping. | ||
| Line 17: | Line 17: | ||
See the [[Data Tables]] topic for more details on sorting, filtering 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. | 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. | ||
| Line 25: | Line 25: | ||
''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 the Database|Query Filter]] and selecting only the necessary fields in the [[Query the Database|Output Field list]]. | ''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 the Database|Query Filter]] and selecting only the necessary fields in the [[Query the Database|Output Field list]]. | ||
| − | + | == Exporting data == | |
''From version 1.2 users will need the ''Export'' permission in order to take data out of the database'' | ''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...'' | Menu: ''Export'' > ''Export to Excel...'' | ||
| Line 41: | Line 41: | ||
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. | 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...'' | Menu: ''Export'' > ''Export to CSV...'' | ||
| Line 61: | Line 61: | ||
Once the export has completed Windows Explorer will be opened with your file highlighted. You can now work with your file independently. | 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'' | Menu: ''Print'' > ''Report to PDF'' | ||
| Line 76: | Line 76: | ||
| − | == Results Pivot Table | + | ==Results Pivot Table = |
{{todo|Pivot Tables}} | {{todo|Pivot Tables}} | ||
Revision as of 17:47, 19 September 2013
This topic is for AquilaCRS
(TODO: Work in progress)
Contents
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.
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)
