There are many ways to save work you do in GQL. This document describes the various ways to store query results, queries and report specifications for later use. The following topics are covered here:

• Saving query results
• Query results options
• Loading saved query results
  
• Saving queries
• Loading saved queries
  
• Saving report specifications
• Loading saved report specifications
  

Query Results

Saving Query Results

You may save the results of a query to a file. This query can not be re-run, only the results are saved. These results may be loaded back into GQL later, or loaded into another program, such as a spread sheet (there are also other ways to do this - see below). This may be done in two ways.

• If you haven't submitted your query yet
  1. Formulate your query, do not run it
  2. Select "Submit Query to File" from the "Query" menu
  3. Enter a file name for the query results, click "OK"
  
  
• If you have already submitted your query
  1. Select "Save Results" from the "Results" menu
  2. Enter a file name for the query results, click "OK"

Query Results Options

Loading Saved Query Results

You may load previously saved query results, and use these results to generate reports, crosstabs, etc.

1. Select "Open Results" from the "Results" menu
2. Select the previously saved results that you want, and click "OK"
3. You may now use these results just as you would use any query results

Queries

Saving Queries

You may save a query for later use. After saving a query using this method, you may load and submit the query again at a later time to get new results.

1. Formulate a query - it doesn't matter whether you submit it or not
2. Select "Save Query" from the "Query" menu
3. Enter a descriptive name for the query in the "Query Name" field
4. Click "Save"

Loading Saved Queries

You may load queries that you have previously saved.

1. Select "Load Query" from the "Query" menu
2. Select the query you want to load
3. Click "Load"
4. If you want new query results, submit the query

Report Specifications

Saving Report Specifications

You may save a report specification that you have created to be used with different queries that you run. This applies to "GQL Standard" reports, "Crosstab" reports, and "Labels". This allows you to spend a lot of time setting up a report to look exactly as you want it, then use it again later with other queries. You may also save complete queries, including the report specification. By doing this, you may load the query again later, submit it, and end up with the report exactly as you set it up.

1. Formulate and submit a query
2. Select "Show as Report" from the "Results" menu
3. Choose the type of report you are interested in - "GQL Standard", "Labels" or "Crosstab"
4. Format the report until it looks as you want it to
5. Select "Save Report Specification" from the "Report" menu
6. Enter a descriptive name in the "Report Name" field
7. If you will use this report only with this query, mark the "Save Query Also" box
8. If you will use this report with different queries, unmark the "Save Query Also" box
9. Click "Save"

Loading Saved Report Specifications

You may load reports that you have previously saved. This may be done in two ways. One way is to load a report that includes a query you saved. The other way is to create a new query, and use a saved report to display the new results.

• Load a report that includes a query
  1. Select "Load Query" from the "Query" menu
  2. Select the named query you are interested in
  3. Click "Load"
  4. Submit the query
  5. The report will be displayed
  
  
• Create a new query and use a saved report
  1. Formulate and submit a query
  2. Select "Show as Report" from the "Results" menu
  3. Select "Load Report Specification"
  4. Select the saved report that you wish to use
  5. Click "Load"
  6. The data results from your query will be displayed as the report you selected