I have BY field with a description that I want to reprint on every page of PDF output. Becuase of ACROSS field, the column which dont fit on 1st page are diplayed on 2nd page but end users are finding it difficuly to read those amounts bcoz there is no Account Nbr and its Description.
fex : TABLE FILE GABUD1 SUM TOT_MTH AS ' ' ACROSS BU_DESC AS '' BY RCP_NETIN NOPRINT BY GRP_CD1 NOPRINT BY CAT_14_CD NOPRINT -*I want to reprint this account nbr and its desc on every page*************** BY OBJECT_ACCT_CD AS '' BY ACCT_DESC AS '' -*********************** ON GRP_CD_DS SUBTOTAL AS '' ON RCP_NETIN SUB-TOTAL AS 'Net Cash Flow'
any suggestions?
Thanks,This message has been edited. Last edited by: Kerry,
December 03, 2008, 04:37 PM
GinnyJakes
Check out the BYPANEL command. That will allow you to repeat the BY phrases, as many as you want, on the subsequent panels.
TABLE FILE CAR
PRINT RCOST DCOST SALES
BY COUNTRY BY CAR BY MODEL
ON TABLE SET BYPANEL 2
ON TABLE SET ONLINE-FMT PDF
END
This message has been edited. Last edited by: GinnyJakes,