Gantt chart x-axis

[ShortyA]

Hi.

I am using CR XI against Oracle database via ODBC.

I have a main report which has 3 subreports. Each subreport has a chart showing all outages between two parameters (My_Start and My_End for example).

For each record the gantt chart shows mytable.startdate and mytable.enddate. All going well except that the x-axis is different for each chart. For instance the first chart may only have outages from 5th January so the axis starts there. For the other 2 charts they may have outages that start on 10th January and thus the x-axis starts at 10th Jan.

Is it possible to make this consistent ?

Many thanks - ShortyA

 

[espltd]

I ran into a close problem but was using a seperate query for each sub report. There is probably a way to set this range in Crystal Reports but I ended up modifying my data so each query would produce the same min and max values which ended up defining the range of the x axis.

 

[ShortyA]

Thanks for your reply. I think we are going to have to do the same, perhaps creating a stored procedure rather than making Crystal do the work.
ShortyA