Report Footer

  • Ok.  I'm new to SQL 2005.  I'm making a report with SSIS-reporting services.  I have the report done with one problem.  I need a textbox in the body of the report (or the page footer) to only print on the last page of the report.  There's a page footer which prints at the end of every page, but I only need it at the end of the report.  I need a report footer or a way to make the page footer or body textbox to print on the last page only.  Can anyone help me?  Thanks!

  • never mind...i figured it out...you have to put a rectangle in the footer and give it an expression of =iif(globals!pagenumber=globals!totalpages, false, true)

     

    then it will only show on the last page

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply