Add an External Reference
Using the SQL Template Designer, you can create an tabular report template with a frame that can be populated from another URL providing HTML5 content. This special report template can then be placed on a dashboard and used in conjunction with other reports.
See Create new dashboards and add reports.
Note:
Not all sites will display. If the site included in the iframe returns the X-Frame-Options header, the linked site may not allow its inclusion in the iframe.
To create an external reference
- Select Reports > My Reports> Your Custom Name Folder.
- Click the New SQL Template button.
- Click the Query tab. No action is required on the Template Designer tab.
- Enter the following select statement:
select '<iframe src="https:/aptare.com" width="100%" height="600"></iframe>' url from dual
- Replace "https:/aptare.com" with the destination URL.
- Click Validate Query.
- Click the Formatting tab. This page is pre-populated with the required field.
- Verify the report is set to display as a Table.
- Click the Save & Share tab.
- Enter a name for the template and select the folder to save it in. The template name must be unique.
- Optionally, enter a description.
- Click Advanced.
- Enter xxx-external.url in the Template name field.
- Replace xxx with a name.
- Click OK.
- Click Finish when back on the Save & Share tab.
- Locate the report template in your specified folder and run it. You can add this to a dashboard.
