Convert start end date to Gannt-type bar

[MSPJ]

Hi - THis was a tough subject line to come up with. Here's what I'm trying to do: I have a list of projects with start/end dates, but I want to display them in list view showing check boxes for each month of the year (or each quarter) that those projects occupy. The idea being that scanning the list visually, you can see for a given month, which projects are in progress.

The incredibly clunky way to do this would be to have many fields for each project for each month: 2010 Jan, 2010 Feb, etc, and then use calculations to see if that month is between start and end date. But then I'd have to have new fields as additional years are added, and clearly, this is not the way to do this!

I'm sure there's a more efficient and elegant way to do this, possibly with a repeating field - but I can't quite figure out how to do it.

Again - the months are needed for visual comparison. Essentially it would be like a very simple Gannt bar for each single task project. But I don't want to use MS Project because the rest of the information requires a database which I've already designed.

Perhaps there's an add-in that does a Gannt like presentation?

Thanks!

Michael

[Peter (duksis3)]

Take a look here:

http://www.hierarchy.lv/?page_id=111