Transport with Picture

Last modified by Dennis Knudsen on 2023/05/22 11:20

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. 

Production report that can be printed from the Transport Planning.

Report Setup

General report setup. All the fields have to be filled as it prints a sum row at the end of each page.

g1.png

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 filed 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.

g2.png

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:

FieldsDescription
ACTUAL_DELIVERY_DATE(New in Q1/2023)
ADDRESS_TABLE 
BUILDING 
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 
FLOOR 
LOAD_DATE 
LOAD_LOCATION 
LOADING_DURATION(New in Q1/2023)

MAX_ELEMENT_HEIGHT

(New in Q2/2023)

MAX_ELEMENT_LENGTH

(New in Q2/2023)

MAX_ELEMENT_WIDTH

(New in Q2/2023)
NO_OF_ADDITIONAL_ITEM 
NO_OF_STACKS 
NO_OF_VEHCILES 
NOTE_HEADER 
NOTE2_HEADER(New in Q2/2023)
NOTE3_HEADER(New in Q2/2023)
NOTE4_HEADER(New in Q2/2023)
PHASE 
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_PICTURES 
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 
UNLOADING_DURATION(New in Q1/2023)
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 with Picture.

g3.png

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 
BUILDING(New in Q4/2021)
CAST_START_DATE 
DIVISION_NAME 
ELEMENT_ID 
ELEMENT_MARK 
ELEMENT_TYPE 
ERECTION_SECTION 
ERECTION_SEQUENCE_NO 
EXTENSION_BACK 
EXTENSION_BOTTOM 
EXTENSION_FRONT 
EXTENSION_LEFT 
EXTENSION_RIGHT 
EXTENSION_TOP 
FACTORY_NAME 
FLOOR(New in Q4/2021)
GROSS_AREA 
HEIGHT 
LENGTH 
MASS 
NET_AREA 
NOTE 
NOTE2(New in Q2/2023)
NOTE3(New in Q2/2023)
NOTE4(New in Q2/2023)
NUMBER_OF_ELEMENTS 
PHASE(New in Q4/2021)
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 
TOTAL_HEIGHT 
TOTAL_LENGTH 
TOTAL_WIDTH 
TRANSPORT_COMPANY 
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 With Picture..."

g4.png

Example

g5.png

Download

You can download the report template here

Copyright 2024 StruSoft AB
IMPACT Wiki