Subsummary count is...not counting

[Matthew Miller]

Had what I thought was a fairly simply setup to create: in our student database, I need to build a report to show the number of households within each zip code.

So, I merrily create:

* a summary field holding the COUNT of field Zip (zSum_HouseholdsByZip)

* a layout based on the Household table (actually, a particular instance, holding the primary households)

* a subsummary part containing the summary field (and the Zip field, as an identifier) with Zip as the break field

* a couple fields in the body for filtering

Then I go to find mode, find our enrolled students, sort by Zip, and switch to Preview mode. Lo and behold, all the records are showing up sorting perfectly, but the subsummary field has numbers from 0-2 inclusive, while most of the groups contain 8-20 households. I can't figure out what's going on. :

Any pointers will be truly appreciated!

[bruceR]

Can you post an example file? And are you using the summary field that is correct for the context - since you mention different table occurrences?

[Matthew Miller]

I've attached a empty-cloned copy, with 5 records added to the [color:blue]Household table. The layout in question is [color:orange]RPT - Students By Zip

Re the correct field, I think so. The summary field itself ([color:green]HouseholdsByZip) I created in the [color:blue]Household table, referencing the [color:green]Zip field in the [color:blue]Household table.

The layout is based on the [color:purple]stu_stu2house_primary_HOUSE instance of the [color:blue]Household table. The subsummary part uses the [color:green]Zip field in [color:purple]stu_stu2house_primary_HOUSE instance, and on the layout I've put the [color:green]HouseholdsByZip field in the subsummary part. (I've just double-checked that those are all accurate statements). Did I do all that correctly?

_DataDBclone.fp7.zip

[comment]

Password?

[Matthew Miller]

Sorry, thought I disabled that. Use account mmiller with no password.

[comment]

1. The summary field on the layout is NOT from the same TO as the layout.

2. After you fix that, you may see that it's still not working until you reopen the file. I suspect your file may be corrupted.

[Matthew Miller]

Aha! I see it now. Thank you so much! Now it's reporting accurately.

Just for my information, what could have been done if the file turned out to be corrupted?

[comment]

Revert to last uncorrupted backup.