Subject:Count Records? Author:Minollo I. Date:19 Apr 2006 01:20 PM
So the "typeX" names change dynamically and you need to retrieve them from the XML documents.
In that case you'll have to first create an outer looping structure that avoids duplicates and retrieves the single "typeX" items (easy to do if you are using XQuery), and then an nested computation that retrieves the count. If you search the forum for "grouping" or "distinct", you should find clues about how to do that.
and that gives me a distinct (1 entry per status), but also counts all of the items regardless of status and puts that number beside each one. Any help to finish this out, I would appreciate. Thank you very much.