Hello

I have been asked to create a chart which shows Equipment failures based on Equipment type (there are 10 different equipment types in total) and within certain dates in which the user can define these within a parameter field.

I have successfully created a chart which looks is based on Change of Equipment type and counting the Equipment Type, but

The database contains information from 10/06/2010 till the present day, but they now want to be able to see the equipment failures prior to this date back as far as 01/01/2005!. I have been given this information as year totals but I cannot see or am struggling to incorporate these fixed values into the chart.

I have created formula's to calculate this but this was only based on 1 Equipment type which works but I was using the Running Total field then adding on the fixed data based on the date, but CR will not allow me to create a graph using this formula.

Can any tell me if this can be done and if so how.

If you need more information then please let me know.

Thanks for the reply,I would have thought that I should be able to create a formula or base a running total which can then be used in the chart.

Ok thanks I will give it a go and see what happens