hmmmm, not really sure how to make this work

[rezdragon]

ok here is what im working on, basically it is a printable form. The info for this form will be brought in from an .xls file and will drop into the form. There are two parts to it one will have the look of the current program being used Versaform (an old dos based program thats why we are doing this) the second will convert this information in to a printable format for sending out to clients as a bill. now i have much of this finished except for this.

a normal row contains about 6 - 10 lines of infomation broken down into 8 columns of that row. but after talking to the owner it should be able to handle up to 60 lines from 8 columns. and if it has to make a second or 3rd page then it needs to be able to do that too. and well quite frankly i am stumped.

any ideas? just to give you an idea as to what im talking about

6<-being the number of records to display

12/2/2004 Ad3.0 12709a101224 390 X

12/9/2004 Ad3.0 12710a101224 390 X

12/16/2004 Ad3.0 12711a101224 390 X

12/17/2004 Payment 223152 1560 169067

12/23/2004 Ad3.0 12712a101224 390 X

12/30/2004 Ad3.0 12713a101224 390 X

i hope this helps

[transpower]

Each line would be a line_item, with its own record (using the order key). Then you would print the appropriate records as a report--that way it wouldn't matter if you go more than 60 lines (one page) or two or three pages or whatever.

[rezdragon]

i don't think i explned this correctly..

this is a copy of one record. all the 6 line above are one right behind each other. They are the last 48 things in the record. the top part is the address and such the middle part of this is the infor for the bottom that tells how many days over and the cost and amount due. and the last part is what they are actualy being charged for. this is the tab delimited xls file

0011 Auto Northeast Auto Outlet 3301 Grant Ave 215-969-2277 *** Philadelphia 19114-0000 215-824-2083 *** Northeast Auto Outlet Gloria 3301 Grant Ave John Bubas Philadelphia PA 19114-0000 215-824-0800 248 215 221 Timothy Martin 6 4/18/2000 B ** X N N 34 62 90 6 12/30/2004 390 12/31/2004 224992 1560 N 1950 1560 11/27/2004 12/31/2004 1/23/2003 0 12/17/2004 1560 169067 14 1950 0 0 0 1950 0 12/2/2004 Ad 3.0 12709a101224 390 X 12/9/2004 Ad 3.0 12710a101224 390 X 12/16/2004 Ad 3.0 12711a101224 390 X 12/17/2004 Payment 223152 1560 169067 12/23/2004 Ad 3.0 12712a101224 390 X 12/30/2004 Ad 3.0 12713a101224 390 X

[rezdragon]

as i look at this more i think i need to put the data for the address and stuff into a header the calculated info in the fotter and the data that will be spanning more then one page in the body possibly in a portal

[rezdragon]

hmm, well library is no help with this newest book they had was filemaker 3