Batch program called REF ORMAT that reformats the data according to the REFSPEC formatting speci￿cations and writes it to a ￿le for use b y an application.

Set of intrinsics that pro vides a powerful programming language in terface to terminals, using FORMSPEC de￿nitions, from applications written in an y of the supported programming languages.

Report Generation Tools

Several useful report generation tools are a vailable. These are described in the subsections below.

Business Report Writer/XL

Business Report Writer/XL facilitates report dev elopment and execution. It is a men u-driven report writing system designed to streamline the dev elopment and maintenance of large production reports.

Its capabilities include on-line report formatting, rotational views of data, m ultipass reporting, advanced calculations, and performance tuning. It pro vides access to TurboIMAGE/XL, databases, MPE ￿les, and KSAM ￿les. Business Report W riter/XL, together with System Dictionary/XL or Dictionary/V transparen tly resolve data de￿nitions, structures, and access paths.

Business Report Writer/XL execution programs are part of the MPE XL F undamental Operating System (F OS). Reports developed on Business Report W riter/XL can be run on other HP 3000 systems without access to Business Report W riter/XL or a dictionary . By using intrinsics with user-speci￿ed parameter v alues, you can run reports from applications written in other languages. Business Report W riter/XL contains a conversion utilit y to automatically translate Report/V programs in to Business Report Writer/XL. For detailed information, refer to Business Report Writer/XL Reference Manual.

Report/V

Report/V is a non-procedural report writing language operative only when MPE/iX is in Compatibilit y Mode. It includes a high-lev el language that creates reports, a compiler, and a processor to execute the reports. It pro vides access to TurboIMAGE/XL databases, MPE ￿les, and KSAM ￿les. More adv anced reporting capabilities are a vailable in Native Mode through Business Report W riter/XL, whic h can automatically translate Report/V programs. For detailed information, refer to Report V Reference Manual (32245-90001).

HP Visor

HP Visor is a terminal-based in terface to HP SQL/V and ALLBASE/XL (HP SQL) databases. It allows end users or database administrators to perform queries and generate their own reports, without in volving a programmer. It pro vides facilities for programmers to use in precon￿guring complex tasks or to impro ve productivity when working with HP SQL databases.

HP Visor has a forms-based in terface that allows the user to mark bo xes and press function keys to step through tasks suc h as queries or custom report generation. It also pro vides additional capabilities for experienced users to directly en ter HP Visor or SQL commands.

Three modules are in tegrated with the HP Visor in terface.

2-6 Utilities and Tools