Page 1 of 2
New User Question: How to total within a grouping
Posted: Thu Mar 26, 2009 6:59 pm
by Aaron
How do you total with in a group? When I ask this question, I am referring to a group that has like data within the group, and I need to total or sum that data within that group based off 2 values per record. when I try to sum that specific databand I get my totals at the bottom of the group, what I need is a total within the group per the like data. Let me know if you need more information.
Aaron
New User Question: How to total within a grouping
Posted: Fri Mar 27, 2009 9:57 am
by Edward
Hello Aaron,
Actually we need some more information. Do you need Running total inside the group?
Thank you.
New User Question: How to total within a grouping
Posted: Tue Mar 31, 2009 5:56 pm
by Aaron
Edward,
Hello!
I need totals within a group of information. For an example, I have various records that include data for: QTY, Description, Comments, Width, and Height. This Data is summarized by Material (GroupHeader). For the given information there are natural groups (which I have sorted by width then Height) that widths match as well as the heights. I need a subtotal for where the like dimensions are alike (width and depth separately).
Hope this helps!
Thanks,
Aaron
New User Question: How to total within a grouping
Posted: Wed Apr 01, 2009 2:44 pm
by Jan
Hello,
You need calculate total for each group ?
Thank you.
New User Question: How to total within a grouping
Posted: Wed Apr 01, 2009 7:31 pm
by Aaron
Jan,
I need a sub total within a group.
Thanks,
Aaron
New User Question: How to total within a grouping
Posted: Thu Apr 02, 2009 1:09 am
by Jan
Hello,
You can use following expression to show sum of two fields:
Code: Select all
{DataSource.FieldWidth + DataSource.FieldHeight}
Following expression to calculate total of this expression:
Code: Select all
{Sum(DataSource.FieldWidth + DataSource.FieldHeight)}
Thank you.
New User Question: How to total within a grouping
Posted: Thu Apr 02, 2009 9:51 am
by Aaron
I am not trying to sum the widths and heights. I am looking for a subtotal within the group of the quantities. I showed the width and length on the form to show the natural break. I need a subtotal of the quantities where both the width and height are the same.
New User Question: How to total within a grouping
Posted: Thu Apr 02, 2009 11:21 am
by Jan
Hello,
Use following expression:
Code: Select all
{CountIf(DataSource.FieldWidth == DataSource.FieldHeight)}
Thank you.
New User Question: How to total within a grouping
Posted: Thu Apr 02, 2009 6:22 pm
by Aaron
Jan,
If you would, please take a look at the attachment. The Width and Length are not the same, but there is a series of widths that are the same and in the same set of information the Lengths are the same as well. I need this set of information to sum the quantity for this set of information.
Thanks,
Aaron
New User Question: How to total within a grouping
Posted: Thu Apr 02, 2009 6:29 pm
by Brendan
It sounds like you may need a 2nd Group Header Band and Group Footer Band.
For the Group header band you could set the group expression to something like {Datasource.CutWidth}_{Datasource.CutHeight} and Set the Group header band height to zero.
Then place a group footer below the databand and drop a field on for {Sum(Datasource.QTY)}