HP 3000 Manuals HP 3000 Manuals
The Tasks In this lesson you will enhance the report to provide a report that restricts information on the total sales in all areas to the board of directors only. Area sales managers must have a separate report that includes only those details that affect one sales area, not the data for all areas. But there must also be a report for the board of directors that prints details for all areas. Also, the report must be able to select either all customers or a subset of customers on which to report. Finally, you will add dollar signs to the values so that they are easier to read. This report will use more than two source tables in a table, access a subset of data, restrict data using parameters and selection sets, print a report heading and suppress the page heading, and use edit masks to print dollar signs and commas in numeric items. You will learn about BRW performance, selection sets and parameters. Performance Part of this exercise deals with tuning report performance using keyed access to HP TurboIMAGE/iX data sets. Even if you are not familiar with databases and KSAM files, you can use BRW to complete this lesson and generate some statistics that compare the speed of execution of the report with the speed of a COBOL program running a similar report.