|
MyReporter is a powerful windows (IIS) CGI script which will dynamically generate your report from the report template designed in MyCon, Mascon or FreeMascon live. You can choose to just display the report to the enduser in a webbrowser in PDF, XLS or RTF format or email it instead, all using just one call to the MyReporter CGI.
The MyReporter CGI includes two main parts:
- Report Generator, which will take your report template stored in either a file accessible to the CGI or a BLOB column of a report table or a template passed via a hidden webform field. The template will be run and your report dynamically generated using your current/live/real-time database data and displayed to the end-user in either PDF, RTF or XLS formats.
- SMTP Client, which you can use to either send a quick short email or optionally use to email your report as an attachment to the end-user.
Features:
- Live/Realtime MySQL data, thus no static manual reports
- Common formats supported and understood by everyone everywhere
- Support for Search Fields, thus if you want your report generated only for a specific period or account or order or customer ID, you can add a search field in the report template and pass the CGI your criteria, which will then be used to generate the report, see the Examples page for more details.
- The MyReporter CGI supports loading your database settings via an INI file which you can hide as to not expose your MySQL host, database, user or password to the end-user. This is ofcourse only an added security measure, because you can use an username and password which only has access to your MySQL Server from your webserver's IP in MySQL Security, thus it is an additional security measure on top of MySQL's own security. The CGI also includes a one way encryption routine, enabling you to encrypt your passwords for either MySQL or the SMTP server and store the encrypted version of the password in your INI file rather than the open text password.
Related software:
- You must use either MyCon, Mascon or FreeMascon to design your reports.
- You can download and take a peek at the Report Design Tutorial to help you understand and use the Report Designer in Mascon
- MyX is also capable of displaying these reports, but instead of a CGI you have full access to your MySQL data using an ActiveX object right from your ASP pages. Generating reports is just one of this powerful object's many features.
Installation Instructions:
- Download the MyReporter package
- Double click the download and follow the on-screen instructions to install the software
|
