We have a MySQL database on a web server. We want to be able to generate a pre-formatted report that will pull data from the database and combine it with pre-established text. Once the report is generated (on screen) we need to have the ability to edit the text in the report before it is printed so that changes can be made or additional information can be added.
1. The report consists of 4 pages and includes the following: (a) logo and graphics that are fixed (will be the same and in the same location on all reports), (b) pre-established text that will be included in each generated report but we want to have the ability to edit this text for any individual report, (c) text that is combined with data from the MySQL database that can also be edited on each report in the event that we want to add information or override any of the data.
2. The ability to edit the report after it is generated but before it is printed is critical. It would be ideal if the report could be generated in Word or Excel so the user can easily make edits (since all of the users know how to use these programs) but other solutions are fine as long as the editing capability is easy to use.
3. There will need to be some simple interface so the user can select the customer for which they wish to generate the report as well as 2 or 3 fields that would be included in the report.
When bidding, please provide information in a PM on the approach that you will use for this project.