Mike, I agree it has to be easier.
I have found a function that counts the pages in the report, however, I am still looking for how to access it... I haven't found any help yet, but apparently the function (Called beforeExport) counts the number of pages in your report and basically allows you to re-order the report, or insert a blank page if necessary. You should be able to harness this, as it will give you an on the fly page total count, which you should be able to then use to show/hide the page footer band. Otherwise, It seems that you have to have the Report Footer band set up in the space it is going to occupy, so that when the report is finished there is adequate space for it. It basically makes you waste space on the other pages in the report to ensure space for the report footer. I personally would rather hide a page footer to show the report footer, but there is this as a simpler solution. Hopefully someone knows how to access the functions in Report Builder and that would save a ton of hassle. 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:309171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
