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.