Hi,

I have the following in an FML report output to HTML. I want to use some of the data in a graph.


APP FILEDEF PCT018H1 DISK baseapp/PCT018H1.TXT
.
.
.
TABLE FILE PCT038F2
SUM
R1B01 AS ' '
.
.
.
R1B10 AS ' '
FOR
.
.
.
RECAP R30/D12.2%=(R11 / R29);
AS 'Operating Rate' NOPRINT OVER
RECAP R31/D12.2%=((&BCYCLE * R4) / (R13 * 3600)) * 100;
AS 'Performance Rate' NOPRINT OVER
RECAP R32/D12.2%=(R7 / R4) * 100;
AS 'Quality Rate' NOPRINT OVER
RECAP R33/D12.2%=R30 * R31 * R32 / 10000;
AS 'OEE' NOPRINT OVER


RECAP R35=R30;
AS 'Operating Rate' POST TO PCT018H1 OVER

RECAP R36=R31;
AS 'Performance Rate' POST TO PCT018H1 OVER

RECAP R37=R32;
AS 'Quality Rate' POST TO PCT018H1 OVER

BAR AS '-' OVER

RECAP R39=R33;
AS 'OEE' POST TO PCT018H1



I want to output the percentages for R30-R33 to a temporary file and used the "POST TO PCT018H1". In PCT018H1.TXT file, I get:

R30 ,********,********,********,********,********,********,********,********,********,********,$
R31 ,********,********,********,********,********,********,********,********,********,********,$
R32 ,********,********,********,********,********,********,********,********,********,********,$
R33 ,********,********,********,********,********,********,********,********,********,********,$

So, I told R30-R33 not to print and added the R35-R37 and R39 which gives me the records below in my PCT018H1. The values are also displayed on the HTML

R35 , 54, 39, 49, 60, 44, 48, 48, 41, 53, 11,$
R36 , 150, 111, 127, 100, 153, 164, 166, 120, 175, 48,$
R37 , 99, 99, 99, 99, 103, 98, 102, 100, 100, 266,$
R38 , 81, 44, 61, 60, 69, 78, 83, 49, 92, 14,$


If I let R30 print above, it prints 54.36%, but to get it to my file and print it at the same time, I just end up with the 54 for R35.

Any ideas to let me just use R30 and get the data out to the HTML and the PCT018H1 file with decimal (and optionally the percent sign)?!?!

This message has been edited. Last edited by: bbollmann,

brian,
i don't know the answer, but
did you try FILEDEFing a filetype other than .txt? I don't know that this is a problem, mind you, but if i were to try this, i would not have used .txt, i would have used an ordinary foctemp file, .ftm. foctemps can carry formatting, text files can't really.
Can you reproduce using the CAR file or one of the other app/ibisamp files so that we can run it and tinker (that's normally what we do here).
-S.

Thanks, here's more info...

Sample FML Report from CAR file
---------------------------------------------------
PAGE 1

ColHdg BHP RPM MPG
Sedan 866 27750 232
Hard Top 90 5000 25
Convertible 241 5750 16
Total 1,197.00 38,500.00 273.40
Blah Blah 9.62 5.55 9.30
----------------------------------------------------

APP PREPENDPATH ibisamp
APP FILEDEF TESTFML DISK bdb/TESTFML.ftm

TABLE FILE CAR
SUM
BHP
RPM
MPG
FOR
BODYTYPE
'SEDAN' AS 'Sedan' LABEL R1 OVER
'HARDTOP' AS 'Hard Top' LABEL R2 OVER
'CONVERTIBLE' AS 'Convertible' LABEL R3 OVER
RECAP R4/D12.2=R1 + R2 + R3;
AS 'Total' POST TO TESTFML OVER
RECAP R5/D12.2=R1/R2;
AS 'Blah Blah' POST TO TESTFML
ON TABLE NOTOTAL
END


-------------------------------------------------------

bdb/TESTFML.ftm

R4 , 1197,*****, 273,$
R5 , 10,*****, 9,$

Brian,

This works for me. I'm using 7.66, don't know what you are using???

  
APP FI TESTFML DISK BASEAPP/TESTFML.ftm
-RUN
TABLE FILE CAR
SUM
BHP/P6
RPM/P6
MPG/P6
FOR
BODYTYPE
'SEDAN'       LABEL R1        POST TO TESTFML OVER
'HARDTOP'     LABEL R2        POST TO TESTFML OVER
'CONVERTIBLE' LABEL R3        POST TO TESTFML OVER
RECAP R4/P12  = R1 + R2 + R3; POST TO TESTFML OVER
RECAP R5/P6.2 = (R1/R2);      POST TO TESTFML
ON TABLE NOTOTAL
END

Hope this helps...

Thanks Tom and Susannah.

It appears that (some of) the rules are:
- Column width (between SUM and FOR) must be >= to width of posted fields (or you get *****,9.62,****)
- RECAPs must use the same precision as the Columns or rounding occurs (set a D12.4 and got 9.6222 on report and 9.62 in temp file)

Feel free to add more!

Thanks again!

brian, i hope someone more fml-savvy will come along and help you, but it looks to me as tho the master for this receiving file is I4,I4,I4
(or maybe I5), which has a very default-y flavor to it. And that 2nd column is blowing out on row4, so then row5 inherits that blowout.

What does the master for TESTFML look like?
are you making one and saving it outside of the agent?
Can you post that master?
If in fact it is I5,I5,etc, then how about creating the TESTFML.mas master first, before you post to it, making sure its on the path, and make the receiving columns the format that you want, and making them big enough.

oh..i just saw your progress report posts..looks like you've got it. sounds totally reasonable.

Thanks Susannah and Tom.

From both of your suggestions, I did get this to work. I was offering the 'rules' above in my last post to help others when they try the FML and POST.