Well, I am having this problem also, and I have not found a satisfactory
solution. I have the additional complication that some of the info needs to
be pulled from the dataset, so putting it in the footer makes it incredibly
messy (you have to put hidden text boxes in the body, and read the value out
of them, because you cannot read data from the footer).
Of course, if it's in the body, you can't force it to the bottom of the
page, I think I'm going to have to give up on that (which makes it look
really, really stupid). I thought about putting a CanGrow textbox which
calculated the distance and appended line breaks to increase the space, but
as soon as the user changes the page size/margins (which they can in my app,
through a standard page setup dialog), the whole thing gets really messed
up, so that's no good either. Not to mention how difficult the logic would
be to do reliably, considering I have two sets of line items, and an invoice
only needs to have one of them (but can have both), and the fact it would
have to be unit tested because it would be so fragile. In short, a
disgusting hack.
It really is amazing how something so simple (and I would think a basic
requirement of any reporting package) could be so difficult, if not
impossible.
What RS needs is the ability to have multiple footers (and headers), so you
can have separate ones for the first, last and inbetween pages. And the
ability to access data items from the footer.
[quoted text, click to view] <rperetz@gmail.com> wrote in message
news:1181224112.327763.100100@p47g2000hsd.googlegroups.com...
> HI,
>
> Objective: On the last page of an invoice at the bottom of the last
> page have a stub of the invoice:
>
> that section has:
> Company Logo
> Company Address
> Invoice number
> INvoice date
> Sub total
> PSP tax
> and Amount due
>
> Issue: Reporting Services does not support Report Footer only Page
> Footer. (
http://forums.microsoft.com/MSDN/ShowPost.aspx? > PostID=1439673&SiteID=1)
>
> Work around that I have tried:
>
> Work around 1:
> I have created a page footer with a rectangle and set the Visibility
> expression to =Globals.PageNumber < Globals.TotalPages
> Results: The page footer did show up only in the last page, but
> created a block of space in the first pages.
> I was trying to see if there is a way to suppress the spaces from the
> first pages, and found out it's not supported in Reporting Services
>
> This behavior where the report body would consume the space of the
> empty page header & footer is currently not supported.
> -- Robert (
http://forums.microsoft.com/MSDN/ShowPost.aspx? > PostID=340650&SiteID=1)
>
> Work around 2:
>
> I tried to fit all the footer objects in the rectangle in a very
> small height range, hoping it will auto grow at run time. That did not
> work as well.
>
> The textboxes did auto grow, but the Rectangle object or the Page
> Footer itself does not auto grow, cause to cut the footer information.
>
> Work around 3:
>
> Set the property on the page footer PrintOnFirstPage to False, and
> PrintOnLastPage = True, Reporting services does print the footer in
> pages in between.
>
> works great for reports that have only 2 pages, but not not more then
> 2 pages
>
> Best workaround:
>
> Instead of having a space block at the bottom of each page, have a
> marketing text on every page except the last page
>
> I had overlap a textbox on top of the rectangle (in the page footer)
> and having this expression on the Visibility =Globals.PageNumber =
> Globals.TotalPages.
>
> For most of the invoices which are one page, that text will not show
> up and the Invoice stub will show up
>
> For Invoices which are two pages or more, the marketing text will show
> up in the first pages only and in the last page the Invoice stub will
> show.
>
> note: this workaround cause a warning saying "Overlapping report
> items are not supported in all renderers."
>
> but it is supported for PDF.
>
> Am I missing somthing?
> What I don't get, Access has a report footer a product that is over 10
> years old and RS does not have a report footer and I have to do all
> this Gymnastics to pull it off and still it's not perfect.
>
> Please help, I running out of Rabbits out of my hat.
>
> Thanks
> Ronnie
>
