Production Reporting provides a library of sample Production Reporting programs you can use to customize and experiment with. If you installed Production Reporting in the default directory, the sample programs are in:
C:\Hyperion\products\biplus\docs\samples\Production Reporting
Modify these programs any way you like to create customized Production Reporting reports.
Table 90 lists the sample Production Reporting programs and provides a brief description of each. Each program consists of a report specification and a sample of the output.
Table 90. Production Reporting Sample Reports
Data files used by the LOADALL.Production Reporting programs | |
Startup files to run tiny, medium, and big Production Reporting programs | |
Prints a graph of the forecasted and actual sales for a given employee | |
Prints a graph of the forecasted and actual sales for month or quarter | |
Prints a graph of the planned and actual sales for a given employee | |
Prints a graph of the planned and actual sales for month or quarter | |
Uses Production Reporting to input data from user, enter data in the database, and write a form letter using a DOCUMENT paragraph | |
(Oracle) Creates stored functions and procedures for Oracle Version 7 | |
Demonstrates the use of the ON-BREAK argument to the PRINT command | |
Demonstrates the use of the INPUT command to change report output | |
Demonstrates dynamic queries to allow user to qualify a report as it runs | |
Prints and charts on a bar chart information about each customer in the customer table | |
Demonstrates the flat file output for magnetic tape or other post-processing | |
Drops all the Production Reporting sample tables created by the LOADALL program | |
(Sybase) Deletes leftover temporary stored procedures belonging to the user | |
Demonstrates use of dynamic columns, dynamic tables and variables passed to ON‑ERROR procedure | |
Creates two Production Reporting reports: one to export a database table, the second to import that table. Data from the table is stored in an external operating system file in compressed format, with trailing blanks removed. | |
Creates a Production Reporting report to extract a database table and place it into a flat file | |
Sales forecast for given customer grouped by month or quarter | |
Sales forecast for given employee grouped by month or quarter | |
Sales forecast for given product grouped by month or quarter | |
Creates a table of projected product sales with links to more information | |
Creates an Production Reporting program to display rows at your terminal selected from a database table you specify. The resulting Production Reporting program prompts you to qualify rows to be selected, display those rows, then repeat. | |
Demonstrates multiple reports, printing invoices, and printing envelopes | |
Creates and loads sample tables used in the above Production Reporting programs Note: The sample tables are in ASCII format. As a result, you must specify a valid ASCII-derived encoding value in SQR.INI. For more information on encoding values, see Encoding Keys in the [Environment] Section. | |
Lists all the orders and the orderlines associated with them | |
List all orders for a given month and group them by employee number | |
Creates a report of all orders from a given region grouped by month or grouped by quarter | |
Prints a graph of the percent of orders for each region (in a year) and four graphs of the percent of orders for each region (one for each quarter of that year) | |
Demonstrates printing within columns, page headings, and page footings | |
List of products and their prices and a graph of orders of products | |
Demonstrates charting from stored data and printing several charts on one page | |
(Sybase) Shows any leftover temporary stored procedures belonging to the user | |
Creates a tabular Production Reporting report for a table you choose | |
Generates an Production Reporting program that allows you to query and update database tables. The created program uses the SHOW command to simulate a menu interface. | |
A sample report that demonstrates use of stored functions and procedures in Oracle |