Re: Pls Help ... Urgent

Hi! The default page size for reports is 66 lines. If you want the report to output the data with no embedded blank lines, use the OPTIONS block in the REPORT function to set the following values: OPTIONS top margin 0 bottom margin 0 left margin 0 page length 1 This will give you the results you need. At 08:42 AM 8/20/97 EDT, you wrote: } }Hello Gurus ... }I had tried to do some processes and then unload it to a file. }I can't use the unload command because i have to filled up all the }values in a given column. }For example : }cost DECIMAL(9,2) } }If the value of cost is 1 then the result I wish to see is }0000001.00 } }Fine ... I can't do this using the unload. So I use a report to unload }everything (formatted as above). }Everything seems fine but at the end of the report, there are many }unwanted spaces. Is it by default Informix put some spaces at the end }of the report ? } }Thanks ..... } Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+