Description from the Publisher
FlexiMIS component compliments the power of SQL & Excel with its own power. It takes the connection string, SQL query(ies) & header string as inputs & generates a properly formated, multi-sheet, interlinked Excel workbook as a report. The report can contain formula, functions, graphs, pivot tables, etc. FlexiMIS can also add subtotals, percentages, etc. You have the choice of either seeing the report on screen or saving it to disk or mailing to a pre-specified address. (Mailing feature requires a MAPI-compliant email client & connectivity.) The Multi-Report Mail feature converts the output of a single query into multiple report files & mails them to respective recipients.
Output parameters can be specified through a separate program which is a part of FlexiMIS offer. SQLBuilder.xls - which is the GUI for building SQL & formatting the reports - is intuitive & easy to learn. Use of mnemonic keywords in SQL helps the user to learn & 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 & very complex set of numbers against every entry in the first column of the report, then you can just write 3 queries & link their outputs by a simple "VLOOKUP" function in Excel. This keeps the individual queries simple.
FlexiMIS also makes up for the difficulties or lacunae in SQL, like generating a cumulative total or removing duplicates. By using aggregation feature of FlexiMIS, 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 & 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.