FlexiMIS software generates Excel reports with extensive features like pivot tables, graphs, formulas and functions by running a simple SQL command. It facilitates auto-emailing and incorporates subtotals, percentages and growth ratios.
FlexiMIS is truly a powerful component that complements the power of SQL and Excel. With this tool, you are able to generate a properly formatted, multi-sheet, interlinked Excel workbook as a report by just inputting the connection string, SQL queries and header string. FlexiMIS has the ability to add subtotals, percentages, and much more to your report.
The flexibility in the choice of viewing options is what makes FlexiMIS stand out. You can either choose to see the report on the screen, save it to disk or mail it to a pre-specified address. The mailing feature requires MAPI-compliant email client connectivity. The Multi-Report Mail feature also allows a single query output to be converted into multiple report files and mailed to respective recipients.
What's unique about FlexiMIS is that it has a separate program that offers output parameters specification. SQLBuilder.xls, the GUI for building SQL and formatting the reports, is easy to learn and intuitive. The use of mnemonic keywords in SQL makes it easy for users to remember and learn the keywords rapidly.
FlexiMIS transcends the limitations of SQL by allowing the use of formulas in the report. This means you can show two distinct and very complex set of numbers against every entry in the first column of the report, just by writing 3 queries and linking their outputs by a simple "VLOOKUP" function in Excel. Additionally, calculating percentages and removing duplicates are easy with just a few clicks of a button.
FlexiMIS allows you to pay-per-use, rather than a one-time license. The license cost is per database, rather than a one big license fee that can be difficult to absorb on a single application. FlexiMIS is truly innovative, flexible and powerful - a must-have for any business looking for the perfect reporting companion.
The flexibility in the choice of viewing options is what makes FlexiMIS stand out. You can either choose to see the report on the screen, save it to disk or mail it to a pre-specified address. The mailing feature requires MAPI-compliant email client connectivity. The Multi-Report Mail feature also allows a single query output to be converted into multiple report files and mailed to respective recipients.
What's unique about FlexiMIS is that it has a separate program that offers output parameters specification. SQLBuilder.xls, the GUI for building SQL and formatting the reports, is easy to learn and intuitive. The use of mnemonic keywords in SQL makes it easy for users to remember and learn the keywords rapidly.
FlexiMIS transcends the limitations of SQL by allowing the use of formulas in the report. This means you can show two distinct and very complex set of numbers against every entry in the first column of the report, just by writing 3 queries and linking their outputs by a simple "VLOOKUP" function in Excel. Additionally, calculating percentages and removing duplicates are easy with just a few clicks of a button.
FlexiMIS allows you to pay-per-use, rather than a one-time license. The license cost is per database, rather than a one big license fee that can be difficult to absorb on a single application. FlexiMIS is truly innovative, flexible and powerful - a must-have for any business looking for the perfect reporting companion.
What's New
Version 1.0: 29-Jul-2006 - Enhanced functionality.