I have a Table that contains three fields
Desc
POS
Pageno

DESC field contains the description.

POS contains The Row position of the Desc. Please Note that the Higher the row number, the data will be placed at the top of the page and vice versa.

PAGENO contains the corresponding page number.

I want to shift the DESC of Page Number 3 to Page Number 2(and Page Number 4 to Page 3 and so on depending upon the number of pages) under following conditions:-

Page Number 1 should be intact (No Change to be done)

The Highest Rows at Page Number 3 will be shifted to page number two, followed by the next higher row. Please Note that there may be more than One DESC having similar Row Positions.

The DESC which will be shifted will become DESC at Page Number 2 ,and the shifted row will have the lowest number in page Number 2. Thus if another next row is shifted, it will be the lowest row and so On. Shifted Row to Be inserted before U1.

The Process shall continue unless there is a scope of not less than 40 rows ( Last 40 rows reserved for Page Footer) i.e mean to say that the code Should check that whether 40 row position has reached. IF yes than it should stop shifting the DESC in that Page.


The Left out content at Page 3 should be Rearranged i.e left out Data should be brought on Top and the same process to be repeated for Page 4 and so on.

The required DBF is attached here

https://www.dropbox.com/s/ea5c09xo6gvl6r1/Row.DBF


Kinldy Help.

Harsh