Crystal Reports Cumulative sum not working in charts

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Cumulative sum not working in charts
	<< Prev Page of 2

Author	Message
moontide Groupie Joined: 23 Feb 2011 Online Status: Offline Posts: 78	Posted: 18 May 2011 at 8:04am
	Yes. the RT shows the correct value at the group footer in the report.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 May 2011 at 8:05am
	so are you trying to do a bar chart per month?
	IP Logged

moontide Groupie Joined: 23 Feb 2011 Online Status: Offline Posts: 78	Posted: 18 May 2011 at 8:09am
	I am actually doing a line chart per month. They want to see the trend lines across the months. e.g. The first value should be the starting number 3 and then 9, then 11 and 21 in the chart, but thats not happening.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 May 2011 at 8:12am
	chart = line (horizontal) data = advnced on change of use your same date fuield in your group and set it to monthly show value use only the RT that you verified in the rest of the report. (don't summarize should already be chacked as TRUE Edited by DBlank - 18 May 2011 at 8:12am
	IP Logged

moontide Groupie Joined: 23 Feb 2011 Online Status: Offline Posts: 78	Posted: 18 May 2011 at 8:41am
	They want the line chart to be set to vertical so that they could see the months on the x-axis (across). Anyways I did all the things you mentioned and also included to see the data value on the line chart but all i see is 20, 21 and 26 on the markers that i have set up. I also plotted the actual count of the structure have and it on the chart to compare the cumulative count and actual count, but the cumulative count is still showing strange values and are not adding up in the chart.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 May 2011 at 9:00am
	use the RT in your main report to tease out where there are unexpected numbers and look at your data to figure it out. If the RT is wrong the graph will be wrong. You can set the graph horizontal if needed, jut make sure to make your date field sort orter asc or desc to have it make sense. It naturally is asc which woul make your chart visually appear to descend in value rather than ascend in value.
	IP Logged

moontide Groupie Joined: 23 Feb 2011 Online Status: Offline Posts: 78	Posted: 18 May 2011 at 9:11am
	ok. It looks like the the asc or desc order is affecting how the values are spread out. I think its close now. THANK YOU SO MUCH for all the time you put in helping. God bless You Buddy !
	IP Logged

<< Prev Page of 2

Post Reply

Post New Topic

Printable version

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.078 seconds.