Graphs in crystal reports

Printable View

Dec 19th, 2003, 02:53 AM
nkad

1 Attachment(s)

Graphs in crystal reports

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:

Code:

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.
Dec 19th, 2003, 04:19 PM
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.
Dec 19th, 2003, 05:08 PM
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.