Advanced Queries
21.1 Advanced Queries
21
21-11
To return to the full list of instruments in the database, you must perform the following
steps:
1.
Return to the ADVANCED QUERY screen.
2.
Once in the ADVANCED QUERY screen, click the Reset button.
3.
Once the query details are cleared from the screen, click the Execute button. The list
generated will once again include all records in the system for the company.
Another option is to exit out of the screen and reopen the screen.
21.1.5 Printing Lists and Saving Them to External Files
Any list generated in DPCTrack2 may be printed and/or saved to an external file allowing
you to distribute them manually, via paper, e-mail, etc. To do this, pull up any list of
records on your screen and right-click anywhere on the list with your mouse. This will
invoke a dialog box with four different options, “Save To Excel Spreadsheet”, “Save To
Text File”, “Print” and “Print Setup”.
Selecting one of the first two options will enable you to save the list in either format in a
selected location. Save the file under a unique name, then access and utilize it as desired.
Selecting “Print Setup” will invoke the PRINT SETUP screen. In the PRINT SETUP
screen you can change the size, style and color of the fonts in both the report’s header and
footer. To do this, click the Edit Font buttons in those sections of the screen. The list,
when printed, will appear exactly as it does on your screen. Therefore, you may decide to
increase or decrease the widths of the columns shown in the list. Select a different
number from the “Column Spacing” section’s drop-down list. As you select different
numbers, “ColA”, “ColB”, etc. will change positions to illustrate how the list will look
when printed.
You may also select additional data to be included in the report’s header and/or footer.
Highlight any of the items listed in the “Available” boxes and use the center arrow keys
to move them to the desired “Displayed” boxes. Selecting “Other” will invoke the INPUT
FORM screen in which you may type additional information to be shown in the printout’s
header or footer.
To save your print settings, click the Set as Defaults button, then click OK. Once you are
back in the list screen, click the Print button and proceed as you normally would when
printing a document from your computer. Your print settings will remain as you
configured until you modify again.
21.1.6 Using Advanced Queries in Other Parts of the Program
Once you have built and saved advanced queries, they become available for reporting
purposes. To do this, select a report to run, enter any required parameter values, click the
Advanced Selection
tab then choose a query to report with. (See Chapter 23 for more
information about using advanced queries with reports.)
Shop for Fluke products online at:
1.877.766.5412
www.
MyFlukeStore
.com
