Dynamic Online Reports Overview
Show Sections Hide Sections

Online Reports

The following Reports are available online to report from the Jet Information Databases that are updated quarterly:

Online Reports Instructional Video

Features Offered

  1. PreSets
        - provide easy Save and Restore of Data Selections, and Chart and Grid Parameter settings.
  2. Flexible Element Selector
        - provides easy selection of database subsets showing available data in subsets selected.
  3. Multi Select Element Selector
        - provides option to constrain data to multiple values on one field.
  4. Excel Export Functionality
        - provides for easy export of data to Excel.
  5. Print Preview
  6. Flexible Sorting
        - enables sorting of Chart Pieces, Chart Groups, by Element Titles or Data Values.
  7. Easy Axis Rotation
        - enables easy data view alteration.
  8. Separate Chart and Grid Displays
        - Charts and Grids are displayed and controled thru three different panels and sets of parameters.
  9. Calculations
        - offers % of Chart Group and % of Chart Page as calculations.
  10. Seamless Chart Type Conversion
        - provides easy change of one chart type to another.
  11. Multi Page Charts
        - provides for easy arrangement of multiple pages of a chart within one chart space section. Each page differs by its selection on the 'Page Dimension'.
  12. Multi Charts
        - provides for multiple Charts to be defined.
  13. Same Scaling across Multi Page Charts
        - optionally enables auto-scaling across any number of Charts in a Multi Page Chart.
  14. BiScale Charting
        - optionally enables selected data to be charted according to two separate scales.
  15. Trend Lines

plus more...

Online Report Types

In each of the Online Reports there are three Report Types:
  • Chart
  • Cross Tab Grid
  • Columnar Grid
The Report Types display the data quanties for the data selected in the way requested by the parameter sections. Each Report Type can be updated separately or they can all be updated at once. This flexiblity allows the User to display the same or different data subset selections in each Report Type within a Report.

Online Report Parameters

In each Report, the Online Reporting parameter selection is separated into the following Groups:
  • PreSets

        - Each Report allows the user to save and restore current parameter selections specifically for that User and Report for future display in that Report.

  • Selection Values

        - The User can select the data values to constrain the data to.

        When a Selection Field Value has been made, that constraint reduces the data to be reported from to only the data records that have that constraining value. The remaining Selection Fields will have their available Values reduced to what is available in the new subset created by that selection constraint.

    Multi-Select allows the user to select multiple values in a Selection Field to constrain the data to. Multi-Select can be applied to any number of fields.

  • Measures

        - The Measures available to the Reports vary for each Report.

    The Measures available by Report are as follows:

    • Expanded Report -
      Sum_Units,
      Sum_Engines,
      Sum_MTOWmTons (Maximum Takeoff Weight),
      Sum_SeatsMax (Seats Maximum),
      Sum_SeatsTyp (Seats Typical)
    • Summary Report - Sum_Units
    • Orders Report - Sum_Units
    • Backlog Report - Sum_Units
    • Removals Report -
      Sum_Units,
      Sum_Engines,
      Sum_MTOWmTons,
      Sum_SeatsMax,
      Sum_SeatsTyp
    • Traffic Report - (MMiles = Million Miles, MEnplanements = Million Enplanements, THours = Thousand Hours)
      Sum_Revenue_Passenger_MMiles,
      Sum_Available_Seat_MMiles,
      Sum_MEnplanements,
      Sum_Freight_Ton_MMiles,
      Sum_Departures,
      Sum_Total_Revenue_Ton_MMiles,
      Sum_Revenue_Aircraft_MMiles_Flown,
      Sum_Available_Ton_MMiles,
      Sum_Revenue_Aircraft_THours

    The Measure selected determines what quantity is displayed in the Chart or Report. The Measures selected are put in a list (Dimension) called 'Measures' and appended to the list of Fields available for Reporting. These Fields will display what Values and quantities of those values exist in the selected subset of data when the Field is assigned to a Reporting axis such as Columns or Rows.

    If the 'Measures' Dimension is associated with a Chart or Grid Axis, the selected Measure Field Values list is displayed on that Chart or Grid Axis, and data values for those 'Measures' Values are correspondingly displayed.

    If the 'Measures' Dimension is not associated with a Chart or Grid Axis, then the first 'Measure' selected is used to display the data values (except in Columnar Grid).

  • Chart Parameters

    Select the following:

    • Calculation - Data Value, or % of Chart Part
    • Chart Axis Associations - displays existing values in the data subset on the associated Axis.
    • Sort Parameters - by Title or Data Value
    • Trend Line option
    • Chart Type
    • Legend Location
    • Chart Group Titles Direction
    • Tabular Number Display option
    • Color Palette
    • Chart Size
    • Color Palette
    • Margin
    • 3D
    • Tabular in Chart Piece Color
    • Fill Type
    • Multi Chart Parameters
    • Same Scale - create common scale over all Chart Pages
    • BiScale Parameters - Second scale is created for last item of selected Axis (except for Stacked Chart Types)

    The 'Add a Chart' option allows the user to create Multiple Charts within the Chart space. 'Multi Chart' differs from 'Multi Page Chart' in that 'Multi Chart' has one set of parameter specifications for each Chart. Each Chart displays in its own Chart space section.

    A 'Multi Page Chart' is one set of parameters with one Chart space section, that displays multiple pages from that Chart. Each page in a 'Multi Page Chart' is a different selection value on the 'Page Dimension'.

    For Example, a Multi Chart could have two Charts, the first having the 'Multi Page Chart' option off, thus showing one page, and a second Chart having the 'Multi Page Chart' option on showing four pages. A total of five 'charts' would be displayed, one being with the first 'Chart' and four being in the second 'Chart'.

  • Chart

        - Creates or Prints Chart for the current selection of parameters.

    The Chart uses all Measures selected if the 'Measures' Dimension is associated with a Report Axis, otherwise it uses the first Measure selected.

  • Cross Tab Grid Parameters

    The Cross Tab Grid Report has the following parameters:

    • Calculation - Data Value, or % of Grid Part
    • Grid Axis Associations - displays existing values in the data subset on the associated Axis.
    • Sort Parameters - by Title or Data Value

  • Cross Tab Grid

    Allows the following options:

    • Creates Grid for the current selection of parameters
    • Displays Grid in separate window for Printing
    • Download Grid to Excel

    The Cross Tab Grid uses all Measures selected if the 'Measures' Dimension is associated with a Report Axis, otherwise it uses the first Measure selected.

  • Columnar Grid Parameters

    - Select the SubTotal Break Fields that sums should be created for.
    - The Columnar Grid Report sums the Selected Measure Fields for every unique combination of values in the selected SubTotal Break Fields.

  • Columnar Grid

    Allows the following options:

    • Creates Grid for the current selection of parameters
    • Displays Grid in separate window for Printing
    • Download Grid to Excel