FlexiMIS
Rating
Downloads
: 203
|
Price : 999
Commercial
Size :
0.44MB |
|
|
Version : 1.0 |
New Release
|
| OS
Win98 , WinME , WinNT 3.x , WinNT 4.x , WinXP , Windows2000 , Windows2003
|
|
Create Excel based reports using FlexiMIS
This program 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 . This program 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 This program 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.
This program also makes up for the difficulties or lacunae in SQL, like generating a cumulative total or removing duplicates. By using aggregation feature of This program , 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 want.
This program also allows you to pay for use, rather than an one-time license. The license cost will be per database rather than one big license fee which can be hard to absorb on 1 application.
|
Requirements :
Windows (98 or above), MS-Excel (97 or above)
|
|
|
|
Questions or Problems with This Program ! |
Report Bad Link |
|
If you have any questions please post it and we will answer it asap .
[ Comments allowed for anonymous users, please dont register ]
|
So far so good :
No Comments :: No Problems :: No Answers
|
| |
Please Scan for Viruses before use .
