Print Page | Close Window

Grand Total Report Issue

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20937
Printed Date: 30 Apr 2024 at 9:24am


Topic: Grand Total Report Issue
Posted By: JabbaTechII
Subject: Grand Total Report Issue
Date Posted: 04 Aug 2014 at 4:16am
Hello all. I am new to this forum so please let me know if you see any room for improvement.

I have created a report which runs from our TrackIT(BMC) software to calculate the purchases made in a time span. It breaks it down to an individual PO and then gives a grand total at the end. For some reason it seems it is randomly multiplying certain POs but not all giving an in-accurate total. Any thoughts or pointers as to where I should start?


Replies:
Posted By: kevlray
Date Posted: 04 Aug 2014 at 4:25am
You did not mention how the grand total was generated.  Using the sum function, a running total or a formula using variables.

Posted By: JabbaTechII
Date Posted: 04 Aug 2014 at 4:30am
Sorry about that. I am using a formula.

{PURCHASE.TOTAL}-Sum ({PURCHASE.TOTAL})

Posted By: DBlank
Date Posted: 04 Aug 2014 at 8:52am
most likely you have 'duplicate' rows of data usually created by doing a join. like a PO table joined to an Order table that might have multiple rows of data with one PO number.
Note that hidden records are included in a SUm so suppressing them only changes how it looks not the actual total values.
Usually a Running Total is the easiest solution but it depends on your data set and report structure and sorting.
A Running Total can use an 'on change of' or formula to inciate to incldue or exclude specific rows.
Running Totals do not work in headers. 

Posted By: JabbaTechII
Date Posted: 07 Aug 2014 at 4:00am
I just tried using runningtotal with no luck. The running total works but I broke down the report to a similar form and I can now see that certain POs are being added to the report 2 or more times. I don't see any underlying formulas or commands that would cause this and my head is about to explode.

Posted By: JabbaTechII
Date Posted: 07 Aug 2014 at 4:17am
Further more I now see the following: I am pulling the PO based on the date received and the report is applying the PO total for each individual item of that PO:
Example:
PO ABC

Item 1 = $10
Item 2 = $5
Item 3 = $20
Total = $35

The report does the following:

PO ABC = $35
PO ABC = $35
PO ABC = $35
Grand Total = $105

Posted By: DBlank
Date Posted: 07 Aug 2014 at 5:58am
please explain the running total you created that did not work

Posted By: JabbaTechII
Date Posted: 07 Aug 2014 at 7:03am
I got it working now. Thanks for all the help.


Print Page | Close Window