Navigator > Setup > Report Designer >
Export Column and Row Wizard - OR -
Navigator > Setup > Report Designer > File Menu >
Export Wizard
The Export Column and Row Wizard analyses Export Row, Export Column and Export Column Width properties for all Label and Expression components on the selected bands, and applies changes to give valid export properties. This is useful after report components have been moved or changed.
Bands |
Select the report bands to be included in the analysis. |
|
Grid Toolbar |
||
|
Select All |
Select all bands. |
|
Select None |
Unselect all bands. |
Options |
||
Process Bands separately |
When Selected, groups of components will be formed for each band. When Clear, groups of components are gathered from all selected bands. |
|
Force single Row per Band |
When Selected, the Export Row will be 1 for all components in the band, and the column number will be incremented for each component. |
|
Update Column width |
When Selected, column widths will be adjusted for export. This is calculated to have acceptable Excel column widths based on the component width. |
|
Include Expressions |
When Selected, include Expression components in the check. |
|
Include Labels |
When Selected, include Label components in the check. |
|
Horizontal Tolerance |
Increasing the Horizontal Tolerance will make the algorithm include more scattered components along column lines. Reducing the Horizontal Tolerance will make the algorithm more particular so components will be aligned almost vertically to ensure they will be placed in different columns. |
|
Vertical Tolerance |
Increasing the Vertical Tolerance will make the algorithm include more scattered components along row lines. Reducing the Horizontal Tolerance will make the algorithm more particular so components will be aligned almost horizontally to ensure they will be placed in different rows. |
|
Buttons |
||
|
Next |
Display the component options. |
|
Cancel ( |
Close the Export Column and Row Wizard. |