We've been converting FileMaker databases to Xanadu Web Apps over the past few years. One conversion category is Reports. Reports vary, but there are four types:
- 'Simple' with zero or minimal parameters with a simple query.
- 'Flexible' reporting on ad hoc record sets with a simple query.
- 'Forms' with data placed at specific coordinates.
- 'Customized' with complex formatting, more than one format, or multiple queries.
For most reports, we use mPDF, a popular open-source PHP library for generating PDFs. We'll create a header, footer, and body in HTML using CSS for the styling and applying ...