Has anyone ever created reports dyanmically? We have been looking into sql reporting services but have found that the report layout must be previously defined. We would like a user to choose data through a web interface and then autmatically generate a report using .net. Anyone have any ideas on how this could be done?

I am looking for something that will not only support software teams but also teams outside of software development.