Create Report in a Matrix Format Like Excel

[ortley77]

I have a table consisting of 20 columns and 100 records that I want to build into a report formatted like a matrix (as in Excel).

I am currently grouping data, but this format consumes multiple pages and I'd like to have everything on one page. Any suggestions would be appreciated.

Thanks!

Glen

[weekend00]

Do you mean there are too many columns to fit in one page?
How do you group you data?

There different formats you can choose for a report, choose the one that meet you need.

for example, use columnar format if you group all data in one or two record( means you get 20/40 lines in one page). and you may try to change to multiple columnar if that fit you better.

you may also try Landscape view.