Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: Comparisons of Summaries Post Reply Post New Topic
Author Message
dovrlrd
Newbie
Newbie


Joined: 10 Apr 2008
Online Status: Offline
Posts: 8
Quote dovrlrd Replybullet Topic: Comparisons of Summaries
    Posted: 10 Apr 2008 at 11:31am
Fairly new to Crystal Reports (but will be working with it far into the future...hopefully) and after bludgeoning some basic stuff together, I got slowed down trying to locate how to accomplish a task that seemed like it should have been more straightfoward.
 
Please help...
 
Summary:
 
Currently have a report that does the following:
 
Lists rows of a database for a particular Company ID, by Year and Month. It summarizes this by a COUNT of the Rows per Company by Month with a SUM of the dollar amount in a TOTAL_BILLED Field per row for the Company ID.
 
That step went rather smoothly.
 
Here's where I got stuck:
I want to add Summaries that compare the COUNTS and SUMS from one month to the previous Month and show changes (+ or -) between the months.
 
Is there an easy way to accomplish this? And, if I have to use somekind of  Month - (Month-1) Comparison, how do I deal with changes when the year rolls over?
 
Thanks
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 10 Apr 2008 at 11:38pm
i think u have to use arrays for this. if u read Brian's "Crystal Report Encyclopedia" page no. 632  u will know how to use arrays.
Thanks
Savan
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.000 seconds.