Graphs in crystal reports

[nkad]

I am trying to make a few pretty graphs in Crystal Reports. One of them is a bar chart which is suppost to graph how many records where created by the application software during a days period, within a monthly date range. Does that make sense?

Ok so have some sample data such as the following:

ID rDate
-----------------------
12 08/01/2003
13 08/10/2003
14 08/09/2003
15 08/10/2003
16 08/10/2003
17 08/10/2003
18 08/30/2003
19 08/31/2003

When I try to graph this I get the following results:

http://ragefu.3nq.net/samplegraph.jpg

Except, I sould get only 5 bar graphs, four bars with a count of 1 and one bar with a count of 4

Attached is the configuration of the Chart Expert.

[brucevde]

Crystal is counting the number of records and graphing the results every time the date field changes. Looking at your sample data there is a change on day 1, 10, 9, 10, 30, 31 - because that is the order of the data.

Make sure the data is sorted correctly, on the date field.

[nkad]

Darn, I swore I set the sorting on that. Ok well it works now. Thanks. If you don't mind Bruce, I have more questions...

Question 1:

If my group labels are dates, e.g. 8/1/2003 How can I format them as just the Day.
There doesn't seem to be a way to format the data on the group axis.

Question 2:

How can I make my graph display 31 bars, each with a count of the record grouping 'rDate' based on my sample data. In other words, how can I graph a date range, say 12/01/2003 to 12/31/2003 and make it display a bar for each
day even if the data isn't present in my sample data.