Showing posts with label items. Show all posts
Showing posts with label items. Show all posts

Friday, March 23, 2012

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!
> >
> >
>
>

Making a row delete itself at a certain time?

Is there any possible way to make a row delete itself at a certain date and time? I am tring to make an "On_Sale" table and perticular items(rows) must expire at a certain Date and time. I have an idea to delete a row when it expires but it will cause an extra burden on my application. So is it possible to have SQL responsible for deleting a row at a certain time and date?

Also, I have another question:
when I asign a PK Identity to a certain column is there a way I can enforce consecutive order of PK values? For example if I delete a row and the PK value was 5 it will reoder the whole table so all PK values are in consecutive order:

PK----Item----price
1----XYZ1----$$$$
2----XYZ2----$$$$
3----XYZ3----$$$$

when I delete PK 2 this is what happens

PK----Item----price
1----XYZ1----$$$$
3----XYZ3----$$$$

the PKs are not in consecutive order

What I want is this to happen: when PK 2 is deleted I need it to show as follows

PK----Item----price
1----XYZ1----$$$$
2----XYZ3----$$$$

The PKs stay in consecutive order.

See how the PK are still in consecutive order?I am tring to make an "On_Sale" table and perticular items(rows) must expire at a certain Date and time. I have an idea to delete a row when it expires but it will cause an extra burden on my application.Why delete it at all? Save the expiration date within your row, and then create a view on that table with something like WHERE expiration_date <= current_date. Then make your application use the view to retrieve the data (or simply add the condition to your application logic), thus it will never see expired rows. If you put an index on that column the retrieval should be quite fast.

If you are concerned about space, than run a batch job every night that deletes the expired rows.|||you could create an agent job that would delete the rows also.

Monday, March 19, 2012

Make items bold in parameter selection list

Is it possible to make certain items in a parameter selection list appear bold?No, parameters are not configurable in terms of presentation.


HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I am getting available values from a calculated member in analysis services. The definition pane for a calculated member contains a section for 'font expressions'. I tried to use that, but didn't succeed. Does anyone know what you can do with font expressions?