If a report contains a large amount of data, splitting it over multiple worksheets may be unavoidable. However, in some cases, a report splits over multiple pages because the Excel column limit is exceeded. If so, you may be able to prevent the split by transposing the columns and rows. This is possible because the limit for rows is 65,536, whereas the limit for columns is 256 per worksheet. Another way to reduce the number of columns is to align report objects .
For information about moving columns, see the Impromptu online help.