Nick
>Is there a way that a user can create their own query through an interface and then generate a report from that query?
Look at Stonefield Query and Stonefield Reports. Your job will be much simpler, as those tools already have what you need.
www.stonefield.com