Repeat "columns" in a report

[DataMiner]

I have a report created from a crosstab query (via very useful code in Chapter 9 of Access 2002 Desktop Developer's Handbook by Litwin, Getz, Gunderloy). However, the report extends horizontally across multiple pages, and I need the left-most "columns" in the report to show up on each page. The report looks something like the following .

Item #---Product1----Product2----Product3----Product4
123------5-----------7------------13----------1
456------23----------45-----------2-----------91

In the actual report the dashes are just blank spaces, and I might have up to 40 or so products and at least that many Item#'s. So the report will extend out to the right across multiple pages, and I need Item# to be the first "column" on each page.

The only way I can conceive of doing this is to manually figure out where the page will break, and place duplicate fields with Item# just after that.

Seems kinda clunky. Is there a better way? Any ideas?

 

[Martynwheeler]

I have a report created from a crosstab query (via very useful code in Chapter 9 of Access 2002 Desktop Developer's Handbook by Litwin, Getz, Gunderloy). However, the report extends horizontally across multiple pages, and I need the left-most "columns" in the report to show up on each page. The report looks something like the following .
In the actual report the dashes are just blank spaces, and I might have up to 40 or so products and at least that many Item#'s. So the report will extend out to the right across multiple pages, and I need Item# to be the first "column" on each page.

The only way I can conceive of doing this is to manually figure out where the page will break, and place duplicate fields with Item# just after that.

Seems kinda clunky. Is there a better way? Any ideas?

Did you ever figure this out?

 

[plog]

DataMiner hasn't checked in with us for over 13 years now. Start a new thread using the details of your issue and we can help you out.