Creating a Sum for only one group

[klaidlaw]

I have Crystal Reports 11 Release 2

I have three groups. I want to only the total of the group2 endbalances for my Group One called Assests. I should do a running total but I need this number to be placed in the report footer and it will get messed up by other endbalances in the groups that come after it if I do. So I am not sure what to do any help would be great! Thank you

 

[lbass]

You can use a running total and make it specific to a particular group, e.g., select the summary you want, and then in the evaluation area, use a formula->x+2 and enter:

{table.groupfield1} = "Assets" and
{table.groupfield2} = "Furniture and Fixtures"

Reset never.

Place this in the report footer.

-LB

 

[klaidlaw]

when I did this formula:
GroupName ({@GroupAcctTitles}) = ["Cash and Cash Equivalents","Accounts Receivables","Inventory","Other Current Assets","Property, Plant and Equipment, Net", "Other Assets"]

I got this error:
A running total cannot refer to a print time formula, Details: Group 2 Name

When I had this formula:

({@GroupAcctTitles}) = ["Cash and Cash Equivalents","Accounts Receivables","Inventory","Other Current Assets","Property, Plant and Equipment, Net", "Other Assets"]

My answer was way off I am not sure of what I am doing wrong. I appreciate the help!!

 

[lbass]

You shouldn't be using the groupname. What is your report structure? What is your group #1 field? Your Group #2 field? Is the endbalance that you want to accumulate an inserted summary? Or a formula? If a formula, what is the content?

-LB

 

[klaidlaw]

The report is of all my accounts the third group is the accounts themselves. The second group is the accounts placed in groups such as Accounts Receivables, Cash, etc. Then the first group is the group 2 stuff placed into groups called Current Assets, Other Assets, etc. The Group 2 stuff all has their account totals for them and they are done by running totals because the way the information comes from the database it has to be like that. That Running total looks like this:

Sum Header.EndBalance
Evaluate on change of group 3
Reset on Group 2

Then there are totals for the group 1 stuff like total current assets, those are also done with running totals, because they way the information comes from the database I am using.That running total looks like this:

Sum Header.EndBalance
Evaluate on change of group 3
Reset on group 1

Basically what I want is the Total of the Current Assets and Other Assets to be at the bottom in the report header the problem is the two numbers I sum to get the total assets come from running totals. If you need any other information please let me know! I really appreciate all the help!!

 

[lbass]

I was looking for the fields you were grouping on, NOT the individual instances. Use a running total with an evaluation formula like this:

(
onfirstrecord or
{table.group#3field} <> previous({table.group#3field})
) and
{table.group#1field} in ["Current Assets","Other Assets"]

Use reset never.

-LB

 

[klaidlaw]

Thank you that worked!!