Hi there

I am grouping my report in two levels:

Group1: Object Category
then
Group2: Object Location

At the Group2 Object Location level I want to show a count of how many objects are there in that Group2 location, under that Group1 category.

I've tried putting a running total field in the Group2 footer and, but don't seem to be able to get the correct counts out. I also tried doing a simple formula field with "count" commmand in it but that didn't work either.

Can anyone suggest what I'm doing wrong?

cheers
Karen

Hi there Kevlray, thanks for your reply..

I am retrieving a bunch of records, each containing a value in the "Object Category" field and a value in the "Object Location" field. I then want to run a report that will show me for each Object Category, how many records are in each Object Location. I am grouping the report by Object Category and then by Object Location. Within each Object Category group, I want to show how many objects (records) are in each Object Location group. No iteration of the running total field is counting it properly for me!

Here's an example data sample:

Record 1
Object Category = Agriculture
Object Location = Basement1

Record 2
Object Category = Agriculture
Object Location = Basement1

Record 3
Object Category = Models
Object Location = Basement1

Record 4
Object Category = Models
Object Location = Basement3

So then I want the output to be grouped like this:

Object Category: AGRICULTURE
Object Location: Basement1
No of Objects: 2

Object Category: MODELS
Object Location: Basement1
No of Objects: 1
Object Location: Basement3
No of Objects: 1

Too put it simply I just want to count the number of object records that occur within each Object Location Group.

I think it should be pretty simple to do but it's just not working for me!
cheers
Karen


Edited by karenb - 08 Aug 2016 at 1:30pm

The running total that you created appears to be correct.