Sub-Summary Report

[chzboi]

In a Sub-Summary report, which is viewed in preview mode, How do I create a field which displays the summary of items listed in the report? In other words, if the Sub Summary report lists 10 items based off of say 20 records, How do I create a field that says "10" either in the header or footer? Any advice is much appreciated!!

[danjacoby]

Create a field that returns a 0 if the key field is empty, and a 1 if it is not. Then create a summary field that is the total of this first field. Put it in the summary part.

[chzboi]

This is not what I'm looking for. This still gives me a total of the records in the report. If you use the example above, you still get a "20" instead of a "10". I'll try to explain myself better...

Example: If I have 10 records, 3 with the name "Joe", 2 with the name "Bill" and 5 with the name "Sue" and I want to create a preview report listing a summary of names, I would get a list of 3 names...

Joe

Bill

Sue

I'm in trying to create a field that states "3" for the number of items listed.

I hope this make some sense. Any advice is much appreciated!!

[Mike D.]

Create a self relationship based on your "name" field. Then create a calculation field NameCount = Count(SelfName::Name). Make sure the calculation is unstored.

The pitfall of doing this on a text field such as name is that if there are extra spaces before or after the name, you may get unexpected results.

HTH, Mike

[-Queue-]

It sounds like you want to create something similar to a duplicate record check, i.e. mark the first record that's unique and leave the remaining alone. This can be accomplished with a field whose calc is Min(SelfName::recordid) = recordid. Then create a summary total for this field and add it to a leading/trailing grand summary part.

[chzboi]

I'll give these things a try, thanks for the feedback!

[chzboi]

Would you be able to send a sample file of how this works?