The Save Query Results with Document dialog box displays all of the query sections and computed columns contained in your document. Use this dialog box to specify whether to save the results set of your query with your document, and whether to save computed column expressions by section as a snapshot.
Saving results with your query allows you to analyze and generate reports without being connected to the database. Results are saved for an individual query or for multiple queries for which results have been generated. You also can specify whether to save any computed columns in the results set as a snapshot with the document.
Saving your results set makes sense if you cannot connect to a database, for example, when traveling or working remotely, or if you are scheduling or forwarding documents for someone else’s use.
You cannot choose to save computed columns as snapshots unless you first choose to save the corresponding query results.
If you intend to work with a document that includes a Report Designer section, you must save results with the document. If you do not save results with the document, the Report Designer section is not available. |
To save results with your document:
Select File, then Save Query Results With Document.
The Save Query Results With Document dialog box appears and displays all of the query sections contained in your document.
In the Query Results pane, select the check box next to the query results to save OK.
In the Computed Columns pane, select the section with the computed column to save as a snapshot.
The query results and snapshots for computed columns are automatically saved the next time you save the document.
Computed values saved as snapshots are not recalculated when the document is opened. Not even dynamic expressions (for example, values that reference the sysdate function such as date or time) are recalculated. They are recalculated only when the query is reprocessed. Documents that are saved with computed columns as snapshots tend to be larger in size than documents that do not contain snapshots, but they take less time to open.
To save the computed columns with the document, do not check the Computed Columns field.
To automatically recalculate the values of computed columns when a document is opened, do not select the corresponding results section in the Computed Columns list. The document may take longer to open, especially if the results set contains a large number of computed columns or uses complex formulas in the definitions, since all computed values are recalculated in the Results section and in any other section that references the Results section. On the other hand, documents that do not contain snapshots tend to be smaller in size than documents that contain snapshots of computed columns.
The following table lists the selection options and effects for saving query results and snapshots of computed columns with documents.
Table 32.
| Save Query | Save Computed Columns (as Snapshot) | What Happens |
|---|---|---|
| Selected | Selected | Results are saved with the document and computed columns are saved as a snapshot. Computed columns are not recalculated when the document is opened. Values are recalculated only when the query is reprocessed. |
| Selected | Not Selected | Results are saved with the document but computed columns are not saved as a snapshot. Computed columns are recalculated when the document is opened. |
| Not Selected | Selected | either Results nor computed columns are saved with the document. |
| Not Selected | Not Selected | Neither Results nor computed columns are saved with the document. |
Note: | You cannot save computed columns as snapshots unless you first save the corresponding query results. |