Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Wanting to sum Consolidation accounts from Busines Post Reply Post New Topic
Author Message
Repent34
Newbie
Newbie


Joined: 03 Mar 2011
Location: United States
Online Status: Offline
Posts: 19
Quote Repent34 Replybullet Topic: Wanting to sum Consolidation accounts from Busines
    Posted: 03 Mar 2011 at 5:50am
I am trying to figure out the formula for summing some consolidation accounts from Businessworks Gold 2011 (BWG). I have the developers edition of CR for BWG so I can access the DB for BWG.

The account numbers from BWG "Chart of Accounts" are:
400000.000
419999.000
430000.000

The Table for "GLAccount" has the fields of "GLAccountNumber" and "Description" that show all the account numbers from the Chart of Accounts an a description of what that account number is for. When I drop those fields onto the report, I can see the accounts listed that I want to sum. I don't want to sum the account numbers obviously, rather, the dollar amounts that are listed for those account numbers.

These accounts are consolidation accounts inside BWG and as I understand it, they total several separate accounts to come to a "grand total" for those accounts.
I want to place the sum in the report footer.

How do I create a formula to sum all these values?

TIA;
Chris Edit/Delete%20Message
IP IP Logged
c16271
Groupie
Groupie
Avatar

Joined: 24 Aug 2010
Location: United States
Online Status: Offline
Posts: 48
Quote c16271 Replybullet Posted: 03 Mar 2011 at 6:04am
1) Select the field you want to summarize
2) Go to Insert
3) Select Summary
4) Choose 'Summary Location' you'd like to see the summary field (your case,don't chose anything, and press OK)

Hope this helps!!
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.