Use Data-Driven Page Sequence

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Dashboards and Reports Customization Guide > Designing Reports > Merge Reports 

Use Data-Driven Page Sequence

This topic describes how to combine a table report that uses Portrait page orientation and a chart report that uses Landscape page orientation.

 

eurd-merge-reports

 

Follow the steps below to create a combined report:

 

Create a Chart Report

1.Create a report that shows data in the chart form. Bind the report to a data source. Set the report's Landscape property to true to enable the Landscape page orientation.
 
eurd-merge-chart-report
 

2.Add a parameter to your chart report to identify which data to use for the chart. Switch to the Field List tab and click the Parameters node's plus button.
 
eurd-fieldlist-addparameter
 

3.Click the created parameter's edit button and set its Name and Type, and uncheck the Visible option.
 
eurd-report-param
 

4.Switch to the report's Properties tab. Click the Filter String option's ellipsis button.
 
eurd-report-filterstring
 

5.In the Filter Editor dialog, construct an expression to compare the key data field to the created parameter.
 
eurd-report-param-2
 

6.Save the report.

 

Create the Base Report

1.Create a report bound to the same data source as the chart report, and arrange a layout like the one shown below:
 
eurd-merge-products-report-layout
 

2.Switch to the Actions tab and click Insert Group Footer.
 
eurd-merge-add-subreport
 

3.Drag a Subreport item from the Toolbox onto the added group footer band.
 
eurd-merge-add-subreport2
 

4.Select the subreport control. In the Actions group, set the Report Source Url parameter to the chart report.
 
eurd-merge-configure-subreport
 

5.Enable the Generate Own Pages option to print the embedded report on separate pages and use its own page settings.
 
eurd-merge-enable-generateownpages-2
 

6.Bind the subreport's parameter used as a filter criterion to the master report's data field that serves as a source of the parameter value. Expand the Data category, select the Parameter Bindings section and add a new parameter binding. In the binding properties list, specify the data field to bind a subreport parameter to, and the parameter you want to bind.
 
eurd-merge-subreport-add-parameter
 

7.Switch to Preview mode to see the combined report.
 
eurd-merge-reports
 

 

Your base report's Table of Contents and Document Map include bookmarks from the embedded report. Use the Parent Bookmark property to specify the nesting level for the embedded report's bookmarks.