Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Date Range Graph Post Reply Post New Topic
Author Message
maciaso
Newbie
Newbie
Avatar

Joined: 20 Mar 2008
Location: United States
Online Status: Offline
Posts: 11
Quote maciaso Replybullet Topic: Date Range Graph
    Posted: 25 Mar 2008 at 11:40am
Hi there,
I need some help creating a date range to display a graph.  The graph that I need should be in the period of " last 13 months to today".
 
I need to compare qty of order requested from last month to the same month a year ago; and keeping track or new orders for the current month.
 
Any help is appreciated.  OM.
 
OM
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 25 Mar 2008 at 7:56pm
That's a tough one because you want to plot two different time periods at the same point on the axis. What I would do is a SQL Expression which subtracts one year from the current date. That way you'll actually get the data for the second year appearing as if it was in the first year. You're also going to have to create another SQL Expression that just extracts the actual year from the date. Then you'll need to plot two lines with each line being from only one of the years. It's pretty tricky stuff, but that is the approach I would take.
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 IP Logged
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.031 seconds.