Using SQL Templates for Drilldowns
Report Templates that have been created with the SQL Template Designer can be configured to be the target of a drill down. In this example, a Report Template is created with the SQL Template Designer to serve as the parent report. Another Report Template is then created with the SQL Template Designer to be the drill down details.
Using the SQL Template Designer, create a parent report that includes a query that lists a group of hosts, using the apt_v_server published view (example query: select * from apt_v_server). For the purpose of this example, we'll call this the Parent Report.
Using the SQL Template Designer, create a second report that will be the Drilldown Report. For the purpose of a simplified example, you can use the same query that you used for the Parent Report.
Customize the Parent Report and in the Formatting tab, select the hostname field and click the button at the bottom of the SQL Template Designer window.
See Advanced SQL Report Template Options.
Enter the following syntax in the Drilldown field and click before saving the template:
templateId=<Drilldown_Report_Id>=${row['hostname']}.dataReplace <Drilldown_Report_Id> with the actual report ID in the above syntax.
Note:
To get the template ID, run the report and use the shortcut CTRL+ALT+T.