Splitting report fields up if you have too many

[bcofie]

What is a best fix for this. I have a report[Landscape] with about 20 fields all lined up horizontally side by side. In report view I see all fields with all data.....I have to use horizontal scrolls to see all fields though. In print view I only see just a couple of fields, the rest of fields appear on different pages--I horizontally scroll to see them. I have manually adjusted to get the most number of fields to fit a page but it just wont fit.

It is possible to snake the reports in such a way that....I will have it look like below;
Field1 Field2 Field3 Field4 ..................Field10
--- --- ---- ---- ------
--- --- ---- ---- ------ --------->Actual data goes here


Filed11 Field12 Field13 Field14 ............Field 20

That is to say instead of having the report fields forced horizontally into different pages, the maximum number of fields that can fit into a single print preview page is fit onto single page and the rest of fields follows vertically down?

[pbaldy]

I suspect you're running into a new "feature" of 2007. In design view select all the data textboxes, click on the Arrange tab and then the Remove icon. You should now be able to select textboxes 11-20 and move them underneath 1-10.