*lets say you have a table (namely table1) with one field the following records: a b c d e f h i j k l m *and it prints on a two columns as follows Page1 a d b e c f Page2 h k i l j m *but you would like it as follows Page1 d a e b f c Page2 k h l i m j * so as to get the desired result on the report, create a second updatable cursor * with three fields as follows * using this command: select field1, ; 0000 as columnfield, ; 0000 as pagefield ; from table1 ; into cursor cursor1 readwrite * Then mark the column and page field accordingly as follows field1 columnfield pagefield a 2 1 b 2 1 c 2 1 d 1 1 e 1 1 f 1 1 h 2 2 i 2 2 j 2 2 k 1 2 l 1 2 m 1 2 SELECT * from cursor1 ORDER BY pagefield,columnfield INTO CURSOR cursor1 * now the records are order in this way field1 columnfield pagefield d 1 1 e 1 1 f 1 1 a 2 1 b 2 1 c 2 1 k 1 2 l 1 2 m 1 2 h 2 2 i 2 2 j 2 2 * when run the same report based on this cursor you will get desired result in your * report as follows: Page1 d a e b f c Page2 k h l i m j This is just a demonstration of the principle that I am trying to convey. I think you can do it if find a way to create this translation layer based on the specific need of your report. The key is to determine the number columns on a page and the number of rows on a page, then you can mark the records appropriatly and get the desired result.Hope this helps!
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature