REPORT GENERATOR (Requires UPS Connect CX32)

To use the Report Generator, select Report Generator from the UPS Connect folder in the Programs Menu of Windows95. 

When the Report Generator opens, a blank Shipment Data screen will be displayed. Lets look at the menu bar options to understand the functionality of the Report Generator.

File allows you to: 
Create a New Report Style.
Open an existing Report Style.
Save the Report Style currently being worked on.
Exit Report Generator.

Setup allows you to:
			Setup a report structure.  Click on Setup Report Settings

Print allows you to:
			Print a report.  Click on Print Report

Creating a new Report

STEP 1 - Open a new report file 

Select New Report Style from the File menu.  Click on Yes to continue.  Select the fields to be included on the report by double clicking field name on the left side of the Shipment Data screen.  Use the vertical scroll bar to navigate through all the available fields.

STEP 2 - Select Fields to appear on the Report.

Select the shipment data fields that will appear on the report from the list on the left of the screen by double clicking on the field. Note: The shipment data is the primary data and is required to create a new report. A FORMULA field is also available. This field allows for the creation of formulas using other fields in the database. It is not required for the fields in the formula to appear on the report and as many formula fields as you wish may appear on the report.
To include either Package or Invoice data in a report, click on the appropriate check box at the bottom of the screen. This will display a panel on the report for the respective selection. The report can also be set to display voided shipments as an option.
Package Data contains optional package level information and Invoice Data consists of commercial invoice information required for Customs.
To add package or invoice data to the report, select the appropriate tab and similarly select the fields you wish to appear on the report.

To move the fields within the report, click on any field and use the ^ v buttons to move the field up or down on the report.





STEP 3 - Formatting fields that appear on your report.

COL - Identifies the column position of the field on the report.

FMT - You can format a field selected by clicking on the FMT button.  A pop up panel will                    appear with Set Options to choose from:
* The type of total for the field, either the count of occurrences or a sum of field values.
* Hidden details so that only totals are shown. 
* Format how data is displayed and view how the data changes with each selection in the example box at the bottom of the panel.
* Set the width of the field on the report. The data will truncate to the set width.
* Set the justification of the field values and field header.

FIELD NAME - This field identifies the name of the field selected for use in the report.

DESCRIPTION - In this field a name for the field that will appear on the report can be entered. The Field Name is the default and will appear on the report unless another name is entered.

FILTER/FORM - This field is optional. A pop-up panel will appear if this field is clicked upon with options to set a filter for the field. This function also has a check feature, which tells if filters are valid.

ORDER - The report can be printed in ascending or descending order based on a
specific field by selecting the order in this column for the respective field.
The default sort order is NONE.

TOTAL - If a total for a particular shipment data field is required, first select the type of total in the FMT pop-up and click on the respective field in this column. The field will be totaled if this box is checked. 

DEL - Clicking on this column for a respective field will remove it from the report

Group Report By
You can group the report by any selected field in the report.  Click on the drop down box under Group Report By and select the field you wish to group by. 

STEP 4 - Structuring the Report. 

The Setup screen allows you to create the report header lines and select report options to add value.
   
Select Setup from the menu.
Click on Setup Report Settings.  
You may type up to three header lines.  Select one or all of the Print options.  The Package and Invoice Line Indents are used to offset where the package and invoice data prints in relation to the Shipment data on the report.  The report can be defaulted to print the Company Name and UPS Account entered in the UPS Connect shipper profile by clicking settings under Special Headers.  Your Company Name and UPS account number will be displayed on header line 2 and Print Date range on header line 3. 

When the settings have been selected, click on OK to return to the Shipment Data screen.


.

STEP 5 - Saving the report.

Once the report is structured and the fields are formatted in all of the selected tables the report can be saved. Simply select File from the pull down menu and select Save Report Style. 

Printing Reports

STEP 1 - Select File from the pull down menu and select Open Report Style. 

STEP 2 - Select the report to be run and click OK.

STEP 3 - The report selected will appear in the Report Generator Create Screen. Modifications may be made to the report or select Print from the pull down menu.

STEP 4 - Enter the date range for the report.
 
STEP 5 - Select the number of copies to print, fast reports (see below) and landscape mode if needed.

STEP 6 - Select Print to send report to the printer or Print Preview to view the report on screen.

To speed up printing Fast Reports can be selected. Fast Reports reduces the amount data sent to the printer by eliminating lines and other graphics. The only data printed is from the fields selected. 

