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

On Sun, Jul 13, 2008 at 12:04 PM, Mike Greider <[EMAIL PROTECTED]>
wrote:

> Hi Rob. I have, but I may not be smart enough about this. The number of
> pages is totally dynamic. It is an invoice with N number of products with N
> number of lines of description per each. I tried using the page number that
> is evaluated at the report run time, but that isn't working as a print when
> condition. I thought something like this would be my best chance, but I
> couldn't quite figure it out?
>
> >Mike,
> >
> >Have you looked into the print when conditions for the band properties of
> >the footer?  If you were to know the max number of pages that were to be
> >generated for the invoice you could pass that as a var to the report and
> >then just do a print when condition on the calc.pagenumber function so
> that
> >it equalled whatever the max number of pages were going to be.
> >
> >That is where I would start anyways.
> >
> >Rob
> >
> >On Thu, Jul 10, 2008 at 7:13 PM, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:308990
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to