I am designing a project management database and for each project I have start date and end date. I want to make a view in filemaker pro which would be something similar to a standard project management tasklist; to show a colored bar staring from start date of the project till end date (or week) with weeks as columns and projects as rows.

Any suggestions, how can I do that?

Thanks in advance,

Aditya

Edited December 6, 200520 yr by Guest

This is usually done with repeating calculations that result in a container field. If you want a one year view by week you have a calculated container with 52 repetitions.

You usually want a field to contain your report start date and one for your report end date. Then each repetition of the display calculation determines whether your project is active during the timeframe that each field repetition represents.

I'm not in a position right now to write out the calculations but that's the starting point for you.