Screenshots

The following screenshots show how the same Info/Access report is formatted to display in various common programs. The Info/Access command used to generate the output is shown beneath image.

In general, the only difference between the commands is the verb used to initiate the report.

mvTerm

SORT WOOL.SUMMARY BY WREG BY COUNTRY BREAK-ON START.END.I "'UV'" BREAK-ON WREGION.I "'UV'" COUNTRY TOTAL 10 TOTAL 11 TOTAL 12 TOTAL 13 TOTAL 33 TOTAL 13% GRAND-TOTAL "Rubbish'U'" HEADING "Wool Exports From New Zealand'L'Calendar Year: 2004'L'" FOOTING "T-S Tc WoolStats.6-2'LD'" ID-SUPP

This is a standard Info/Access report.

Excel

SSPREAD WOOL.SUMMARY BY WREG BY COUNTRY BREAK-ON START.END.I "'UV'" BREAK-ON WREGION.I "'UV'" COUNTRY TOTAL 10 TOTAL 11 TOTAL 12 TOTAL 13 TOTAL 33 TOTAL 13% GRAND-TOTAL "Rubbish'U'" HEADING "Wool Exports From New Zealand'L'Calendar Year: 2004'L'" FOOTING "T-S Tc WoolStats.6-2'LD'" ID-SUPP

This uses the 'SSPREAD' verb instead of the standard 'SORT' verb.

Open Office

This is identical to the command used for Excel, but uses a switch in the configuration file to generate output more appropriate to Open Office.

Web browser

SHTML WOOL.SUMMARY BY WREG BY COUNTRY BREAK-ON START.END.I "'UV'" BREAK-ON WREGION.I "'UV'" COUNTRY TOTAL 10 TOTAL 11 TOTAL 12 TOTAL 13 TOTAL 33 TOTAL 13% GRAND-TOTAL "Rubbish'U'" HEADING "Wool Exports From New Zealand'L'Calendar Year: 2004'L'" FOOTING "T-S Tc WoolStats.6-2'LD'" ID-SUPP

This uses the 'SHTML' to direct output to a web browser format.

RPV reports

SRPV WOOL.SUMMARY BY WREG BY COUNTRY BREAK-ON START.END.I "'UV'" BREAK-ON WREGION.I "'UV'" COUNTRY TOTAL 10 TOTAL 11 TOTAL 12 TOTAL 13 TOTAL 33 TOTAL 13% GRAND-TOTAL "Rubbish'U'" HEADING "Wool Exports From New Zealand'L'Calendar Year: 2004'L'" FOOTING "T-S Tc WoolStats.6-2'LD'" ID-SUPP

This uses the 'SRPV' verb to direct output to an RPV Reports format.