Adding a drill field to a report based on an RW100 report query

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

  • Identified the drill field in your report query.
  • 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 In Crystal Reports, open the report for which you want to create a drill field.Format Field. The dialog box is displayed.
  3. Select the Hyperlink tab and then select In Crystal Reports, open the report for which youA web site on the InternetFormat Editor.
  4. Remove the http:// text from the web site field.
  5. Click X+2 to launch the Format Formula Editor.
  6. Specify the "Form.jsp? variable and its required beginning and ending components, including _TKN=RW80.1&_HK=.
  7. Select the Drill Around field that you want to add to your report. The following is an example of the valid syntax you will create: "Form.jsp?_TKN=RW80.1&_HK="+{Command.CYDAMT_DRILL}.
  8. When you are finished editing the string, click X+2 button to check the syntax.
  9. 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 HyperlinkFormat tab in the web site edit box.
  10. Save the report and republish it if necessary.