Wednesday, March 7, 2012

Continue table only on next page

Hello!
I have 3 elements in a report, a header, a body containing a table and a
footer. The header and footer does not need to be a "header" or a "footer".
I want the footer to be placed at the bottom of the page below the allocated
space for the body (regardless how many rows there are in the list) and I
want the list to continue on the next page if it exceeds the allocated space
for the body and finally I want the footer only to be on the first page. The
footer cannot be a table footer.
How can this be done?
For the footer I have tried:
1. If I use a footer to the bank giro my only choice is
"printonlastpage=false" but then, if there are 3 or more pages it would be
printed on page 1, page 2 etc but not on the last page.
2. If I use a textbox below the table containing the invoice items I cannot
find a method to only put the textbox only on the first page, it will only
be on the last page, after the invoiceitems table on the last page.
Thanks,
MariusMarius,
I posted a sample RDL for the problem you posted on June 22, 2004 - Making
an invoice. Please let me know if that proposed solution meets your
requirements. If I am not mistaken this new request deals with the same
issue.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marius Trælnes" <marius.traelnesnospam@.nospamc2i.net> wrote in message
news:%23bKmMsdWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> Hello!
> I have 3 elements in a report, a header, a body containing a table and a
> footer. The header and footer does not need to be a "header" or a
"footer".
> I want the footer to be placed at the bottom of the page below the
allocated
> space for the body (regardless how many rows there are in the list) and I
> want the list to continue on the next page if it exceeds the allocated
space
> for the body and finally I want the footer only to be on the first page.
The
> footer cannot be a table footer.
> How can this be done?
> For the footer I have tried:
> 1. If I use a footer to the bank giro my only choice is
> "printonlastpage=false" but then, if there are 3 or more pages it would be
> printed on page 1, page 2 etc but not on the last page.
> 2. If I use a textbox below the table containing the invoice items I
cannot
> find a method to only put the textbox only on the first page, it will only
> be on the last page, after the invoiceitems table on the last page.
> Thanks,
> Marius
>
>|||Hello!
When In Outlook Express I push "Get next 300 heaers" your response came...
:-o
Thank you! I will have a look.
Marius
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23pQHOqgWEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Marius,
> I posted a sample RDL for the problem you posted on June 22, 2004 - Making
> an invoice. Please let me know if that proposed solution meets your
> requirements. If I am not mistaken this new request deals with the same
> issue.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Marius Trælnes" <marius.traelnesnospam@.nospamc2i.net> wrote in message
> news:%23bKmMsdWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> > Hello!
> >
> > I have 3 elements in a report, a header, a body containing a table and a
> > footer. The header and footer does not need to be a "header" or a
> "footer".
> >
> > I want the footer to be placed at the bottom of the page below the
> allocated
> > space for the body (regardless how many rows there are in the list) and
I
> > want the list to continue on the next page if it exceeds the allocated
> space
> > for the body and finally I want the footer only to be on the first page.
> The
> > footer cannot be a table footer.
> >
> > How can this be done?
> >
> > For the footer I have tried:
> > 1. If I use a footer to the bank giro my only choice is
> > "printonlastpage=false" but then, if there are 3 or more pages it would
be
> > printed on page 1, page 2 etc but not on the last page.
> > 2. If I use a textbox below the table containing the invoice items I
> cannot
> > find a method to only put the textbox only on the first page, it will
only
> > be on the last page, after the invoiceitems table on the last page.
> >
> > Thanks,
> > Marius
> >
> >
> >
> >
>

No comments:

Post a Comment