Movements

The movement dataprovider will give information on movements, usually one line per movement. It is meant to be the base of any kind of movement report. 

Optional settings

 

AddBlankLineAfterEachMovement (bool; default = false)
Setting this to true inserts at least 1 blank line after each movement to allow for writing space on the report. Not needed unless in combination with the MinimumNumberOfLinesPerHour, as otherwise it can be done by whitespace in the template.

OnlyIncludeMovementsVisibleInDailyFlightProgram (bool; default=true)
Setting this to true hides movements that should not show up in the daily flight program (this is a workflow setting)

OnlyActuals (bool; default=true)
If set to false, not only actuals but also scheduled flights will be shown. A flight is considered actual if it has and ATA for and inbound or ATD for an outbound flight.

ArrDep (char; default=blank)
If set to A, only arrivals will be shown. If set to D, only departures. The special value 1 shows only the first movement of every order. In Excel you could use a VLOOKUP function to add the other haf to it if needed.

ReplaceCommas (bool; default=true)
Whether to replace commas inside the export values themselves. The export values are shown as a comma separated list. Settings this to yes, guarantees commas insite export values don't interfere with this list.

MinimumNumberOfLinesPerHour
Setting this to a non-zero value will insert blank lines (just the time fields will be filled) so a fixed number of lines per hour is output. This can be used to create reports that have a fixed number of lines, with the actual movemens in a sensible position. Setting this to 4 for example, will create at least 1 line for every 15 minute period in an hour. If there are 4 or more movements in an hour, no extra lines will be created. You may want to use the 'AddBlankLineAfterEachMovement' as well, in order to make sure every movement has at least one blank line.

FirstBlankLineOnOrAfterHourUtc
In combination with the MinimumNumberOfLinesPerHour setting, this can prevent the creation of blank lines before say 6 in the morning.

LastBlankLineBeforeHourUtc
In combination with the MinimumNumberOfLinesPerHour setting, this can prevent the creation of blank lines after say 2200.

onlyMovementsOnOrAfterHourLt
In combination with onlyMovementsBeforeHourLt this setting allows to create movement reports for just a single shift.

onlyMovementsBeforeHourLt
In combination with onlyMovementsOnOrAfterHourLt this setting allows to create movement reports for just a single shift.

ServicesToInclude (default = all)
This option can be used to reduce the number of services shown in the serviceslist and remarks fields. It can be 'W' (only services with a workflow) or 'S' (only services in the daily service summary)

ShowCheckBoxesForServices (bool, default=false)
When true, each service in the servcies list is prepended with a '[ ]' symbol, that can be used as a checkbox on a report.

 

See also:

Services query

Orders query