Migrate Crystal Reports to HTML - MySQL
We currently have a custom application running on an SQL server, we used Crystal Reports to generate reports that would query the database.
We are migrating our application to a private cloud hosted MySQL environment and need our current reports migrated to an "on demand" basis (as opposed to a Crystal user having to regenerate the data all the time) accessible via web browser (Firefox and Chrome). Formatting of the reports will need to be from the ground up in terms of coding.
Formulas from Crystal can be exported to provide detailed numerical calculations, however, table references have changed. We do have a full comparison of SQL vs MySQL tables available to aid in that regard.
Admin users will need to be able to alter formatting and formulas after the fact.
All users will need to have the option to open each report in a browser or download to a PDF, CSV or Excel for further analysis.
We are fully open to recommendations in terms of platform to be used ie. HTML 5 or otherwise.
Phase 1 = creation of existing "static" reports that already exist. There are currently 12 pre-existing reports with the ability to change date ranges, change office locations, aggregation of data and drill down to detail.
Phase 2 = allow users to create custom reports based on easy to use filters and variables. We will not detail these requirements in advance as further input is required but it is critical that the design allows for the addition of this functionality at a later date.