How to: Reference: |
The multiple drill down feature enables you to add detail to a report by creating hyperlinks that have multiple actions. For example, you can create hyperlinks that run a detail report or Maintain procedure, execute a JavaScript function, and link to a URL. When you click a component in the summary report, a pop-up menu appears, with the possible options to drill down to.
The multiple drill down feature applies to:
Note: You may change the default styling of the drill down menu by applying StyleSheet syntax. For more information, see Creating Multiple Drill-Down Links in the Creating Reports With WebFOCUS Language manual.
To create a multiple drill down procedure:
The Field Properties dialog box opens.
The Drill Menu Items input box is enabled and the default drill down name, DrillDown 1, appears.
Tip: The pop-up menu of drill-down options is only visible in the report output if the Multiple Drill Downs check box is enabled and you have at least one drill down definition, as shown in the following image.
This is the name that appears on the pop-up menu in the report output.
The Drill Menu Items input box also features buttons that allow you to add, delete, or change the order of drill down names.
The drill down type can be any of the following:
For a description of the drill down types, see Field Properties Drill Down Tab.
The Drill Down Parameter dialog box opens.
For a description of the fields in the dialog box, see Drill Down Parameter Dialog Box.
Click Cancel to return to the Field Properties dialog box.
When you click the Add new item button, the default name for the next drill down, DrillDown2, appears in the Drill Menu Items input box, then DrillDown3, and so on. If you change the default name of the first drill down definition, DrillDown 1, that value appears again when you create the second drill down definition.
When you create multiple drill down items, the Multiple Drill Downs check box is automatically checked and disabled to avoid the inadvertent loss of drill down items you previously created. If you delete drill down items until one remains, the Multiple Drill Downs check box is enabled again.
The main report appears in the browser.
The pop-up menu appears, as shown in the following image.
The currently selected option is underlined in red. An additional browser window opens with your output.
If you click the last field of the report output, scroll bars appear in the browser window if required for access to all of the menu options.
To use the multiple drill down feature, select HTML output format from the Report Painter window:
The Report Options dialog box opens.
Another way is to select HTML from the Output Format toolbar.
If you select a report format other than HTML in the Report Options dialog box, the multiple drill down feature is disabled as shown in the following image.
If you select the display format User, you can create a multiple drill down report in Report Painter. When you run the report, Developer Studio prompts you for the desired format. If you choose a format other than HTML, the report runs, but the pop-up menu of drill down options is not displayed, and the drill down action defaults to the first drill down definition created.
If you try to create a new drill down definition without selecting a Drill Down Type for the current definition, the following error message appears:
If you create a drill down definition with a drill down type, but omit the required value for the type, an error message appears if you try to create a new definition. For example, if you select URL from the Drill Down Type list, and you do not supply a URL address, the following error message appears when you click New.
The following example illustrates the multiple drill down feature using the main and detail reports that were created in Creating Drill Down Reports. It assumes you completed and have access to those reports.
The examples use the GGSALES.MAS Master File. The State column in the main report will provide the hyperlinks available from the pop-up menu of drill down options.
Type the URL address, http://www.informationbuilders.com, in the URL input box.
Tip: You must type the entire address, including http://.
The main report appears in the browser, as shown in the following image.
The pop-up menu appears, as shown in the following image.
When you point to a drill down menu item, it appears in red and is underlined, as shown in the following image.
The website opens in the browser.
WebFOCUS |