asked on

summing inside multiple groups

Hi experts,

how can i have do a sum inside group with different headings. For instance
i have Group headerA (Transactions) then detail and then its sum at the group footer. Then i have another groupheaderB (holdings) then detail and its sum at the group footer but when i put a text box in the footers such total transaction or total holdings in group footer a and group footer b..it shows up in both footers. In other words it shud be someting like this. Thanks for ur help

GHA -transactions
details
GFA- (total transactions a heading) and its sum

GHB - Holdings
details
GFB- total holdings a heading) and its sum

Pigster14

Instead of a label, input a text field.

Here is a sample of one report I have...

In the header there is:

="Investor " & [Investor Number] & " Block " & [Investor Block ID]

In the [] it is referencing the field you are grouping buy. In this case, I have several headers and footers depending on which Investor I am showing detail information for.

Here is an example of a footer that has a count function in it.

="Inst Num: " & [Bank Number Sub] & " New Accounts: " & Count(*) & " New Balance: $" & Format(Sum([Bal Prin]),"Standard")

Again, it is in a text field and not a label.

Hope this helps.

Thanks.

Pigster14

It appears you are already using text boxes instead of labels.....I guess I should read more carefully.

Pigster14

I am way off base. Let me start over... :)

You show the way you would like it to appear, however I am guessing that with having the two groups of headers and footers as you state it is really coming out as follows:

GroupA Header
GroupB Header
Detail
GroupB Footer
GroupA Footer

Is that correct?

zafridi

ASKER

no everything else is coming out rite the way i want it..its just at the footers i have to have different text such as
transactions total and holdings total..
im getting
groupA header
detail
then group A footer
then group b header
detail
then group b footer

which is fine i just wana be able to put different text next to the total in the footers

Pigster14

So when you look at the design of your report, do you really only have one footer and header?

You just want to pass in something to signify that this first group is Transactions and the 2nd group is Holdings?

zafridi

ASKER

no i have 2 headers and 2 footers

Pigster14

Can you post what is in the text boxes for each of these headers and footers?

Thanks.

zafridi

ASKER

Thats how it looks in the design
Gh1- Transactions
Gh2- holdings
detalils
Gf2 -transactions- numbers(sum of different columns)
Gf1-holdings- numbers(sum of different columns)

In preview i get this
gh2-transactions
details
gf2 -transactions -and its sum
gf1-holdings -and its sum
gh1
details
gf2 -transactions -and its sum
gf1-holdings -and its sum

My problem is where the group footers repeat themselves. each group footer comes once under its respective group header..do i need some sort of suppression or i dont know..thanks

ASKER CERTIFIED SOLUTION

Pigster14

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GRayL

Lets say your data looks like:

Class Type No

In the Header you select Class
In the Detail you select Type and No
In the GroupFooter you select Type and Sum(No)
In the ReportFooter you select Sum(No)

make sure you are not putting the Sum(No) in the Report footer and expecting to see the GroupFooter value