Monthly, Quarterly reports, exports

We have milestones, Activities linked to the milestones and assigned to various resources. What I want to do is to define the period and export all activities and updates or notes to an excel spreadsheet. This means all tasks, notes or comments done during the specified time needs to be exported to a spreadsheet in a format: Milestone, activity, responsible resources, "work done".

is this possible and if so, how -or how should we use the system to provide us this capability.

What kind of effort will it take to get this done - keen to discuss this further

Let me first give overview of what we have and need to do in terms of the DFID contract:

We have milestones, some payment milestones and some normal milestones. The milestones contain detailed activities. All these are assigned to a resource with specific due dates. Our contractual reporting period is every quarter. At the end of each quarter we need to produce a report with a spreadsheet to the client and DFID indicating the work done against the schedule.

It can be that the consultant created various detailed tasks for each activity and assign them to other resources or even client resources. As these are done or new notes are added, we build the history. I did configure the system that on closure of an activity, one needs the capture the result field.

The spreadsheet contain the following columns:

Milestone, Activity, due date (quarter), Status, Responsible resource, comments (or we can use the Result field, but also the notes and tasks done within the quarter).

What I was thinking is what if there is a function where the user can define what fields to be used and in which order as well as level of detail. This is just an idea but could be helpful to everyone.