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.
- In Crystal Reports, open the report for which you want to create a drill field.
- 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. . The dialog box is displayed.
- Select the Hyperlink tab and then select In Crystal Reports, open the report for which youA web site on the InternetFormat Editor.
- Remove the http:// text from the web site field.
- Click Format Formula Editor. to launch the
-
Specify the
"Form.jsp?
variable and its required beginning and ending components, including_TKN=RW80.1&_HK=
. -
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}
. - When you are finished editing the string, click button to check the syntax.
- If the syntax is correct, click Format Editor, the formula will be displayed on the HyperlinkFormat tab in the web site edit box. to save the formula. The next time you open the
- Save the report and republish it if necessary.