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

Format using SQL server

I'm new to SQL server. My question here is how can I format the data that is retrieved as a result of SELECT.

Similar defining the column format in SQL Plus. For some reason SQL Server puts in extra spaces between the data fields in the .dat file.

If you have additional trainling spaces, it seems that you specified a fixed character length instead of a variable. THe data won′t be chopped until you will specify it either in the table structure or within the Select statement while pumpoing the data out of the database (CONVERT).

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||This is not with the data. Say if I have 2 fields Field 1 and Field 2. Field 1 is 12 char and field 2 is 2 char. Instead of putting Field 1 as 12 char it puts 15 char for Field 1 and for Field 2 it puts 4 char. I want to remove those extra spaces. I would appreciate any help.