Crystal XI Gantt Chart - Programmatically set X-Axis Min/Max

[DarthBobToo]

The subject just about says it all.

I'm using Crystal XI's Gantt chart functionality to show overlaps in scheduling. On the vertical axis, I may have an arbitrary number of items, but I've dealt with that in my underlying query by paging in groups of 25, then in Crystal I insert the chart into a header based on the page group.

My issue is this: I would like the horizontal axis of all charts to be set the same, regardless of what the actual minimum/maximum values are. I need to be able to do this dynamically because of the fact that I'll be comparing schedules for arbitrary date ranges, and not all pages may have overlapping timeranges.

As an example, the first schedule on the first page may start on 13-Apr-2010 1:00:00. On the second page, the first record may start 17-Apr-2010 15:00:00. By default, the minimum on the first page would be 13-Apr 1:00, and the minimum on the second page would be 17-Apr 15:00. I would like to be able to set them both to 13-Apr 1:00.

Thanks.

 

[lbass]

Select one of the horizontal axis labels->right click->data axis settings->scales tab->uncheck auto scale for min value and enter the datetime you want to see. Then in the main menu, with the chart still selected->chart->check "apply changes to all charts".

-LB

 

[DarthBobToo]

OK - I knew that was there, and it certainly works. However, what I need to be able to do is set this dynamically at run time from within a Crystal script.

I.e., to use a pseudo-OO example, I'd like to be able to set:
Graph1.yaxis.MinimumDate = '2010-04-01 00:00:00'
Graph1.yaxis.MaximumDate = '2010-05-01 00:00:00'

Is there any way to do this that you're aware of?

Thanks.

 

[lbass]

No, there is no current way to conditionally set the min/max axis points. I forgot you needed to do this dynamically.

-LB

 

[DarthBobToo]

I rather assumed that, just needed to confirm.

Thanks!