I'm creating a report designer for my customers so they can create any kind of report based on the data in a mysql table. These users have no knowledge of databases or queries so I need to make the UI as simple as possible. How can I present this in a way that allows tables with complex and deep joins. I understand that I can't possibly make it as simple that a 4th grader could use it, and I undertand they'll still need training on the usage. But I need to know how to make it flow logically so that it's easy to remember how to use. Any ideas?
This is a common need. Save yourself and your clients time and headaches by using one of the many existing solutions.
One quick example from googling:
And another Stack Overflow thread with a number of them listed: