Jump to content

hmmmm, not really sure how to make this work


This topic is 6630 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6630 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.