Define Formats for Standard Reports

Show/Hide All

Note This procedure does not apply to Sage 100 Premium.

Overview

Note This procedure applies only to the Material Requirements Planning and Work Order modules.

You can specify the fonts, style, and data elements to print on the header and footer sections of standard reports using Report Format Maintenance. You can also define the font and style for the body of the report, and add bitmaps to the header or background of the standard report. The settings that you define establish a report format.

You can define one report format per company code; a report format is not specific to user logon, workstation ID, or to the report. The only exception to this rule is the ability to override the font in the body of the report in the Printer Preferences window; this override is specific to workstation ID.

Note Dot matrix printers are not designed to print graphical reports and should not be used with this feature.

To define a report format

Select Library Master Setup menu > Report Format Maintenance.

Note Every report is divided into three sections: Header, Body, and Footer. By default, the header and footer use the Arial 12 point font and the body uses a variable size Times New Roman font.

Select Header > Company, Report Title, or Subtitles. Select settings in each window for the header. For more information, see Company Information (Header) - Fields, Report Title (Header) - Fields, or Subtitles (Header) - Fields.

Note The other windows accessed from the Report Format Maintenance Header menu are similar in format to this window.

Select Footer > Sys Date and Page or App Date and User. Select settings in both windows for the footer. For more information, see System Date and Page Number (Footer) - Fields or Application Date and User Information (Footer) - Fields.

Select Body > Font to define font, size and style settings for the body of the report. For more information, see Report Body (Report Format Maintenance) - Fields.

Select Bitmaps > Header or Background to add a bitmap. Bitmaps can be printed in the report header area and in the report background area. For more information, see Header Bitmap - Fields, or Background Bitmap - Fields.

In Report Format Maintenance, click OK to save your report settings.

Select Library Master Setup menu > Printer Preferences.

Select the Enable Graphics Printing for this Printer check box to print reports according to the format defined in Report Format Maintenance. The Use Graphic Report Format check box must also be selected on the User Maintenance Preferences tab. For more information, see Printer Preferences - Fields and User Maintenance - Fields.

Note The properties defined for each printer affect only standard reports and forms. These properties do not affect reports or forms created using SAP Crystal Reports.

In Printer Preferences, define the appropriate settings in the Normal Font and Compressed Font fields for the report body and click OK.

Note The body settings defined in the Normal Font and Compressed Font fields override the body settings defined in Report Format Maintenance.

Click Accept to print reports for the selected printer in the printer list box according to the format defined in Report Format Maintenance.