Creating a Frequency Chart in Crystal Reports 10.0

[CJP12711]

I'm using CR 10, and am in need to create a chart. I have a table simplified below:

CaseID Amount
1 15
2 15
3 10
4 20
5 25
6 20
7 10
8 05
9 15

I'd like to create a chart to show the amount on the Y axis, and the number of times each amount is used in cases. So, it would roughly look like a bell chart, with the top of the curve being at 15, because it was used 3 times.

I've created a chart that shows the number of cases on the Y axis, and the dose ranges on the X Axis - this was done through a formula field. The chart says on change of dose range, do a distinct count on case ID. This doesn't look bad, but I need to swap it and have the dose ranges on the Y axis, and the count of cases on the X axis. Hopefully this makes sense!

As a bonus, is it possible to show the median and standard deviation for the chart?

Any help is appreciated.

Thanks!
CJ

 

[Dan3D]

If no one proposes a better solution, you might want to check out the CRChart add-on library. It has much better support for this kind of stuff.

-Dan


disclaimer: this product costs money. I work for the company that makes this product.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com