Each object in a report has two horizontal coordinates and two vertical coordinates. The horizontal coordinates are created at the leftmost and rightmost ends of the object, and the vertical coordinates are created at the top and bottom ends. Each unique horizontal coordinate results in an Excel column. Each unique vertical coordinate results in an Excel row.
To eliminate unnecessary rows and columns in the report output, align report objects in Impromptu. Aligning objects reduces the number of unique coordinates, and thereby reduces the number of rows and columns generated in Excel. If the objects exist in a group header or footer, align the objects horizontally to a list frame column.
Tip: To reduce the number of unique coordinates, match the report objects by size. When objects match in size, you can align each vertical or horizontal coordinate. For information about sizing objects, see the Impromptu online help.
For information about how to align objects, see Align Report Objects in Impromptu.