[UPHPU] custom reports

[Richard K Miller]

>> I'm building an MySQL database for a client which will contain
>> information about their clients. They are asking for the ability to
>> run custom reports. They don't need graphs or charting, but simply  
>> the
>> ability to build a custom query. The data will be in multiple tables.
>> They are used to being able to do this in Microsoft Access, which  
>> this
>> project will be replacing. What options are out there for providing
>> them a tool such as this?
>
> I've never done it myself, but it is possible to use MS Access as a
> frontend to MySQL. Since they are familiar with Access already, it
> might also make it easier for them to use.
>

Microsoft Excel and OpenOffice Base can also connect to MySQL. Both  
provide a simple query interface. If you're using Excel on a Mac I  
believe you'll need to install Microsoft Query. I also had to install  
the actualtechnologies.com MySQL ODBC driver. But it's been a couple  
years so perhaps some of the native drivers are working now.