Making an invoice

Hello!
I'm trying to make an Invoice in RS but find it difficult, could I get some
help with the following:
If the list of items in the invoice is larger than one page I have to show
the rest on the next page, the
standard in our country is to have a bank giro at the bottom of an invoice,
about 1/5 of the invoice
would be a bank giro like this:
--
| |
| header |
--
| |
| invoice |
| items |
| table |
| |
--
| |
| bank giro |
--
And the paper in the printer I'm writing to allways have allocated space for
the bank giro so the
list being printed on the second page should not go below that allocated
space. And the information
to be printed to the bank giro allocated space should only be on the first
page, on the second page
(or third, fourth etc) it should be nothing there.
The problems are:
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.
(it should be possible to say that the table continues to the next page but
the text box should not...)
3. For both above I can't find a method to "break" the invoiceitems table
before it reaches the bank giro
allocated space.
Hope for some help!Thank you!
This will set me on track. BTW: if i set the datasource to select top 3 *
from customers then the footer disappear...
Marius
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23BL78GMWEHA.4056@.TK2MSFTNGP11.phx.gbl...
> Attached is a sample report that should model what you are trying to
> achieve. This report will only print a page footer ("bank giro") on the
> first page of the report.
> Key Areas:
> * The Page is set to print on first page
> * All items in the page footer are contained in a rectangle.
> * The visibility property on the rectangle is set to an expression:
> =iif(ReportItems!DoubleSecretTextbox.Value is Nothing, true, false)
> * The DoubleSecretTextbox contains a single character, is sized to 0,0,
and
> has its
> foreground and background set to white. It is placed to the right of
the
> table.
> When this report is rendered the textbox will not be visible but it does
> exist. Hence on page 1 the rectangle expression does not evaluate to
> Nothing. However on subsequent pages the textbox does not exist: the page
> footer is not rendered.
> --
> 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:OsfkaTHWEHA.3476@.tk2msftngp13.phx.gbl...
> > Hello!
> >
> > I'm trying to make an Invoice in RS but find it difficult, could I get
> some
> > help with the following:
> >
> > If the list of items in the invoice is larger than one page I have to
show
> > the rest on the next page, the
> > standard in our country is to have a bank giro at the bottom of an
> invoice,
> > about 1/5 of the invoice
> > would be a bank giro like this:
> >
> > --
> > | |
> > | header |
> > --
> > | |
> > | invoice |
> > | items |
> > | table |
> > | |
> > --
> > | |
> > | bank giro |
> > --
> >
> > And the paper in the printer I'm writing to allways have allocated space
> for
> > the bank giro so the
> > list being printed on the second page should not go below that allocated
> > space. And the information
> > to be printed to the bank giro allocated space should only be on the
first
> > page, on the second page
> > (or third, fourth etc) it should be nothing there.
> >
> > The problems are:
> >
> > 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.
> > (it should be possible to say that the table continues to the next page
> but
> > the text box should not...)
> > 3. For both above I can't find a method to "break" the invoiceitems
table
> > before it reaches the bank giro
> > allocated space.
> >
> > Hope for some help!
> >
> >
>
>