Controlling Banded Object Panels in the Exported Excel File

You can control panels of a banded object in the exported Excel file by settings the following three properties:

Merge to Next Panel: Merges current panel to the next panel. It applies to the banded header, banded page header, group header, and group footer panels.
Repeat in Detail Panel: Repeats certain panel with the detail panel. It applies to the group header and banded page header panels.
Remove Blank Row: Removes blank rows in the panel. It applies to the banded page header, group header, and detail panels.

The three properties take effect only when the Columned property of the page report tab containing the banded object is set to true, and there is an operation order when those three properties work together: Merge to Next Panel > Repeat in Detail Panel > Remove Blank Row.

Merging panels in the exported Excel file

You can merge the banded header, banded page header, group header, or group footer panel in a banded object into the panel next to it in the exported Excel file. To do this:

Make sure the Columned property of the report tab that contains the banded object is set to true.
In the Report Inspector, select the node that represents the panel you want to merge.
Set the value of the Merge to Next Panel property to true.
Click File > Export > To Excel.
In the Export to Excel dialog, select Column Format.
Set the other settings according to your requirements and click OK to start exporting.
In the exported Excel file, you can find that the specified panel has been merged to the panel next to it.

Suppose there is a page report tab containing a standard banded object which displays the fields Customer Name, Annual Sales, and is grouped by Customer_Country and Customer_Region.

Standard banded report

Then we set the Columned property of the report tab to true and Merge to Next Panel of the first group header panel to true as well, save the report tab and export it to Excel. We can see that the two group panels are merged into one and fields in the two panels are put in one cell in the exported Excel file.

Exported Excel file with merged panels

In order to improve the layout of the Excel result, now we specify the Column Index and Row Index properties of the objects as follows:

Specify the Column Index and Row Index properties of the objects

Object	Column Index	Row Index
A	3	1
B	4	1
C	1	1
D	2	1
E	3	1
F	4	1

Save the report tab and export it to Excel again. Fields in the Excel file are shown more clearly this time.

Excel result with improved result

Notes:

When two or more objects in the to be merged panels have the same Row Index and Column Index property values, after merging the panels, in the exported Excel file, the objects will be merged into one cell, and they will be located in the cell based on this rule: the object whose X/Y property value is smaller than others will be put to front, and Y has higher priority than X. However, you can improve the appearance of the report by relocating the objects.
Do not set Merge to Next Panel to true for the last group footer panel, because it will make the exported Excel file incorrect.
Do not set Merge to Next Panel to true for the panel that contains crosstab or subreport.

Repeating objects in the group header or banded page header panel in the detail panel

If you want to repeat objects in the group header panel or banded page header panel in the detail panel of a banded object in the exported Excel file, follow the steps below:

Make sure the Columned property of the report tab that contains the banded object is set to true.
In the Report Inspector, select the node that represents the panel you want to repeat.
Set the value of the Repeat in Detail Panel property to true.
Click File > Export > To Excel.
In the Export to Excel dialog, select Column Format.
Set the other settings according to your requirements and click OK to start exporting.
In the exported Excel file, you can find that objects in the specified panel are repeated in the detail panel.

Notes:

When the objects in the group header/banded page header panel have the same Row Index and Column Index property values with those in the detail panel, and you specify to repeat the group header/banded page header panel in the detail panel, in the exported Excel file, the repeated objects will be put in the same cells with the ones in the detail panel based on this rule: the object whose X/Y property value is smaller than others will be put to front, and Y has higher priority than X. However, you can improve the appearance of the report by relocating the objects.
When you specify to repeat a group header panel, if there is a chart in the panel, the chart cannot be repeated.
If a banded object contains more than one group-by fields, that is to say, it has several group header panels, when you specify to repeat the first group header panel in the detail panel, it will be repeated in the second group header panel as well.

Removing blank row in a panel

The property Remove Blank Row is provided to make the report look compact in the exported Excel file. It applies to the banded page header, group header and detail panels of a banded object.

To remove blank rows in the exported Excel file:

Make sure the Columned property of the report tab that contains the banded object is set to true.
In the Report Inspector, select the node that represents the panel where blank rows may appear.
Set the value of the Remove Blank Row property to true.
Click File > Export > To Excel.
In the Export to Excel dialog, select Column Format.
Set the other settings according to your requirements and click OK to start exporting.
In the exported Excel file, you can find that there will be no blank rows in the specified panel.

Previous Page Next Page