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
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 Bollmann Spartan Light Metal Products WebFocus 7.6.4 / iSeries / WebSphere
August 24, 2008, 12:19 AM
susannah
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.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 24, 2008, 01:15 PM
bbollmann
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
Brian Bollmann Spartan Light Metal Products WebFocus 7.6.4 / iSeries / WebSphere
August 24, 2008, 02:07 PM
Tom Flynn
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
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 Bollmann Spartan Light Metal Products WebFocus 7.6.4 / iSeries / WebSphere
August 24, 2008, 10:45 PM
susannah
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.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 25, 2008, 11:00 AM
bbollmann
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.
Brian Bollmann Spartan Light Metal Products WebFocus 7.6.4 / iSeries / WebSphere