Create a Sales Analysis Report
(SABRE Report Entry)
Access
Tabs: Heading,
Sorting, Details, Selection,
Columns
Use this routine to create customized
reports detailing sales data on various aspects of your business.
Then, you can use the
Report NameEnter the name of the report
you want to create or edit. If you click on the Search button, a list
of existing reports appears from which you can choose.
To copy criteria from an existing report to a new report, enter the name
of the new report and then click the Actions
button on this screen to access the Business
Analysis Report Merge Screen.
Report Width
Heading
Heading Line 1Enter
a heading or description of the report. This is a required field. The
heading you enter here appears at top of the report. The system
also uses this field as a description of the report when it appears on
lookup screens.
Heading Line 2Enter
a second heading or description of the report. This is not a required
field. The heading you enter here appears at top of the report,
beneath heading line 1.
Sorting
The settings on this tab determine the highest levels of organization
in the report.
Sort FieldSelect
the field you want to use as the sort criteria for this report. If you
click on the Arrow, a list of sort criteria appears from which you can
choose.
Sort Order
Alignment
BreakTo print
subtotals each time the sort criteria changes, check the box. Otherwise,
leave the box blank.
Note that break points do not show on the report if you output to Excel.
PageThis field
is active only if you check the box at the Break field. To page
break each time the sort criteria changes, check the box. Otherwise,
leave the box blank.
To add the sort criteria to the grid, click the Add
button. To add another sort to this report, select another criterion
from the Sort Field.
Details
The settings on this tab determine the lowest level of organization
in the report. Use this tab to define the field whose details (listed
in the columns) you want to report on. You can define only one detail
field.
Detail FieldSelect
the field you want to use as the detail information for this report.
ColumnIf you
select Rank at the Type field, enter the Column number you want to use
when ranking columns in the report.
KeyEnter
the width of the Detail Field column.
DescriptionEnter
the width of the Detail Field column's description.
Type
Sort Order
Alignment
Selection
Use this tab to restrict the information that appears on the report
(as well as in any calculations) to a selected criterion, for example
one or more products. You specify either a list or range. You
can specify multiple select criteria.
Select FieldSelect
the criterion to which you want to restrict the output for this report.
If you click on the Arrow, a list of selection criteria appears
from which you can choose.
Type
Columns
Use this tab to define the columns on your report.
Column ID
Column Header 1Enter
the first line of the description you want to appear at the top of this
column on the printed report. You can use as many characters as
specified at the Column Width field.
Column Header 2Enter
the second line of the description you want to appear at the top of this
column on the printed report. You can use as many characters as
specified at the Column Width field.
Print on ReportTo include
this column in the printed report, check the box. To exclude the
column (but save it for future use), leave the box blank.
Column WidthEnter
the width of this column.
Scaling Code
To include the column settings in the grid, click the Add
button. The Column
Detail Maintenance screen displays.