Composite Report (Dashboard)

A composite report combines many reports into one report. It can also be used with the powerful Acrobat Indexing (Table of Contents) feature that will be outlined in this section. It involves placing multiple Child composite reports under a single Composite report. The final result can be seen in the example below. This report shows country along with their cities and order information about that city. This composite report is actually a combination of three different reports.

The steps involved are:

1. Creating a new report of Report Type set to Composite Report.
2. Creating new reports under this report set as the Parent with the Child Type set to Composite
3. Arrange the layout (appearance) of all reports as a composite report from Composite Properties ⇒ Layout.

This is how the composite report looks like in reports tree.

As can be seen in the above screen shot a report with name Composite Chart Report has been created under the Composite Reports category. While creating a composite report ensure that

• Report Name is entered.
• The report type is set to Composite Report
• No SQL script is required.
• Click on Update button and the report will appear in reports tree.

Under Composite Chart Report three child reports have been created. Child reports of composite reports do not need to be related and this is what gives dashboards their appeal, in that the end user can view multiple unrelated facets of the business in a single pane.

• Create a child report as normal under the parent of composite report. (Here under Composite Chart Report)
• Set Child Type to composite.

Below image displaying that how we have linked three child report to each other. We have defined master_keys for Country and City. City report will use 'Country' as Master_Key and the Detail City report will use 'City' as Maskter_key.

• All child reports of a composite parent are able to see that same parameters and drilldown keys.
• Children of a composite report can themselves be a composite report or any other report type.
• When you drilldown from a sub-report of a composite report to another composite report, the target composite report immediately displays in full pane mode, not just in the pane of the sub-report.