Focal Point
Using Match Files in PDF Painter

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

April 25, 2008, 11:57 AM
rfbowley
Using Match Files in PDF Painter
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
April 28, 2008, 09:31 AM
PBrightwell
quote:
-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;


I'm not sure why this wouldn't work in PDF painter if it works outside of it. But why do you have the -REPEAT MTCHLOOP twice? Also, is it really from 3 to 3 which will run it once. And remove the ; from the tag
-MTCHLOOP


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes