Subject:Count Records? Author:Dogmar S Date:19 Apr 2006 01:10 PM
Thank you. Yes, I have tried that. I think maybe I was not clear before. If I do that, then I get the same value for each one. What would be nice is to have like this:
type1 4
type2 3
type3 6
so that each has the value beside it. When I tried it with just the count, I did not know how to get the right count next to the right item. Thank you again.
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.