When a DQL Mode query or dialog selected for online execution specifies totals of one or more numeric columns, you can alter the appearance of the query output in one or all of these ways:
Note: Some alterations can also be made on the Batch Execution panel when initiating batch execution.
The query specifies which numeric columns are totaled and subtotaled. A query can produce other kinds of calculation results, like sums, counts, averages, maximums, and minimums of report columns.
All of these calculations are optional and therefore you should not expect each query to work the same. If you are unsure about what kind of report a query produces, run a test. Execute the query online and experiment with the output PF keys and commands to see what kinds of numeric results are available. Your CA Dataquery Administrator should also be able to assist you.
|
Copyright © 2014 CA.
All rights reserved.
|
|