I am having a problem getting a perfectly good report to run inside the pdf painter. Here is the result when I run the fex "standalone"
MATCH FILE VIEW_4
PRINT *
BY PS_ID NOPRINT
BY PS_ID NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-SET &S=3-1;
RUN
FILE VIEW_3
SUM *
BY PS_ID NOPRINT
BY Industry NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-MTCHLOOP;
AFTER MATCH HOLD OLD-OR-NEW
END
-RUN
0 NUMBER OF RECORDS SELECTED= 178 LINES= 178
0 NUMBER OF RECORDS SELECTED= 34 LINES= 34
0 LINES OF MATCH OUTPUT = 178
TABLE FILE HOLD
PRINT *
ON TABLE HOLD AS DETAILS FORMAT FOCUS
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 178 LINES= 178
-GOTO GOTMATCH;
-GOTMATCH
TABLE FILE DETAILS
PRINT *
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 178 LINES= 178
WebFOCUS Version 7.6.1 compiled and linked on Fri Apr 20 13:32:38 EDT 2007 (Gen branch761_hotfix:7)
-->
Here is what I get when I -INCLUDE that same fex into the pdf painter:
MATCH FILE VIEW_4
PRINT *
BY PS_ID NOPRINT
BY PS_ID NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-SET &S=3-1;
RUN
FILE VIEW_3
SUM *
BY PS_ID NOPRINT
BY Industry NOPRINT
-REPEAT MTCHLOOP FOR Q FROM 3 TO 3;
-MTCHLOOP;
AFTER MATCH HOLD OLD-OR-NEW
END
-RUN
0 NUMBER OF RECORDS SELECTED= 178 LINES= 178
0 NUMBER OF RECORDS SELECTED= 34 LINES= 34
0 LINES OF MATCH OUTPUT = 178
TABLE FILE HOLD
PRINT *
ON TABLE HOLD AS DETAILS FORMAT FOCUS
END
-RUN
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD
BYPASSING TO END OF COMMAND
-GOTO GOTMATCH;
-GOTMATCH
TABLE FILE DETAILS
PRINT *
END
-RUN
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: DETAILS
BYPASSING TO END OF COMMAND
COMPOUND END
WebFOCUS Version 7.6.1 compiled and linked on Fri Apr 20 13:32:38 EDT 2007 (Gen branch761_hotfix:7)
-->
I tried a cut and paste to put the code directly into the pdf painter, same result.
The really bad part is that I have not been able to recreate the problem using the EMPLOYEE and EMPDAT files.
Any Ideas?
Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC
In WebFOCUS since 2001