Multiple-Column Report Column Height Not Working (Down, then Across)?

[mattshank]

I want my records to be displayed "Down, then Across", but I don't want the records to take up the whole page, because I want to show an Invoice Total at the bottom of the page. Changing the Column height in Page Setup does nothing, unless I switch it to "Across, then Down". It looks exactly how I want it to look if I choose "Across, and Down", but I want my records to be read "Down, then Across"! What is this madness? Is there a way to fix it?

[June7]

Wish I knew. I have a multi-column "Down, then Across" report. First column fills to bottom of page then second column is shorter. I would like them balanced. Only "Across, then Down" provides that. Very annoying.

Maybe some VBA code could manage a column break. But I am not finding anything.

[mattshank]

It's a bizarre quirk. It has to be a bug.

I have my Invoice grand total in the Report Footer, and it's get pushed to a second page for no reason... And calculated fields show "#Error" if I try to throw the Invoice total in the Page Footer. Frustrating.

A possible workaround would be making a new table that has all the info you need, as well as an auto-incrementing column, and another column that divides the auto integer by the number of records you'd like to show per column. You can then group the records on the report, by the divided field. And change the property in the group footer to "New Row or Col" "After Section". I haven't decided if I'm going to bother trying this.

[June7]

Maybe Google beats Bing.

Review:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://www.pcreview.co.uk/forums/for...-t2924701.html

I haven't tried yet.

[mattshank]

I believe the second link will work, though only if all the records are guaranteed to fit in 2 columns on one page. Otherwise, you could loop through all the records, assigning an incremented group number every so many records. This would be easier than what I was trying to do, but the same concept.