Requirement is that a report can have more than one filter. The user should be able to filter on any one of the filters. Also the user should be able to pick the fields to be included in the report at run time. Is this possible?

For example: Employee Report has Id, name, phone, address, city, state, field1, field2, field2, field 4. The user should be able filter the data on one or more of the following fields: city, state, field2. Also the user should be able to pick the fields (Lets say Id, name, field1) on the generated report.

How can we accomplish this?

Thanks.