Formatting RS to look like invoice

hi!,
Can we use RS to format the report to look like an invoice?
The areas I have been having problems is defining the table with the invoice
items to always stay the same size regardless of the number of lines it
prints. I was using a table embedded in the report to print this with borders
on the table.
How do I get this to a fixed length column or let it page break with headers
and footers defining number of fixed lines for the body of the report. Are
there any samples of invoices either, Microsoft or anyone else has done?
Ranjit CharlesHi Ranjit,
You can control the number of rows in your report by:
1) add a group to table, and set grouping with
"=Ceiling(RowNumber(Nothing)/30)" try 30 or whatever number fits into
your spacing
2) turn off group header and footer
3) set PageBreakAtEnd for group
HTH
Matt A
www.reportarchitex.com

formatted invoice line item report

I am trying to make a report that show invoice line items using a table with
groups. We what the table to fill the page no matter how many line items are
on the invoice. For example the invoice my only have three items on the last
page so the group footer ends up in the middle of the page. The group footer
has the invoice total. How can we place group footer at the bottom of the
last page? Even in the case of a small invoice that only has one page ?I'm going to take a stab at this but I hope someone comes up with a better
way. I could use it myself. Anyway here goes:
Insert a row in your above your totals in the group footer.
Figure out the number of line items that fit on a page.
Make the row height of the just inserted row an expression equal to
(MaxLineItemsPerPage - (LineItemCount MOD MaxLineItemsPerPage)) *
LineItemRowHeight)
This will give you the number of "blank" lines on the last page of the
invoice and make your empty footer row that height to fill in the space. The
expression will get a little more complicated if pages 2 on have more rows
than page 1 (i.e. no invoice header) but I think the calculation can be done.
Let me know if this works...Or if someone comes up with a better way!
"DJJIII" wrote:
> I am trying to make a report that show invoice line items using a table with
> groups. We what the table to fill the page no matter how many line items are
> on the invoice. For example the invoice my only have three items on the last
> page so the group footer ends up in the middle of the page. The group footer
> has the invoice total. How can we place group footer at the bottom of the
> last page? Even in the case of a small invoice that only has one page ?

Formating

I am creating an extraction routine and need to pull out an invoice number
from a table. However as part of transferring this to a new system I need to
add leading zeroes to the front of the field.
eg 456 into 000456.
I`m sure I am having brain fade here but can`t think of the way to do this.
Any help gratefully received.SELECT RIGHT('000000' + CONVERT(varchar(20),456),6)
HTH, Jens Suessmeyer.