I am looking for advice on giving my non-technical users the ability to create their own reports. For example, a user may want to include client name, phone number and address but not social security number. But anothe user may need all 4 fields. I would like a tool that allows my users to drag and drop fields ultimately making an ad-hoc report. This is a very simplified example and our data goes across many tables. So I would need the ability to give them the field data based upon complicated SQL views that IT writes but the user just needs to drag and drop what they need.
Does anyone know / use a product that does this? No sophisticated graphs or anything is needed. Just simple columns of data that can be brought into excel for further manipulation.