Tasks based on Date range

V

Varan

hi

Is it possible to filter tasks on calendar date range as i need to prepare a report for the quarterly invoice details

And i want to list out the tasks that either starts or finishes or spans in the quarter
Quarter 1 : jan -Ma
I want to find out the effort of the projects of the periods as belo
1. Project 1 from dec- Feb 04 (Projects completes in this quarter
2. project 2 from Jan15 2004 to Mar 15 2004 (project starts & completes in this quarter
3. Project 3 from mar152004 to May 2004 (Project starts in this quarter but finished in next quarter
4. Project 4 starts in Dec 2003 and completest in May 2004 ( starts before the quarter & finishes after the quarter

How to find out the effort spend on these project for a date range jan -mar

Cheer
Varan
 
J

J Baird

Won't the built in "Date Range" filter find what you're looking for? In MSP
2002, from the Main Menu, select [Project][Filtered For][Date Range...] and
enter the desired dates.

If you write VB code, the TimescaledData funciton can find the work for a
date range.

Varan said:
hi,

Is it possible to filter tasks on calendar date range as i need to prepare
Click to expand...
a report for the quarterly invoice details.
And i want to list out the tasks that either starts or finishes or spans in the quarter.
Quarter 1 : jan -Mar
I want to find out the effort of the projects of the periods as below
1. Project 1 from dec- Feb 04 (Projects completes in this quarter)
2. project 2 from Jan15 2004 to Mar 15 2004 (project starts & completes in this quarter)
3. Project 3 from mar152004 to May 2004 (Project starts in this quarter but finished in next quarter)
4. Project 4 starts in Dec 2003 and completest in May 2004 ( starts before
Click to expand...
the quarter & finishes after the quarter)
 
V

Varan

No, the built in date range filter doesnt fetch the records based on the calendar days. It filters the projects which finishes & starts for the period range. If the project is still in progress during the period..it will not be fetched

varan
 
I

ITG_Mike

Varan,

At my company we do this reporting (date-range, specific project, etc) on the DB back-end using Crystal Reports (though any SQL report tool would do). As you have found, the PS reporting tools don't handle more complex (if you call date-range stuff complex) very well. There are a lot of other things that can only be done from the DB back-end, so these reports become quite useful.

Do you have someone that knows SQL that could build this for you? With a bit of study on the DB schema, this is not all that difficult.

Mike
 
V

Varan

Mike, thanks for the suggestion. I will def. look at the option of extracting data from the backend thr the crystal report tool

Thank
varan,
 
Top