Focal Point
[CLOSED] USING FML

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

October 30, 2009, 05:11 PM
Gabriel
[CLOSED] USING FML
Hello everyone!
I need help on FML of WebFOCUS and I need to do a report that is several columns have a column with all asset accounts and need to put aside all continuing liabilities and capital accounts but do not like this kind of report.
I hope I can help with this.
Greetings,
Gabriel Garcia

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


WebFOCUS ver. 7.6.7
Windows
HTML
October 30, 2009, 05:33 PM
Darin Lee
There are lots of reports I don't like to do as well.

There's a whole WebFOCUS manual on the subject of using FML called "Creating Financial Reports." It has lots of examples. That's probably where you should start.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
October 30, 2009, 05:36 PM
Darin Lee
However, creating a report with separate columns for Assets, Liabilities, and Capital accounts has more to do with defining columns properly than using FML. FML is usually for row-based manipulation of data using hierarchies.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
October 30, 2009, 05:48 PM
Gabriel
quote:
However, creating a report with separate columns for Assets, Liabilities, and Capital accounts has more to do with defining columns properly than using FML. FML is usually for row-based manipulation of data using hierarchies.

Regards,

Darin

Thanks Darin for your help. I will review the report so I can make
Greetings,
Gabriel Garcia


WebFOCUS ver. 7.6.7
Windows
HTML
November 01, 2009, 05:52 AM
FrankDutch
Gabriel

we have created many reports with FML.
it is a very flexible way of reporting, like an excel spreadsheet.

You mention a few subject and as far as I can see it are all balance related posts.
The start in this is however to have or create a good, logical hierarchy based on your General Ledger.
Once you have that you can rather easy create your reports.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7