In this section: How to: |
This section contains three examples of how you would use a HOLD file:
Note: Across fields are not allowed in HOLD files.
This procedure describes how to extract fields into a HOLD file and then create multiple components in a document from the HOLD file.
You can store virtual field values, or summary values, calculated in one request for further processing in another request, as the following procedure illustrates.
Complete the procedure steps to create a tabular report showing Quantity of Items Sold per Product Category, By Region, Across Years. Include a column that shows percentages within region.
Two join tables are joined.
The report is complete.
The following procedure describes how to create a HOLD file for use in a subquery.
For example, the report shown in the following image lists Customer IDs with Gender equal to Female.
The File File & Printer button is found on the Home tab, in the Format group, and on the Format tab, in the Destination group.
The File File & Printer button is a split button. Click the left side of the button to launch the Save dialog box. The down arrow on the right side also opens the Save dialog box so you can change settings or set them for the first time.
An example of the File File & Printer button and the associated ToolTip are shown in the following image.
The Select a location and format Temporary dialog box opens, as shown in the following image.
Note: The label Temporary appears at the top of the dialog box. When you select a folder, the label changes to Select a location and format, as shown in the following image.
The File & Printer Options dialog box opens, as shown in the following image.
The default file name is File1.
The location is either Temporary, which is the default, or a writable server application folder.
Note: If the HOLD file name already exists in the specified location, it will be overwritten without warning, when you click Save.
The Create Report button appears on the bottom of the InfoAssist Live Preview application window, as shown in the following image.
The following image is an example of the Live Preview application window when Create Report is selected.
Note: When you are working with a report created from a HOLD file, if you try to switch data sources, or add data sources to the report, you are presented with warning messages.
For more information, see InfoAssist Warning Messages.
FOCUS is the only format that supports an index field. The maximum number of fields to index is four. If the file format is FOCUS, then Index appears on the Query pane, as shown in the following image.
WebFOCUS |