Report Settings

To access this dialog select File|Printer Setup|Report Settings from the main menu. This dialog will also appear just before report printing commences.

Use this dialog to print reports, preview reports, export report data to external applications, and transfer reports to Microsoft Excel using OfficeLink.

Date To Appear On Report

The date to appear on the top of printed reports. To choose the current date click on the field and press the F2 function key.

Starting Page

The first page to start printing from.

Last Page

The last page to print to .

Copies

The number of copies to print of a report.

Top Margin

The top margin specified in lines. On a report using A4 paper there are typically 64 lines per page, however this may vary by printer.

Bottom Margin

The bottom margin of the page specified in lines.

Printers

This is a list of available printers to choose from, to print to. Consult your Windows documentation on printer set-ups for information on adding or removing printers from the list.

Properties...

Change printer driver settings.

To permanently change settings for a printer, select Printers from the Windows Control Panel.

Preview

Click on this button instead of Print to preview the report to screen. You may still print the report if you wish, after previewing it.

OfficeLink

Click on this button to transfer the report to a Microsoft Excel spreadsheet. You must have Microsoft Excel installed on your computer for this to work.

For more information on the spreadsheet transfer feature see the topic: OfficeLink.

Exporting Report Data

The report printing dialog can be used to export data to external applications. To export data start by clicking on Print to File and then press Print. You will now be able to specify the file type to print. Choose this from the Save File as Type list.

Many common data formats are supported, including:

.PRN
ASCII text report
ASCII comma delimited
ASCII SDF
ASCII tab delimited
ASCII user delimited
dBase III (DBF) File Format

Only use the .PRN format if you wish to copy/print the file directly to your printer at some later date. The ASCII text report format is a "mirror image" text listing of the report and can be used when you wish to load report data into desk top publishing or word processing software.

The other formats are typically used for loading into spreadsheets or linking to database applications. Most, but not all, reports are available in these other formats.

The User Delimited Format allows you to specify a unique field delimiter in place of comma or tab. This delimiter must be specified in your CAPWIN.INI file in the [Export] section, as follows:

[Export]

Delimit=014

In the above example, the number 014 is the ASCII code for the delimiter to use.

____________________________