How to show a count and length summary within a group?
Hello. I'm trying to create a summary report of our pipes. There are 3 attributes to group on - Owner, Type and Status. Each unique combination of these 3 is a single line in the report. I did this by adding a Group Header band, and added the 3 fields as group fields. So far so good.
Now I need to add 2 additional numbers to each line in the report - the count of the features, and the sum of their length. I've tried using the count() and sum() functions in the group header band, but that shows the stats for the whole report, not just for each unique combination of the 3 attributes.
Any ideas on how to summarize by the group fields?
Thanks,
Chris
-
I had all sorts of difficulties to get my reports to sum how I wanted too!
One of the tips that really helped me was...
Select the label control, and navigate the right-hand panel to Properties > Data > Summary. Change the "Running" property to "Group". Once you do this, the expressions available from the expression editor will change.
Under Properties > Actions > Expression, use the (...), ellipsis button to open the expression editor.
Choose Functions > Summary from the left-hand panel there. This is where you'll find functions that can be properly applied to groups. The expression needed should be: sumCount( [StockSize] )
For my report I was trying to summarize stock size and Tree frame type counts per species. I ended up having to create 2 subreports (1 for stock size and 1 for frame type) but you may be able to get away with the running group option.
2 -
Hi Belinda. Thanks, that was just what I was looking for! In my case, I didn't have to create subreports, so it was easy once I changed from Running to Group.
Chris
0 -
Hi Chris - I am trying to do the same thing. but in my case I have my detail and I am doing the process duplicates compress. I only want to show one species name even if it found the same species but listed multiple times. But now I want to tell it how many or count the distinct species. Do you know how to do this?
0
Please sign in to leave a comment.
Comments
3 comments