Your department frequently produces reports containing data from the same table. However, while you access the same table, you want to sort the data differently each time and you do not always print the same types of data. You create a dialog (which is a type of query) so that the person producing the report can change the sorting and printing instructions. Following is an example of how it appears:
SELECT 1?ITEM-NAME------- 2?ITM-ID-------- 3?SHIP-QTY-------- 4?UNIT-PRICE-------- FROM INVENTORY ORDER BY 5?ITM-ID--------
Because of the way you defined this dialog, people who execute it can sort by any column and print four columns of their choice, or they can use the defaults shown in the dialog. You limited their choices of sorts and columns when you defined the dialog, so you know the reports are standardized. You also entered site-specific fill characters to allow for entry.
|
Copyright © 2014 CA.
All rights reserved.
|
|