When creating Reports using report building the maximum number of columns is 30.
The Merge Sub-Reports option allows you to join 2 or more reports horizontally in order to include more than 30 columns.
- Report 1 has 20 columns
- Report 2 has 15 columns
- Using sub-reports in the normal manner, Report 2 would sit in line beneath each corresponding record on Report 1 (vertically joined).
- When Merge Sub-Reports is enabled the report will become 35 columns wide incorporating both Report 1 and Report 2.
- Report 2 will not be nested within Report 1.