How to Embed Child Reports in Parent Reports

Customers often want to show custom reports for child groups in parent groups. This can be done by showing an IFRAME in the parent group using the child group's URL. The technique below will show how to automatically determine the child URLs to use from a parent group.

Implementation

For this approach, you will define two Custom Report/Executive Summary reports. We recommend doing this on the Servers/Devices group so all groups below will inherit these definitions.

One custom report will be for the Parent level, and another will be for all the Child (sub-group) reports.

Create and define the Child Custom Report first with whatever content you want in it.

In the Child Custom Report, set the Report Title field to "NONE" (without the quotes). That will make it look a little better (this will promote the group names to bigger headers in the report).

In the Parent report, add an HTML: Custom Block and put the code below in it:

<script>

  function resizeIframe(obj) {
	obj.style.height = obj.contentWindow.document.body.scrollHeight + 'px';
  }

</script>

$for{childID in paGetGroupChildIDs(objID)}
		<iframe src="https://127.0.0.1:81/STATUS_CUSTOM_(16_${childID})/index.html?
		CMD=REFRESH_REPORT&RTYPE=16&ROBJ=${childID}&hideMenu=1"
    frameborder="0" scrolling="no" style="width:100%;"
    onload="resizeIframe(this);" > </iframe>
$rof
		

Ths above code will add an IFRAME pointing to each of the Child group Custom Reports. This way you can open the top level company report, and it will also show the child reports within the report.

You will need to change the red values. Figuring out what to replace the 16 with is a tiny bit tricky, but it can be done:

• View one of the child Custom Reports (for any group, it doesn't matter which one).
• Click the Open in Browser button so the report is opened in a browser. It might take you to the login screen, and that is OK.
• Look at the URL. There is an RTYPE value there. It will be one of 14, 15, 16 or 17. Whatever is there is what you put in place of the 16's in the code example above.

Now you can go to the Parent Custom Report and you should see each Child Custom Report embedded within it.