Adding Auto-Drilldown to a Query
Adding auto-drilldown at the query level is very similar to adding auto-drilldown at the model level. (See Example 1: Passing column values in a drill and Example 2: Passing query-based values in drill above.) You can add auto-drills to new queries or existing queries.
Walkthrough
In the following example, you will add an auto-drill to the 'Sales by Category' query of the 'Orders' data source:
1. Open the Asset panel. Expand the 'Data Source' node and the 'Orders' data source.
2. Double-click the 'Sales by Category' query under the 'Orders' data source. This opens the query for editing.
3. Select the Fields tab at the top of the query panel. (Make sure that the 'Main Query' tab at the bottom of the panel is selected.)
4. Select 'SA.CATEGORIES.CATEGORY_NAME' in the 'Query Fields' panel. This enables the 'Editor' at the bottom of the panel.


5. In the editor, click the 'Auto-drill' button.
The 'Auto-Drill' window that now opens is the same as the 'Auto-Drill' window for data models. For further instruction on using this 'Auto-Drill' window, see Example 1: Passing column values in a drill and Example 2: Passing query-based values in drill. After you add the auto-drill to this query field, all reports and viewsheets that use the 'Sales by Category' query will automatically provide hyperlinks.
Note that the 'Auto-Drill' window for query-level auto-drill also offers the option of passing query-based parameters. See Example 2: Passing query-based values in drill for details of the procedure.
| << Passing Multiple Parameters in a Query-Based Auto-Drill | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.4.3 Adding a Format to a Data Field >> |