Crystal Charts and Trendlines

[shabejo75]

Hiya

I want to create a chart in Crystal that includes a 'target' line.

The data is grouped by order date (by month). For each month, I have generated a subtotal of the quantity field to show how many items were purchased each month.

I have a target to reach of 5 items per month which I would like to show on the graph as a line, but incrementing each month, e.g. month 1 the target was 5, month 2 it was 10, month 3 was 15 etc. I have created this as a formula field showing 5 in the group footer, then used a running total formula, to increment the numbers as above. The formula is:

whileprintingrecords;
numbervar runtotal;
runtotal :=runtotal + Quantity

I can show the quantity on the chart, but can't get the target to show. Can you not use a whileprintingrecords formula in a chart? Any ideas.

Thanks in advance

 

[Dan3D]

If you're totally stuck, be advised that there is a 3rd party add-in chart tool called CRChart which would solve this problem. It gives you the ability to assign a formula to a "user reference line" which sounds like what you want.

-Dan

Disclosure: I work for the company that makes this tool. This tool costs money.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com