I have several questions on how exactly people have been allowing users to select data from a database to view in reports. Basically what I'm wanting is a Content Management System for reports. I'm sure I'll have to create business logic that based on what is selected it creates the appropriate references in the WHERE Clause (I.E. table.field = table1.field1). If anybody can point me into the right direction or if their is a third party software that allows me to do this in a web environment I would appreciate it. I am using sql 2000/2005 databases and asp pages.

Thanks,