Reports with Cross-Band Content and Populated Empty Space

<< Click to Display Table of Contents >>

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

Reports with Cross-Band Content and Populated Empty Space

This document describes how to create a report with the following layout options:

 

Print part of the content across bands (the blue panel);

Populate the empty space between the detail and footer information with blank rows.

 

eurd-web-underlay-report-preview-6

 

Initial Report

In this tutorial, the report groups data by a data source field (the report's group field).

 

eurd-web-underlay-report-preview

 

The GroupFooter band is displayed at the bottom of the page (the Print At Bottom property is enabled). There is an empty space between the Detail band's data and the footer.

 

eurd-web-underlay-report-preview-0

 

Add Line Numbers

1.Select the first cell in the Detail band's table and click Insert Column to the Left in the Actions panel.
 
eurd-web-underlay-report-add-cell
 

2.Select the new cell and set Summary/Running to Group.
 
eurd-web-underlay-report-add-line-numbers
 

3.Switch to the Expressions tab and click the Text property's ellipsis button. Specify the sumRecordNumber() expression in the invoked Expression Editor.

 

eurd-web-underlay-report-add-line-numbers-2

 

Each row now includes a number.

 

eurd-web-underlay-report-preview-3

 

Populate the Empty Space

Populate the empty space between the Detail band's data and the footer.

 

Select the Detail band and enable the Fill Empty Space property.

 

eurd-web-underlay-report-fillemptyspace

 

The empty space is now populated with numbered lines.

 

eurd-web-underlay-report-preview-4

 

papercliper

Note:

Set the Text properties of the Detail band's controls to display static text within the added lines.

 

Add Cross-Band Data

Add a panel with recipient details across the entire group. Place the panel on a separate Group Header band that is printed on the background of other bands.

 

1.Select the report and click Insert Group Header Band in the Actions group.
 
eurd-web-underlay-report-addgroupheader

 

tip

Tip:

Choose a Page Header band instead of the Group Header to display the cross-band content on an entire page.

 

2.Select the added band and enable the Print Across Bands property. This displays the band content on the background of the GroupHeader1, Detail, and GroupFooter1 bands.
 
eurd-web-underlay-report-printundernextband
 

3.The report's group field is in the GroupHeader1 band's Group Fields collection. The new band is above GroupHeader1 and does not participate in the report's group. Move the group field to the new band.

oSelect GroupHeader1 and remove the group field from Group Fields.
 
eurd-web-underlay-report-removegroupfields
 

oSelect the new band and add the group field to Group Fields.
 
eurd-web-underlay-report-movegroupfields
 

4.Add a Panel control to the Group Header. Specify the panel's Background Color and drop fields onto the panel.
 
eurd-web-underlay-report-add-recipient
 

5.Adjust the panel's width and height. The height should match the page height, as the footer is printed at the bottom of the page (the Group Footer's Print At Bottom property is enabled).
 
eurd-web-underlay-report-adjust-crossband-height
 

6.Switch to Print Preview. The panel is printed on the background of the group content.
 
eurd-web-underlay-report-preview-5
 

7.Switch to Print Preview. The panel is printed on the background of the group content.
 
eurd-web-underlay-report-adjust-width
 

See the final report in Print Preview.

 

eurd-web-underlay-report-preview-6