<< Click to Display Table of Contents >> RayVentory Data Hub > 12.5 u5 > 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.
In this tutorial, the report groups data by a data source field (the report's group field).
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.
1.Select the first cell in the Detail band's table and click Insert Column to the Left in the Actions panel.
2.Select the new cell and set Summary/Running to Group.
3.Switch to the Expressions tab and click the Text property's ellipsis button. Specify the sumRecordNumber() expression in the invoked Expression Editor.
Each row now includes a number.
Populate the empty space between the Detail band's data and the footer.
Select the Detail band and enable the Fill Empty Space property.
The empty space is now populated with numbered lines.
Note: Set the Text properties of the Detail band's controls to display static text within the added lines. |
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.
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.
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.
oSelect the new band and add the group field to Group Fields.
4.Add a Panel control to the Group Header. Specify the panel's Background Color and drop fields onto the panel.
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).
6.Switch to Print Preview. The panel is printed on the background of the group content.
7.Switch to Print Preview. The panel is printed on the background of the group content.
See the final report in Print Preview.