FlexiMIS 组件以自己的功能来补充 SQL 和 Excel 的力量。它将连接字符串、SQL 查询和标头字符串作为输入，并生成格式正确、多页、相互关联的 Excel 工作簿作为报表。报表可以包含公式、函数、图形、数据透视表等。Fleximis 还可以添加小计、百分比等。您可以选择在屏幕上查看报表或保存到磁盘或邮寄到预指定的地址（邮寄需要符合 MAPI 的电子邮件客户端连接）。多报表邮件功能将单个查询的输出转换为多个报表文件，并将其邮寄给各自的收件人。 输出参数可以通过作为 FlexiMIS 产品/服务一部分的单独程序指定。SQLBuilder .xls是用于构建 SQL 和格式化报表的 GUI，直观且易于学习。在 SQL 中使用听记关键字可帮助用户快速学习和记住关键字。 在报表中使用公式可以使复杂报告的任务变得非常简单。例如，如果您需要针对报表第一列的每个条目显示两组不同且非常复杂的数字，则只需编写 3 个查询，并在 Excel 中通过简单的 "VLOOKUP" 函数链接它们的输出。这样使各个查询变得简单。 FlexiMIS 还克服了 SQL 中的困难或缺陷，例如生成累积总计或删除重复项。通过使用 FlexiMIS 的聚合功能，您可以运行查询来列出事务，而不是单个值，而是直接获取正在运行的余额。此外，只需插入单个关键字即可计算小计的百分比。另一个关键字可以删除重复项，并按您希望显示第一个或最后一个条目。 FlexiMIS 还允许您付费使用，而不是一次许可证。许可证成本是每个数据库，而不是一个大的许可证费用，这一点很难在一个应用程序上吸收。
版本历史记录
- 版本 1.0 发布于 2006-08-21
29-2006 年 7 月 - 增强功能。
软件信息
- 软件分类： 发展 > 组件和库
- 发布者： Pra-Vi Services
- 许可： 免费试用
- 价格： $999.00
- 版本： 1.0
- 适用平台： windows
终端用户许可协议
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.