Drill fields in reports

The Crystal Reports that you create can include drill fields, which provide the capability to drill into any field for which Lawson drill data exists. Drill fields allow users to access more information about the data by clicking on the field to initiate the Lawson drill navigation.

Note: Drill Around on a Crystal Reports report can only be used if the report is being viewed using the Crystal Dynamic HTML Viewer.
Lawson Application Linker (LAL)
When you create a drill field in a report, you are creating a hyperlink to the Lawson Application Link (LAL) servlet, which is a component located on the Framework Services server. The services that LAL uses to direct the drill calls are specified in the Framework Services Administrative Services screen corresponding to the IOS or Portal version that you are using. You can create and use the following drill services: Drill (IDA), Transaction (AGS), Data (DME), and Lawson Portal Form service (TKN).
Framework Services Application Services Set Up
When creating the drill string in Crystal Reports, you must specify the Service ID (SID) corresponding to the Lawson service that you want to execute the Drill Around command, as well as the specific table and key fields you want the user to access.

In Framework Services, there are two types of Lawson Application Services that you can define for the Drill Around or form transfer functionality. These types are:

  • Lawson IOS used for Drill, Transaction, and Data in Lawson Environment 8.0.3 or Core Technology 9.0
  • Lawson Portal used for TKN (form transfer) in the Portal 9.0 Environment

You can set up multiple services for each application, if necessary.

The following is the order in which LAL determines the SID needed to direct the Drill Around command:

  • If the drill string or form transfer string includes an override SID, LAL uses that SID.
  • If no override SID exists in the string, LAL uses the report's override data setting definition.
  • If no SID exists on the report's override data settings, LAL uses the Reporting Service's data source definition.
  • If no SID exists within the Framework Service's IOS or Portal application service, LAL uses the default SID information that was set up in the Framework Service's system configuration.
  • If no SID exists in the Framework Service's system configuration, the Drill Around or form transfer will not be successful and users will receive errors when they try to perform these actions.