MikeFreeland
Programmer
- Sep 4, 2000
- 10
I have a large number of 1-table reports, all wide, consisting of an item, then a variable number of columns of numbers, each column representing a datum for the item for the year at the top of the column, like so:
Page 1a
Item 1990 1991 1992...
------------------------------------
Item1 90dat1 91dat1 92dat1...
Item2 90dat2 91dat2 92dat2...
until the page is filled. Now, I want the report to know that it hasn't printed all of the data for ietms 1 and 2, and go to the top of the data and start all over with item 1, but printing the columns where it left off. It should look like this:
Page 1b
Item 1993 1994 1995...
------------------------------------
Item1 93dat1 94dat1 95dat1...
Item2 93dat2 94dat2 95dat2...
Page 2a would start with item3 and so on to eof.
I am now doing it by multiple calls to the FRX. Problem here is that the pages emerge 1a, 2a, 3a, and then on the second call 1b, 2b, 3b etc. and the user has to collate. It's not very elegant and the second call of course calls up the preview a second or third time (at the user's choice).
What I'm looking for is a sort of "do while" loop in the report, and I haven't figured a way to hack the FRX to plug in the required parameters (record numbers, columns and sub-pages etc.) The data grouping, sorting and other elements of these reports are complex, so fiddling with the source data file is not an option.
Your assistance will be most appreciated. Thanks to all.
Mike [sig][/sig]
Page 1a
Item 1990 1991 1992...
------------------------------------
Item1 90dat1 91dat1 92dat1...
Item2 90dat2 91dat2 92dat2...
until the page is filled. Now, I want the report to know that it hasn't printed all of the data for ietms 1 and 2, and go to the top of the data and start all over with item 1, but printing the columns where it left off. It should look like this:
Page 1b
Item 1993 1994 1995...
------------------------------------
Item1 93dat1 94dat1 95dat1...
Item2 93dat2 94dat2 95dat2...
Page 2a would start with item3 and so on to eof.
I am now doing it by multiple calls to the FRX. Problem here is that the pages emerge 1a, 2a, 3a, and then on the second call 1b, 2b, 3b etc. and the user has to collate. It's not very elegant and the second call of course calls up the preview a second or third time (at the user's choice).
What I'm looking for is a sort of "do while" loop in the report, and I haven't figured a way to hack the FRX to plug in the required parameters (record numbers, columns and sub-pages etc.) The data grouping, sorting and other elements of these reports are complex, so fiddling with the source data file is not an option.
Your assistance will be most appreciated. Thanks to all.
Mike [sig][/sig]