I've got a subreport with 2 columns. The data itself consists of GH1 and GH2. When there is a small amount of data (say 4 inches worth on a page), the data only appears in the left column. If there is a larger amount of data (say 16 inches worth on a page), the left column fills up and then begins in the right column. The problem is that the reports often look unbalanced. Sometimes there is only data in the left column, and sometimes there is a full left column of data and just a small amount at the top of the right column.

Is there a way to automatically adjust the column heights so that the left and right column always appear to be balanced? For example, if there is only 4 inches worth of data, the left column would be 2 inches in height and the right column would be 2 inches. If there were 16 inches of data, the left column would be 8 inches in height and the right column would be 8 inches.

Columns are such a great tool in Crystal, but having a long column of data on the left side of the page and nothing on the right looks off.

Is there a solution?

Thanks!