| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
Has anyone used the FRL, (Financial Reporting Language) ? It stands
to be very powerful in many respects.
I am having problems trying to select NOPRINT on a RECAP, but it
ignores me and says it doesn't know the keyword RECAP !!! I am doing
this because I need to make some intermediate calculations, (sum
a bunch of logarithms), before producing my results, sum totals
and an exponent of those logarithms.
skot
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 151.1 | Go call IBI ??? | 49ER::STEPHENS | California Computer Whiz | Wed Nov 09 1988 20:36 | 12 |
I found out I was meeting the same old problem of not having an
OVER at the end of the line. But I still encounter the problem where
It will generate a report with no lines or records. It shouldn't
do that, even if there was really no data !
I tried the report a couple of different ways and found that if
I stop the report in the middle, run it again, that it will crash,
leaving me with error number 000000, Internal system error, call
IBI!!! I have made sure I didn't do more than one recap and formatted
everything correctly, but it isn't working.
skot
| |||||
| 151.2 | Running but shaky | WLDWST::STEPHENS | California Computer Whiz | Fri Nov 11 1988 19:50 | 8 |
I was able to correct the problem by rearranging the columns and
using a "free text" with imbeded variables to accomplish what I
want. Looks really neat but I seem to get either 00000 Internal
Error or no error at all quite a lot using FRL. Isn't ANYONE else
using FRL out there ?
sk�t
| |||||
| 151.3 | Try using POST and PICKUP | WRO8A::BLUM | Mon Nov 14 1988 13:55 | 16 | |
Skot,
To save/use intermediate results with FRL, try using POST and PICKUP,
which are in the "Managing Data In The Report Request" part of the
the FRL section of the FOCUS documentation.
To avoid problems, make sure the field sizes are large enough to
handle the results of the RECAP calculations. If the field sizes are
too small, the data may get POSTed, but will store overflow characters
(*****), which will cause FOCUS to be unable to PICKUP the stored
data.
Regards,
John
(Another FRL user)
| |||||
| 151.4 | Another FRL user | GVAADG::PERINO | Joel PERINO @GEO | Fri Nov 18 1988 05:07 | 11 |
I discovered the FRL technique in FEXs written in a financial
application here in Geneva. Since then I used it many times
combined with the HOLD and the POST/PICKUP techniques to
do many kinds of report when the data are not well structured
at least for the specific output the user wants. FRL is easy to
learn and can solve very tricky problems.
With 5.2 I had some troubles with the POST/PICKUP techniques.
They are under investigation I'll tell you when better defined.
Jo�l
| |||||