Print Page | Close Window

Comparisons of Summaries

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2885
Printed Date: 06 May 2024 at 8:22pm


Topic: Comparisons of Summaries
Posted By: dovrlrd
Subject: Comparisons of Summaries
Date 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


Replies:
Posted By: Savan
Date 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


Print Page | Close Window