Create custom handling confirmation using RDL

In FBO One handling confirmations can be fully customized. The default fixed layout can be replaced with a custom report.

See the instructions at the bottom of this page on how to replace the default layout with a customized report. 

How to customize the layout

For a general introduction, see the FBO One RDL reports tutorial video.

The handling confirmation report is bound to the following data providers or datasets (when viewed from the Report Builder):

The image below gives a perspective of how the RDL template is constructed (coloring as seen below is done only for demonstration purposes):

  • the header section (yellow)
  • the body/content section (white)
  • the footer section (cyan)

The RDL template has otherwise the same layout as the default fixed one described here, with the main difference of being customizable.

The custom Handling confirmation report

A default RDL handling confirmation sample file is already present in the list of used template files in FBO One under MENU | Administration | Reporting | Template documents

Or you can download it from here: HandlingConfirmation.rdl and upload it to your FBO One instance.

Also in the Reports section of FBO One under MENU | Administration | Reporting | Reports, a default report should exist with the name "Handling confirmation".

If for any reason this is not the case, you can create this report using the handling confirmation query.

Activating the custom Handling confirmation layout

To activate an RDL-based handling confirmation layout, assign the report to the Fbo Location, under Menu | Administration | Station | FBO locations.

Edit the Fbo location and select the layout in the "Handling confirmation report" dropdown.


The above steps can be executed in one go by running the below script. Paste the script into the Script Runner, under MENU | Administration | Api add-ins | Script Runner.

Activate RDL based handling confirmation report
using System;
using System.Linq;
using FboOne.Client;
using FboOne.ServiceModel;
 
public class Script
{
  public void Main()
  {
    var s = new FboOne.Scripts.RdlHandlingConfirmation.RdlHandlingConfirmationSetup();
    s.SetAsDefaultReports();
  }
}

To revert to the fixed layout reports, run the below script:

Deactivate RDL based handling confirmation report
using System;
using System.Linq;
using FboOne.Client;
using FboOne.ServiceModel;
 
public class Script
{
  public void Main()
  {
    var s = new FboOne.Scripts.RdlHandlingConfirmation.RdlHandlingConfirmationSetup();
    s.RestoreToActiveReports();
  }
}

Running the script from MENU | Administration | Api add-ins | Script Runner

Generate handling confirmation using the new layout

Once the activation script has been executed handling reports are generated using the new RDL layout

     

Header and footer section information settings

In the header and footer area handling order specific report settings are displayed.

These report settings are defined within FBO One under Menu | Administration | Application | Report settings and are imported into the report via the handling confirmation query/data provider.

Entering line breaks in the report setting will force the RDL template to also display line breaks at rendering time.


See also:

Handling confirmation PDF report

Handling confirmation query


Download: sample handling confirmation RDL template from here: HandlingConfirmation.rdl