Combining info into a chart?

[pokerace]

C10

Not sure if this is the correct of the four Crystal forums, but if not, whcih one would be more appropriate?

I am going to create a report that uses two fields of data, which are {table.startdate} and {table.exitdate}. It will group the fields by year for 2003, 2004, and 2005 and within the group it will total the number of start dates and the number of exit dates for the year.

I would like to creat a chart for this info that breaks it down by year (probably automatic since that is how the report will be grouped) but also includes the number start and exit dates as seperate colums, preferrably the exits date colums will go down as if they were negative.

If the formatting works then the chart will look similar to this model, with X representing the colums.

|
| X
| X X
| X X X
| X X X
---------------------
| X X X
| X X X
| X X
|
03 04 05

 

[pokerace]

And my question is... can this be done and hwo should I try to do it?

 

[Madawc]

First get your report to group the data, working on it until it's the way you want it. Then use Insert > Chart and let Crystal guide you through.

If the same record can be in one year for start date and another year for exit date, then you had better use an alias. That's when you add the same table twice, and can look at it different ways.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10