>Hi!
>
> I'm trying to create a matrix report. For instance,
>
> Brand A Brand B . . . Brand n
> Qty Amount Qty Amount Qty Amount
> Client A
> Client B
> ...
> Client n
>
> I've used the vfpxtab.prg already to create the table. My problem is the number of brands can vary from 10 to 1000 and data may not fit in a 8"x14" bond paper.
>
> Any ideas on how a horizontally-paginated multicolumn report can be generated?
>
> Please advise.
>
> Thanks,
>
> John Henry
John,
FWIW this kind of reports fits well to 'pivot' tables. If it's possible to use Excel automation make a pivot table and print from Excel. It would both make the crosstabbing easier + pagination to report.
Cetin