I used a work around I found on this forum to get columns headings to print on one line. The computed field XDOC_ID column prints as a 0? The format returned from the stored procedure is INT. When I print the DOC_ID field as it is, it dislplays '102141865'. I tried converting it to alpha and that does not work.
Here is the code:

SQL SQLMSS SET SERVER FLORA3
END
SQL SQLMSS
-*
-IF &LAUNCH_RPT EQ 'BR3' THEN GOTO BR3START;
EX e_CTR_Counter2_legacy &&G_ORGID, &DT_FROM, &DT_TO;
-GOTO BR2DONE;
-BR3START;
EX e_CTR_Counter3_legacy &&G_ORGID, &DT_FROM, &DT_TO;
-BR2DONE;

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS NEWONE FORMAT FOCUS
END
-RUN
-*
DEFINE FILE NEWONE
ALPHA_DOC_ID/A8 = EDIT(DOC_ID);
-*ALPHA_DOC_ID/A8 = FTOA(DOC_ID ,'(I8)','A8');
DACTUAL_DATE/MDY = HDATE(ACTUAL_DATE,'MDY');
DDACTUAL_DATE/MYY = DACTUAL_DATE;
-*ALPHA_ACTUAL_DT/A7= HCNVRT(DDACTUAL_DATE,'(MYY)',7,'A7');
-IF &LAUNCH_RPT EQ 'BR3' THEN GOTO BR3DEFINE;
HOWMANY/I11C = PAGES_VIEWED + PAGES_COPIED + PAGES_PRINTED + CHAPTERS_DOWNLOADED + ACS_DOWNLOADED;
-GOTO BR2DONE1;
-BR3DEFINE;
HOWMANY/I11C = TURNAWAYS;
-BR2DONE1;
END
-*
TABLE FILE NEWONE

SUM
HOWMANY
BY TITLE NOPRINT
BY PUBLISHER NOPRINT
BY Platform NOPRINT
BY DOC_ID
BY PropertyIdentifier NOPRINT
BY ISBN_PRINT NOPRINT
BY ISSN NOPRINT
-IF &LAUNCH_RPT EQ 'BR2' THEN GOTO BR2DONE3;
BY DeniedDueTo AS 'Access Denied Category'
-BR2DONE3;
-*ACROSS DDACTUAL_DATE AS ''
-*ACROSS APLHA_ACTUAL_DT AS '' ACROSS-TOTAL
ACROSS DDACTUAL_DATE AS '' ACROSS-TOTAL
COMPUTE XTITLE/A600 = TITLE ; AS 'TITLE'
COMPUTE XPUBLISHER/A256 = PUBLISHER ; AS 'PUBLISHER'
COMPUTE XPLATFORM/A6 = Platform; AS 'PLATFORM'
-*COMPUTE XDOC_ID/A8 = DOC_ID; AS 'BOOKDOI'
COMPUTE XDOC_ID/I10 = DOC_ID; AS 'BOOKDOI'
-*COMPUTE XDOC_ID/A50 = DOC_ID; AS 'BOOKDOI'
COMPUTE XPROPERTY_IDENTIFIER/A80 = PropertyIdentifier ; AS 'PROPERTY IDENTIFIER'
COMPUTE XISBN_PRINT/A50 = ISBN_PRINT; AS 'ISBN'
COMPUTE XISSN/A50 = ISSN; AS 'ISSN'
-*COMPUTE XDOC_ID/I10 = DOC_ID; AS 'BOOKDOI'
ON TABLE COLUMN-TOTAL AS 'TOTALS BY MONTH'
ON TABLE PCHOLD FORMAT &WFFMT

This message has been edited. Last edited by: Kerry,

Please share few sample data and expected result.
Also try PRINT verb instead of SUM.
Change I10 to D20.2 in COMPUTE XDOC_ID/I10 = DOC_ID; AS 'BOOKDOI'

By default, when SUM verb is used, LST will be applied for Alphanumber field and TOT will be applied for numeric field. Looks like its aggregating DOC_ID and field length goes beyong I10.

Thanks,
Ram

This message has been edited. Last edited by: Ram Prasad E,