Skip to Content
0
Former Member
Nov 12, 2008 at 06:55 PM

Can this be achieved with the Chart object in Crystal 11?

64 Views

Hi,

I need to control a bar chart X axis in a specific way.

I am wondering if this is in any way possible using crystal reports 11

could formulas somehow control the axis, or massage the data to get the result below?

My database holds information about weighments made at a machine

My database contains the following items in various tables, I am placing some hypothetical values before them...

3 pounds -Setpoint (the target weight)

0.2 pounds -Tolerance (weight variation that is acceptable)

0.01 pounds - Scale Accuracy

of course all of these change depending on the material

Also it includes actual weighments, which I need to display a count of for each weight, hypothetical values below

Weight Count

2.00lbs 1

2.70lbs 1

2.80lbs 2

2.82lbs 5

2.88lbs 15

3.00lbs 50

3.02lbs 20

3.03lbs 3

3.04lbs 2

7.00lbs 1

My Charts X axis would need to display all divisions of scale accuracy between the Setpoint - (2 x Tolerance) and Setpoint +(2 x Tolerance) and chart the weights in that range.

It also charts any weights that fall outside that range as individual points without including all the scale accuracy divisions, as in the 2lb and 7lb weighments.

So the chart for the above data would have an X axis with a point marked at 2.0, then right next to that a point marked 2.6 from there points at every 0.01, eg. 2.61, 2.62, 2.63 all the way to 3.4, then right next to 3.4 would be point marked 7.0.

Can I control the marking of the axis in detail this way with this data?

If this is unclear I have put a rough drawing of the resulting chart at

http://www.mesabicontrol.com/chart%20question.html

thanks in advance for any advice

mark