FlexiMIS component compliments the power of SQL and Excel with its own power. It takes the connection string, SQL queries and header string as inputs and 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 choice of either seeing the report on screen or saving it to disk or mailing to a pre-specified address (mailing requires a MAPI-compliant email client connectivity). The Multi-Report Mail feature converts the output of a single query into multiple report files and 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 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 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 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.
» version 1.0 - posted on 2006-08-21
29-Jul-2006 - Enhanced functionality.
EULA - End User License Agreement
FLEXIMIS SOFTWARE LICENSE:
1) GRANT OF LICENSE:
PRA-VI SERVICES grants you a single, non-exclusive license to use the FLEXIMIS provided you agree to abide by the terms of this Agreement. You are authorized to use the FLEXIMIS on one database.
2) OTHER RESTRICTIONS:
You acknowledge that you do not become the owner of the FLEXIMIS (software, programs and/or documentation). You agree not to transfer, rent,lease, sub-license, reverse engineer, modify, translate, or share the FLEXIMIS, diskettes, or manual with any other person or firm.
3) LIMITED WARRANTY:
While we have attempted to ensure the reliability of the FLEXIMIS, PRA-VI SERVICES cannot assume any liability for damage that occurs because of usage of this program, whether or not in accordance with the instructions or specifications. It is not possible to guarantee the program's performance under all circumstances, at all times, with all hardware and software configurations, and with any user data, programs, or series of commands. PRA-VI SERVICES warrants the diskette media and manual to be free from defects in materials or manufacture for a period of 30 days from your receipt. When you open this package or use the FLEXIMIS you indicate you accept this as the only warranty. You agree that regardless of the form of any claim, PRA-VI SERVICES's liability for any damages or loss to you or anyone else shall not exceed the price paid for use of the program. NO OTHER WARRANTIES. Except for the warranty described in the above paragraph, there are no warranties expressed or implied, including but not limited to, implied warranties of merchantability or fitness for a particular purpose, and all such warranties are expressly and specifically disclaimed.
4) NO LIABILITY FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES:
In no event shall PRA-VI SERVICES or its suppliers, if any, be responsible for any special, incidental or consequential damages whatsoever (including, without limitation, damages for lost profits, business interruption, loss of information, or any other loss) arising out of the use or the inability to use this product, even if PRA-VI SERVICES has been advised of the possibility of such damage. Some states do not allow the limitation or exclusion of liability for incidental or consequential damages, so the above limitation or exclusion may not apply to you.