WIP CEC
Introduction
The transport planning report contains information about the element marks, its dimensions, weight, area, and which stack number and truck the elements are placed on.
Report Setup
General report setup. All the fields have to be filled as it prints a sum row at the end of each page.
Page max X and Page max Y defined the maximum size of the report page.
The X-axis is the columns A, B, C etc. The Y-axis is the rows 1, 2, 3 etc.
Continuous Header Row defines in which row the header and footer start, and in this case, it starts from row 9.
Continuous Start Row (in this case from row 11) is where the main information starts and Continuous End Row (in this case until row 30) is where the main information ends.
If the last field is filled a summary for each page will be created at the end of the page.
Header setup:
Here is how the header is set up for this report.
As you can see we have different X and Y values for each field. This is done so the program knows where to put the specific information into the report.
As mention above, the continuous header starts at row 9 to row 10 in the Y direction.
Here are the fields that can be added to the Header and Footer:
Fields | Description |
ADDRESS_TABLE | |
BUILDING_OWNER_CITY | |
BUILDING_OWNER_NAME | |
BUILDING_OWNER_STREET | |
BUILDING_OWNER_ZIPCODE | |
BUILDING_SITE_CITY | |
BUILDING_SITE_NAME | |
BUILDING_SITE_STREET | |
BUILDING_SITE_ZIPCODE | |
CONTACT_EMAILADRESS | |
CONTACT_FIRSTNAME | |
CONTACT_LASTNAME | |
CONTACT_MIDDLENAME | |
CONTACT_NAME | |
CONTACT_PHONE1 | |
CONTACT_PHONE2 | |
CONTACT_PHONE3 | |
CONTACT_TABLE | |
CONTACT_TITLE | |
DELIVERY_CITY | |
DELIVERY_COUNTRY | |
DELIVERY_COUNTRYCODE | |
DELIVERY_DATE | |
DELIVERY_DESCRIPTION | |
DELIVERY_DISTANCE | |
DELIVERY_FAX | |
DELIVERY_LATITUDE | |
DELIVERY_LONGITUDE | |
DELIVERY_NAME | |
DELIVERY_NOTE_ID | |
DELIVERY_PHONE | |
DELIVERY_STREET | |
DELIVERY_STREET2 | |
DELIVERY_TEXT1 | |
DELIVERY_TEXT2 | |
DELIVERY_ZIPCODE | |
DRIVER_EMAILADRESS | |
DRIVER_FIRSTNAME | |
DRIVER_LASTNAME | |
DRIVER_MIDDLENAME | |
DRIVER_NAME | |
DRIVER_PHONE1 | |
DRIVER_PHONE2 | |
DRIVER_PHONE3 | |
DRIVER_TITLE | |
LOAD_DATE | |
LOAD_LOCATION | |
NO_OF_ADDITIONAL_ITEM | |
NO_OF_STACKS | |
NO_OF_VEHCILES | |
NOTE_HEADER | |
PROJECT | |
PROJECT_NAME | |
PROJECT_REGISTER_DATE | |
PROJECT_REVISION_DATE | |
PROJECT_SUMMARY | |
QR_CODE | |
REMARK_HEADER | |
REPORT_PAGE_NUMBER | |
REPORT_PRINT_DATE | |
SHIPPER_CITY | |
SHIPPER_COUNTRY | |
SHIPPER_COUNTRYCODE | |
SHIPPER_DESCRIPTION | |
SHIPPER_FAX | |
SHIPPER_LATITUDE | |
SHIPPER_LONGITUDE | |
SHIPPER_NAME | |
SHIPPER_PHONE | |
SHIPPER_STREET | |
SHIPPER_STREET2 | |
SHIPPER_TEXT1 | |
SHIPPER_TEXT2 | |
SHIPPER_ZIPCODE | |
TOTAL_ADDITIONAL_ITEM_MASS | |
TOTAL_MASS | |
TRANSPORT_DESCRIPTION | |
TRANSPORT_ID | |
TRANSPORT_NO | |
TRANSPORT_PICTURE | |
TRANSPORT_STATUS | |
TRANSPORT_TEXT1 | |
TRANSPORT_TEXT2 | |
TRANSPORT_TEXT3 | |
TRANSPORT_TEXT4 | |
TRANSPORT_USAGE | |
TRANSPORT_EMAILADRESS | |
TRANSPORT_FIRSTNAME | |
TRANSPORT_LASTNAME | |
TRANSPORT_MIDDLENAME | |
TRANSPORT_NAME | |
TRANSPORT_PHONE1 | |
TRANSPORT_PHONE2 | |
TRANSPORT_PHONE3 | |
TRANSPORT_TITLE | |
USER_DIVISION_CITY | |
USER_DIVISION_COUNTRY | |
USER_DIVISION_DESCRIPTION | |
USER_DIVISION_FAX | |
USER_DIVISION_NAME | |
USER_DIVISION_PHONE | |
USER_DIVISION_STREET | |
USER_DIVISION_ZIPCODE | |
USER_MOBILE | |
USER_NAME | |
USER_PHONE | |
USER_SIGNATURE | |
USER_TITLE |
Selection setup:
The standard setup for the selections.
Continuous setup:
The Continuous setup is where you set up all the information, in this case, about the Transport Planning.
As you can see, here you define only one row because this row will be the basis for this report, from row 11 to 30 as shown further up.
The fields you can add to this section are listed below
BOUNDING_BOX_AREA | |
CAST_START_DATE | |
DIVISION_NAME | |
ELEMENT_ID | |
ELEMENT_MARK | |
ELEMENT_TYPE | |
ERECTION_SECTION | |
ERECTION_SEQUENCE_NO | |
FACTORY_NAME | |
GROSS_AREA | |
HEIGHT | |
LENGTH | |
MASS | |
NET_AREA | |
NOTE | |
NUMBER_OF_ELEMENTS | |
PLANNED_DELIVERY_DATE | |
PLANNED_ERECTION_DATE | |
PLANNED_PRODUCTION_DATE | |
PRODUCT | |
PROJECT_TEXT_3 | |
REMARK | |
STACK_ID | |
STACK_LAYER_NO | |
STACK_NO | |
STACK_QR_CODE | |
STACK_SEQUENCE_NO | |
STORAGE_LOCATION | |
STYLE | |
VEHICLE | |
VEHICLE_TYPE | |
WIDTH |
Print report
From Transport Planning
This report can be printed from the Project Manager as shown here and also from the Resource Manager.
You right-click on a transport and select print "Transport Planning..."
Example
Download
You can download the report template here