Adding a drill field to a report based on standard report or form query

This procedure describes how to add a Drill Around field to a report that is based on a Lawson standard report or a form query. Before you perform this procedure, you should have:

  • Identified the drill field in your report query. Drill field end in _DRILL.
  • Completed the required LAL configuration procedures in Framework Services. For more information, see the Framework Services User and Administration Guide.
Note: Before you can perform this procedure, set up a drill field in a report. You need to know how to use Crystal Report's field formatting options and also have some basic knowledge of the Crystal Formula Editor.
  1. In Crystal Reports, open the report for which you want to create a drill field.
  2. Right-click the field to which you want to add drill around functionality and then select Format Field. The Format Editor dialog box is displayed.
  3. Select the Hyperlink tab and then select A web site on the Internet.
  4. Remove the http:// text from the web site field.
  5. Click X+2 to launch the Format Formula Editor.
  6. Specify the "Drill.jsp? variable and select the Drill Around field that you want to add to your report.
  7. When you are finished editing the string, click X+2 button to check the syntax.
  8. If the syntax is correct, click Save to save the formula. The next time you open the Format Editor, the formula will be displayed on the Hyperlink tab in the web site edit box.
  9. Save the report and republish it if necessary.