Create Excel Based Reports Using FlexiMIS
Output parameters can be specified through a separate program which is a part of FlexiMIS [fleximis1.0.exe] offer. SQLBuilder. xls - which is a GUI for building SQL and formatting the reports - is intuitive and easy to learn. Use of mnemonic keywords in SQL helps the user to learn and remember the keywords rapidly.
Use of formulas in the report can make the task of complex reporting very simple. For example, if you need to show two distinct and very complex set of numbers against every entry in the first column of the report, then you can just write 3 queries and link their outputs by a simple " VLOOKUP" function in Excel. This keeps the individual queries simple.
FlexiMIS - 0.44MB also makes up for the difficulties or lacunae in SQL, like generating a cumulative total or removing duplicates. By using aggregation feature of FlexiMIS 1.0, you can just run a query to list out transactions and instead of individual values, you get the running balances directly. Also, calculating the percentage to subtotals can be done by simply inserting a single keyword. Another keyword can remove duplicates and show either first or last entry, as you wish.
FlexiMIS also allows you to pay for use, rather than a one-time license. The license cost is per database rather than one big license fee which can be difficult to absorb on one application.
What is new in official FlexiMIS 1.0 software version? - 29-Jul-2006 - Enhanced functionality. What is expected in the future? Newly-made FlexiMIS 1.1 be downloaded from current page, we also looking forward to unconfirmed 1.2 release build. You may download FlexiMIS.zip directly, estimated download time by ISDN or CDMA [~128 kbit/s] is 0:00:25. Just write the reviews of the FlexiMIS. System requirements are Windows (98 or above), MS-Excel (97 or above). Program has been scanned and verified by the several antivirus and anti-spyware applications and FlexiMIS found to be clean. No guide or FlexiMIS tutorial available. The following languages are supported by FlexiMIS: English.