Crystal Reports displaying average on a chart

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: displaying average on a chart

Author	Message
vlntine82 Newbie Joined: 05 Dec 2006 Online Status: Offline Posts: 18	Topic: displaying average on a chart Posted: 02 Jan 2007 at 6:56pm
	Does anyone know how to display an average as a straight secondary line on a chart? Edited by BrianBischof - 02 Jan 2007 at 9:48pm
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 02 Jan 2007 at 9:41pm
	To plot the average on the chart, I created a formula which calculates the average as a running total. The I plotted that formula on the same chart that has the original value you are charting. Here is a sample of the formula: Global NumberVar TotalOrder; Global NumberVar OrderCount; NumberVar AverageOrder; OrderCount := OrderCount + 1; TotalOrder := TotalOrder + CDbl({Orders.Order Amount}); AverageOrder := TotalOrder/OrderCount;
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

vlntine82 Newbie Joined: 05 Dec 2006 Online Status: Offline Posts: 18	Posted: 03 Jan 2007 at 7:23am
	How do you plot a formula? I know how to create the formula, but what do I do to get it to plot on the chart?
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 03 Jan 2007 at 9:19am
	Same way you would plot any data point. When you have the Chart Expert open, it is in the Available Fields list along with all the other fields in the data source. Drag and drop it next to the other data point you want to chart.
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

vlntine82 Newbie Joined: 05 Dec 2006 Online Status: Offline Posts: 18	Posted: 03 Jan 2007 at 9:25am
	When I try to create the formula, I am getting the error "the formula result must be a boolean". How do I make it a boolean if I am wanting the average returned?
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 03 Jan 2007 at 9:29am
	Hmmm, don't know why you would be getting that. Something must be off for it to be expecting Boolean. Are you using Crystal Syntax and not Basic Syntax?
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

vlntine82 Newbie Joined: 05 Dec 2006 Online Status: Offline Posts: 18	Posted: 03 Jan 2007 at 9:42am
	It is set to Crystal Syntax. Also, there is an average function (Average ({graph_data.tmpData})) that I can use, but I still get the same result.
	IP Logged

vlntine82 Newbie Joined: 05 Dec 2006 Online Status: Offline Posts: 18	Posted: 03 Jan 2007 at 1:03pm
	I was able to get the formula to work. Now I need to make the title of the graph set to a parameter. Is this possible?
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.