FlexiMIS component compliments the power of SQL and Excel with its own power. It takes the connection string, SQL query(ies) 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 the choice of either seeing the report on screen or saving it to disk or mailing to a pre-specified address. (This feature 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 t ...
Page 10 of 10
1 2 3 4 5 6 7 8 9 10