I uses text editor to open two reports add FOLD-LINE. One report works as I expected. The other one showed the following error. I can't find any difference with using FOLD-LINE.
An error has occurred Detail: (FOC3215) FOLD-LINE INCOMPATIBLE WITH SPECIFIED OUTPUT FORMAT
Report 1 Having (FOC3215)
TABLE FILE CJCMS_TST/JMS_OFF_DIMREST_PROG BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.PROGRAM_START_DATE NOPRINT BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.PROGRAM_END_DATE NOPRINT BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.PROGRAM_ID AS 'Program' BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.PROGRAM_START_DATE/M-D-YY AS 'Start Date' BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.START_REASON AS 'Start Reason' BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.START_COMMENTS AS 'Start Date Comments' BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.START_USERINFO/A40V AS 'Start Case Worker' ON JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.START_USERINFO FOLD-LINE BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.PROGRAM_END_DATE/HMDYY- AS 'End Date,' BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.END_REASON AS 'End Reason' BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.END_COMMENTS AS 'End Date Comment,' BY JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.END_USERINFO AS 'End Case Worker' WHERE ( JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.SEQ_NUM EQ 0 ) AND ( JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.PROGRAM_TYPE EQ '1' ) AND ( JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.OFF_ENGAGE_ID EQ '1904862' ) AND ( JMS_OFF_DIMREST_PROG.JMS_OFF_DIMREST_PROG.PROGRAM_ID EQ 'CFC-Youth' ); ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE SET HTMLCSS ON ON TABLE SET STYLE *
Report 2 No Error
TABLE FILE CJCMS_TST/V_JMS_RPS_HEADER BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.OFF_ENGAGE_ID AS 'DOCR ID#' BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.MCPID BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.LAST_NAME AS 'LAST NAME' BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.FIRST_NAME AS 'FIRST NAME' BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.MIDDLE_NAME AS 'MIDDLE NAME' BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.BIRTH_DATE AS 'DOB' BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.AGE/I5 BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.SEX_CODE AS 'GENDER' BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.RACE_CODE AS 'RACE' BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.HOUSING BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.DATE_ADMITTED AS 'DATE/TIME ,ADMITTED' BY V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.PLANNED_RELEASE_DATE AS 'PROJECTED,RELEASE DATE'
ON V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.BIRTH_DATE FOLD-LINE ON TABLE SUBHEAD "INMATE INFORMATION" WHERE ( V_JMS_RPS_HEADER.V_JMS_RPS_HEADER.OFF_ENGAGE_ID EQ '1904862' ); ON TABLE SET NODATA ' ' ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE *This message has been edited. Last edited by: FP Mod Chuck,
WebFocus 8.0.0.8 Windows, All Outputs
September 11, 2019, 02:05 PM
FP Mod Chuck
CD
Your report that works has ON TABLE PCHOLD FORMAT PDF and your report that doesn't work does not have a ON TABLE PCHOLD statement which I believe will default to output format of XML. Add the appropriate output format statement to your first report.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats