Focal Point
[CLOSED] (FOC3215) FOLD-LINE

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/5097041196/m/5857036196

September 10, 2019, 01:11 PM
CD
[CLOSED] (FOC3215) FOLD-LINE
Hi,

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
September 18, 2019, 09:50 AM
CD
Chuck,

Thank you for your advises. I will try it.


WebFocus 8.0.0.8
Windows, All Outputs