Mike, Congratulations! Children are a joy, but I hope you are prepared for little sleep for some time!
Anyways, yes, that was my thought, however I was hoping that you would know a few more details regarding the line items. If the information is stored in the database, is there anyway that you can do some of the line counts etc. on the addition of the new items? Or are the users able to basically change the line descriptions for each line item each time? If there were anyway to do a character count etc. before it was passed to the report, that would be better, because I think that you will find that the report generation will become sluggish if you are making it work to hard. Again, not something that I have ever done, but I think that it makes sense (well to me anyways) and should provide the answer that you are looking for... maybe? Rob On Wed, Jul 16, 2008 at 12:46 PM, Mike Greider <[EMAIL PROTECTED]> wrote: > Sorry for the delay. We just had a baby on the 11th, and I'm still figuring > out how to juggle the little guy and all other tasks. Yes, it is being > passed in via a query. Each line item has a name, and description field > (which is an unlimited textarea). I have been debating trying to do what you > mentioned. Loop through each line item and count all of the character > returns or lines that exceed X characters (that are automatically wrapped). > Which this number, I might be able to figure out how many pages there are. > Then, on the page footer, I might be able to have only display on the last > page (which would be a variable that I precalculated). Is this what you are > thinking? > > It would be more simplistic if each line item was exactly the same, but > that is not the case. Some are just a single line, others can be as many as > ten lines a piece. > > Mike > > > >Mike, > > > >So how is it passed to the report? Through a Query? Does each product > >(item per invoice) have a set number of lines, or does each product take a > >single line. If it does, then you could just write a function in the > report > >that took the number of items passed and divide by the number of items per > >page and then you can figure out the total number of pages. Again, not > sure > >how the report is being hooked into the database, but I am sure that there > >will be someway to get consistent footer into it. > > > >Rob > > > > > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
