| Help to stop last field from wrapping in report [message #270073] |
Tue, 25 September 2007 10:52  |
duanecwilson
Messages: 6
Registered: September 2007
Location: Greenville, SC
|
Junior Member |
|
|
I have a report that comes out beautiful and opens in Excel with the extension changed. The only problem is the very last column has a description type field (SEND_REASON) in it which only sometimes is a liitle too long to put in the column made, I guess by default by SQL Plus. I only need it to be about 10 characters longer. What happens is it wraps to the next line and opening in Excel, I get different row widths. I just want the last column to end up a little longer. All the others work fine. They just default to the maximum width of the field. I don't know why the last one doesn't. I don't know if there is a maximum column length set by default that I can override or what. Here is the script that I run that otherwise works perfectly:
SET SERVEROUTPUT ON
SET MARKUP HTML ON
SET ECHO OFF
SET PAGESIZE 33 -- Ideal page length for Excel - headers repeat
SET TERMOUT OFF
SPOOL \\Nsgnvl_files\RCO\R_C_Assurance\Work\Duane\test3.xls
SELECT CIRCUIT_ID
, CONDENSED_EC_CIRCUIT
, VENDOR_ID
, CVBI_KEY
, END_DATE
, CIRCUIT_TYPE
, ALOC, ZLOC
, QTY_CVBI_CAT
, QTY_CKT_CAT
, VEN_TYP
, ALOC_VALID
, ZLOC_VALID
, DUPS_SAME
, AZ_SAME
, SRV_TYP_OK
, CLLIS_OK
, MTPT_OK
, CAP_OK
, SEND_LCA
, SEND_REASON -- This is the column that wraps when too long
FROM RPT_DS1_CNT_CAT_vw WHERE SEND_LCA='YES' ORDER BY CVBI_KEY;
SPOOL OFF
SET MARKUP HTML OFF
SET ECHO ON
SET PAGESIZE 20
SET TERMOUT ON
SET SERVEROUTPUT OFF
PAUSE 'Done - Press ENTER to exit ...'
--EXIT
Thanks for any help.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
