A combination report allows you to combine multiple reports into one report definition. 

Please note that this feature is only available in the legacy report writer. 

The new reporting writer definitions do not support combination reports. 

Please reach out to the KIE Support team should you require further details.

 

In this example three reports will be created using the following three data views.

 

  1. Timesheet General Data
  2. Expense general Data
  3. Expense Claim General Data

 

Once the above reports have been independently created, you will need to create another report which will be used to combine these reports into a “Combination” type report. 

 

Firstly create the Timesheet General Data report. Construct this report in the normal way and then save the report.

 

The example screenshot below shows the output for this report:

 

The second report is created using Expense General Dataview.  Construct this report in the normal way and then save the report.

 

The example screenshot below shows the output for this report:

 

 

The third report is created using the Expense Claim General Data. Construct this report in the normal way and then save the report.

 

The example screenshot below shows the output for this report:

 

Once the reports have been setup the next stage is to create a “Combination” report as shown below.


Click on the ‘Report’ icon:

 

 

 

 Select ‘Add’

 

 

 

 

 

 

Give the report a Name and a Title:















 

Select the ‘Definition’ tab:

 

 

 

 

 

 

  

The combination report will also require a you to apply a data view.

Please select a data view being used for one of the other report’s you have setup earlier.

 

 

 

Once the data view has been selected, the next step to create a “Combination” report is to remember to change the ‘Report Type’ to ‘Combination’:


 

 

 Once the report type has been changed to type “Combination” you will notice that the tabs to configure the report will change:

 

 

 

 Select the ‘Sub-Reports’ tab and within here click on ‘Add’:

 

 

 

 

 

This will open a search filter so you can search out the three reports you have created:

 

 

  

 

 

Please find the reports and click on ‘Select’ to add them under the Sub-Reports section.

 

**Please note multiple reports can be selected from here by clicking on the checkbox next to the report.



All selected reports will be added under the Sub-Reports section:

 

Please note there is an option to display each sub-report on a new page if required.

This can be done by checking the option ‘Display each Sub-report on a new page’

 

 

 

 

 

 

Select the ‘Filter’ tab:

 

 

 

 

  

Additional filters can be setup for this “Combination” report however, if you choose not to do this the original filters setup in the 3 reports will take precedence.

 

The filters shown here are derived from each of the report filters that were configured in the three reports.

You may have set up duplicate filters in the three reports, but you can go back and modify the filters so the filters do not show up multiple times on the “Combination” report.

 

In this example the filters have been hidden for two data views so the ‘Resource Code’ filter shows once on the combination report:



 






 

 

 

 

 

 




Another way to control a duplicate filter is to override the filter ‘Name’ label within each sub-report to the identical name.

In this example the ‘Resource Code’ filter has been renamed to ‘Resource Label’ within each sub report.

 

 

 

 

 

 

Once the filter ‘Name’ label has been overridden within each sub-report, the combination report will no longer show duplicate filters, for example in this demo the ‘Resource Code’ filter is being used for all three sub-reports however the name for the filter has been changed to ‘Resource Label’


Running the combination report now shows the one filter ‘Resource Label’

 

 

Once the report has been configured, select ‘Save & Run’

As can be seen from the screenshot below the three reports created earlier have been combined into one report view:



 

END OF DOCUMENT