FACTS Report Designer

Use the FACTS Report Designer to create custom report layouts. You can customize each report layout in these ways.

• Remove a field from the report
  
• Add a new field to the report
  
• Change column header titles
  
• Change which columns get totaled
  
• Change the width of fields and their header titles
  
• Change XML tags on a field-by-field basis for each layout
  

Once you create your own layout, you can name the layout and save it for easy access in the future. The layout can be a Personal or System layout and if desired, can be set as a user’s default layout. Report templates will indicate which layout you prefer.

To access this screen click Layout on the Customize Report (SMR999.U) screen. The system displays the report name, report format and tier at the top of the screen as the default.

You have these options.

Drag and drop fields—You can rearrange the fields in each tier.

Hide fields—To suppress fields from the report, right-click on the field and click Hide.

Add fields—To add fields, right-click on a blank area and click Select Field to Place Here. The system displays the Place Information Field Search screen where you can choose a field to add to the report:

Note: Most fields from the files that relate to the report will be available. For instance, the Customer Report can be modified to add almost any Customer File or Ship-To field.

Edit fields —you can edit fields by right clicking on the field and choosing Edit to display the Edit Field Attributes screen.

Open topic with navigation