Hi, I succesfully implemented a Gantt using bar charts, which came out (IMHO) really awesome, with lots of functionalities
As I have about 500 Gantt's to produce, each with a varying number of activities from 1 to 150 (...), this chart can really save my life but in order to be really able to use it, I have some more problems to resolve which are:
Y axis (the calendar):
It seem I can't decide the scale of the calendar (which depends by the format of the first expression)
What I mean is that I'd like to show "qq/yy" or "mm/yy" conditionally (if the range is >1year or not).
If I work with the number format on the graphic properties, I can apply a MM/YY format, but I can't apply QQ/YY and from the properties I can't do it dinamically: is there any other way?
Report and size of the bars:
As I'll need to produce an automatic report for each project, I'll need to split the Gantt in different pages when there are too many activities (I have up to 150). I also want to preserve the size of the bars (I don't want them to be stretched when there is only one activity). I haven't seen any possibility to split charts like tables when they are too long.
- I'm thinking about creating a new field ('Ganttcount') in the load script (but really dunno how) giving a number to each activity that will represent the number of the gantt, and use to that field to cycle the chart within each project. So if I want not more than 15 activities in a gantt and I have a project with 30, the first 15 will have Ganttcount:1 and the second 15 will have Ganttcount:2. Any other suggestion?
- I'd like to fix the size of the bars (I'll never have more than 15 activities with the point above, but I'll still can have less than 15...). The only thing I could think about, is a procedure to dinamically create new fake activities during the loading script in order to always have 15 activities per gantt (so in a project with only one activity, I'll create 14 fake invisible activities).... Is this really the only solution???? It sounds so complex..