Let's say that I have a crosstab report and the # of columns will exceed the width of the page. If I have columns A,B,C,D,E and only three columns, and three rows print on a page I get a print out like this (for invoices 1-6):
Page 1
Invoice # | A | B | C
---------------------------------------
1
2
3
Page 2
Invoice # | D | E
---------------------------------------
1
2
3
Page 3
Invoice # | A | B | C
---------------------------------------
4
5
6
Page 4
Invoice # | D | E
---------------------------------------
4
5
6
What can I do to so that the report will display information that looks like this:
Page 1
Invoice # | A | B | C
---------------------------------------
1
2
3
Page 2
Invoice # | A | B | C
---------------------------------------
4
5
6
Page 3
Invoice # | D | E
---------------------------------------
1
2
3
Page 4
Invoice # | D | E
---------------------------------------
4
5
6
I hope that this example is clear, please let me know how I can clarify my request.
Page 1
Invoice # | A | B | C
---------------------------------------
1
2
3
Page 2
Invoice # | D | E
---------------------------------------
1
2
3
Page 3
Invoice # | A | B | C
---------------------------------------
4
5
6
Page 4
Invoice # | D | E
---------------------------------------
4
5
6
What can I do to so that the report will display information that looks like this:
Page 1
Invoice # | A | B | C
---------------------------------------
1
2
3
Page 2
Invoice # | A | B | C
---------------------------------------
4
5
6
Page 3
Invoice # | D | E
---------------------------------------
1
2
3
Page 4
Invoice # | D | E
---------------------------------------
4
5
6
I hope that this example is clear, please let me know how I can clarify my request.