Solved

Comparison Chart in Crystal Report

Posted on 2013-06-11
4
1,019 Views
Last Modified: 2016-09-07
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
Comment
Question by:josslmpd
  • 2
4 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
Create 2 formulas
SubmittedMonth
Month({SubmittedDate})

SubmittedYear
Year({SubmittedDate})

Create the chart using ONCHangeOf
SubmittedMonth then SubmittedYear

mlmcc
0
 

Author Comment

by:josslmpd
Comment Utility
Thank you.  I thought I needed a new formula, but I wasn't sure what to do with it.
0
 

Expert Comment

by:Karen A
Comment Utility
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

by:mlmcc
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now