Solved

# Comparison Chart in Crystal Report

Posted on 2013-06-11
1,074 Views
I am attempting to chart value changes over time.  I would like to see the numbers of items submitted over a particular time span (generated with a date parameter), grouped by year and by month.  My groups are correct as my counts seem accurate and I get the values that I want in a list form.  I want to visually display this in a chart, however.  Ideally, I want to display the side by side comparison of the months from each year next to each other so that I can see how the last year compared to this year.  My chart keeps giving my all of last year and then a space and then all of this year.  Is there a way that I can do this to achieve a side by side comparison?  A line graph would also be acceptable.  Thank you in advance for any assistance.
0
Question by:josslmpd
• 2

LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 39237925
Create 2 formulas
SubmittedMonth
Month({SubmittedDate})

SubmittedYear
Year({SubmittedDate})

Create the chart using ONCHangeOf
SubmittedMonth then SubmittedYear

mlmcc
0

Author Comment

ID: 39238121
Thank you.  I thought I needed a new formula, but I wasn't sure what to do with it.
0

Expert Comment

ID: 41788566
I adapted the suggested formulas for my situation and they worked great.   Now, can you suggest a way to create a parameter to choose which "years" you wish to compare?
0

LVL 100

Expert Comment

ID: 41788945
WHat do you want the user to enter?

A single year and then select data from that year and the previous year?

Selection formula will be

{YourDateField} >= Date({?Year} - 1, 1, 1)
AND
{YourDateField} <= Date(Year,12,31)

You could also select 2 or more years.

mlmcc
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…