Reports 2.5: Fixed Length Text File

From: Rick Moore <rlmoore_at_purdue.edu>
Date: Wed, 15 Dec 1999 13:41:42 -0500
Message-ID: <Pine.SOL.4.10.9912151331320.1759-100000_at_herald.cc.purdue.edu>

I am attempting to output a fixed length text file w/ Oracle Reports 2.5.

I have a query in the reports designer:

select

RPAD(NVL(UCBCUST_CUST_CODE,0),6)|| 
RPAD(NVL(UCBPREM_CODE,0),6)||
RPAD(NVL(UCBCUST_FIRST_NAME,' '),20)|| 
RPAD(NVL(UCBCUST_LAST_NAME,' '),20)|| 
RPAD(NVL(UCBCUST_MIDDLE_NAME,' '),20)|| chr(10) 

from UCBCUST,UCBPREM WHERE.....

The goal of which is to produce one fixed length output from the query.

We have also attempted to remove the carriage return.

The problem is that the file output is NOT fixed length. Worse yet, the file output looks great on screen in the designer, but is a mess when printed to file.

Anyt suggestions on how to produce a fixed length file w/ the Report Designer. Received on Wed Dec 15 1999 - 19:41:42 CET